Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Administration & Installation

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
17%
200 - 500 GB
29%
500 - 800 GB
3%
800 - 1200 GB
7%
1200 - 1500 GB
7%
1500 - 2000 GB
12%
> 2000 GB
24%
Total votes: 58

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 7th December 2018, 13:21
PugLife PugLife is offline
Junior Member
 
Join Date: Dec 2018
Posts: 5
PugLife is on a distinguished road
Baan: IV - DB: dunno - OS: HP UX 11.11
bdbpre question
Baan: Triton 3.1b
DB: Other/Unknown
OS: HP-UX 11.11
C/S: Server

Hi,

Tried to find this for myself on the forum but couldn't find what I was looking for or maybe unsure of what to look for.

I inherited an old HP UX Triton server which has not been used for some time now. Management wants me to export all db data and have it shut down permanently.

As I do not have any experience with Baan, please bear with me....

On the forum I found I should probabaly be using bdbpre to dump all of the tables to files what looks fine by me.

To execute, bdbpre wants me to define which table and company to dump. Is there any way to display these tables and companies or maybe a single command or different way to dump the entire db to file?

So far the command I intended to use:

bdbpre5.0 -Ntablename -Ccompanynumber > filename

Thanks!
Reply With Quote
  #2  
Old 7th December 2018, 13:39
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,232
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Do you know what database was used? Like tbase or something.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 10th December 2018, 10:21
PugLife PugLife is offline
Junior Member
 
Join Date: Dec 2018
Posts: 5
PugLife is on a distinguished road
Baan: IV - DB: dunno - OS: HP UX 11.11
I found a PID file from tbase but that file hasn't been changed since 2007. And I found some Informix files. Any quick way to check this?
Reply With Quote
  #4  
Old 10th December 2018, 10:44
günther günther is offline
Guru
 
Join Date: Jan 2002
Location: Ehingen, Germany
Posts: 585
günther is on a distinguished road
Baan: IVc4 - DB: Informix - OS: HP-UX
No sure about Triton, but in Baan IV a "ps -lu your_account" would show a inf_srv6.1 process if you are using Informix (while you are logged in to Baan).

Regards
Günther
Reply With Quote
  #5  
Old 11th December 2018, 23:06
PugLife PugLife is offline
Junior Member
 
Join Date: Dec 2018
Posts: 5
PugLife is on a distinguished road
Baan: IV - DB: dunno - OS: HP UX 11.11
Quote:
Originally Posted by günther View Post
No sure about Triton, but in Baan IV a "ps -lu your_account" would show a inf_srv6.1 process if you are using Informix (while you are logged in to Baan).
Thanks for the suggestion. ps -lu <some users name> gives:

1 S 125 5664 5663 0 158 20 4494d540 51 43298040 pts/tc 0:00 ksh
2001 S 125 5680 5678 0 154 20 43abc080 95 a7d260 ? 0:00 ba5.0
1 S 125 5678 5664 0 154 20 480f0bc0 247 a7d260 pts/tc 0:00 bshell5.0
1 S 125 5682 5678 0 154 20 48070b80 85 45bac7ae ? 0:00 bisam_srv5.0
1 S 125 5686 5678 0 154 20 4370a180 84 4671336e ? 0:00 bisam_srv5.0

When I look at the startupscript rc.start is says it is using Triton Base tbase5.0
So I suppose it is using tbase.
Reply With Quote
  #6  
Old 12th December 2018, 02:56
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,232
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Do you know where baan is installed? You could cd to that directory and look for like a lib directory and see if there is anything in tabledef6.1 - or another version of tabledef. For oracle this file contains some tables with the company number like tiitm001xxx - where xxx is the company number. Just not sure if tbase used that file or not. I typically cd $BSE/lib and would look at the files in there.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #7  
Old 20th December 2018, 01:22
PugLife PugLife is offline
Junior Member
 
Join Date: Dec 2018
Posts: 5
PugLife is on a distinguished road
Baan: IV - DB: dunno - OS: HP UX 11.11
Next are the files in bse5.0/lib, below the contents of tabledef5.0

triton# ls
BSFfonts bisamconfig.rene dtform1 dtopt4 fd5.0.operat1 install nlsinf shm_param.old2 textinf
bidsamcon.old bisamconfig_20071024 dtform2 dump fd5.0.operat1.rbr ipc_info ora srdd_tab5.0 tttiex301000.S
bisamconfig bisamconfig_20080303 dtform3 fd5.0.22Sc fd5.0.operat2 isamdef5.0 pet srdd_tab5.0.rene user
bisamconfig.12 bm_param5.0 dtform4 fd5.0.22Sc.pet fd5.0.operat3 isamdef5.0.new printinf sysconf
bisamconfig.kz bms_mask dtopt1 fd5.0.22Sd fd5.0.opere isamdef5.0.old rene tabledef5.0
bisamconfig.nw datecurr dtopt2 fd5.0.conv1 informix isamdef5.0.rene shm_param tabledef5.0.old
bisamconfig.or datecurr.nw dtopt3 fd5.0.ontwik ingres licence5.0 shm_param.old terminf

triton# cat tabledef5.0
*:000:bisam:N
*:100:bisam:N
*:*:bisam:N

Thanks for sticking with me!
Reply With Quote
  #8  
Old 20th December 2018, 15:22
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,232
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
And if you do not know company 000 is basically all the tools tables and stuff. Company 100 is where all of your real data would be - assuming they did not do anything weird when assigning tables to companies.

Glad you found your answers.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #9  
Old 24th January 2019, 10:42
PugLife PugLife is offline
Junior Member
 
Join Date: Dec 2018
Posts: 5
PugLife is on a distinguished road
Baan: IV - DB: dunno - OS: HP UX 11.11
Quote:
Originally Posted by mark_h View Post
And if you do now….. know company 000 is basically all the tools tables and stuff. Company 100 is where all of your real data would be - assuming they did not do anything weird when assigning tables to companies.

Glad you found your answers.

Well not just quite yet. I found this next def file which looks a lot more what I think I'm looking for:

triton# cat isamdef5.0
tosys:000:/users/bse4.3/own4.3
ttaad:000:/usr1/bse5.0/dict5.0
ttadv:000:/usr1/bse5.0/dict5.0
ttcon:000:/usr1/bse5.0/dict5.0
ttdbt:000:/usr1/bse5.0/dict5.0
ttiex:000:/usr1/bse5.0/dict5.0
tttst:000:/usr1/bse5.0/dict5.0
tttxt:000:/usr1/bse5.0/dict5.0
*:000:/usr2/bsp5.0
*:100:/usr2/bsp5.0/100
*:410:/usr2/bsp5.0/410
*:420:/usr2/bsp5.0/420
*:440:/usr2/bsp5.0/440
*:470:/usr2/bsp5.0/470
*:500:/usr2/bsp5.0/500
*:508:/usr1/bsp5.0/508
*:510:/usr2/bsp5.0/510
*:520:/usr2/bsp5.0/520
*:540:/usr2/bsp5.0/540
*:570:/usr2/bsp5.0/570
*:*:/usr2/bsp5.0


I'm not sure which numbers represent what for I never actually worked with BAAN myself. Which company numbers do I need to export to get our data out and which of these are just system tables?

Thanks!
Reply With Quote
  #10  
Old 24th January 2019, 16:06
vinceco252's Avatar
vinceco252 vinceco252 is offline
Guru
 
Join Date: Mar 2002
Location: Frederick, CO
Posts: 421
vinceco252 is on a distinguished road
Baan: Baan IVc3, IVc4, 5b, 5c, ERP LN 6.1, Infor ERP 10.x - DB: SQL Server, Oracle - OS: Windows, Linux, HPUX, AIX, (a little bit of) Solaris
Company 000 are the system/tools tables.

Vince
__________________
Vincent Murphy
---------------
ERP Practice Manager / Senior Consultant
OST
vmurphy@ostusa.com
Reply With Quote
  #11  
Old 24th January 2019, 17:27
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,232
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Quote:
Originally Posted by PugLife View Post
*:100:/usr2/bsp5.0/100
*:410:/usr2/bsp5.0/410
*:420:/usr2/bsp5.0/420
*:440:/usr2/bsp5.0/440
*:470:/usr2/bsp5.0/470
*:500:/usr2/bsp5.0/500
*:508:/usr1/bsp5.0/508
*:510:/usr2/bsp5.0/510
*:520:/usr2/bsp5.0/520
*:540:/usr2/bsp5.0/540
*:570:/usr2/bsp5.0/570
Thanks!
I think what is in bold above is what you should try to export. I can't say what data is in what company - 420 could be test or production, or a patch environment. Now if you wanted to try company000 you might be able to look at table ttaad100 to see if it tells you which company represents what. At least that is what is in our ttaad100 table on 4c4.

PS - I am basing this off what we have in one of our configuration files that tells oracle which table space which company goes into. Thinking that is the same for your file.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question handling through AFS avin_ln AFS/DDC/OLE: Function servers 18 26th March 2014 05:37
wild cards in Question joepte Tools Development 1 10th May 2012 07:27
Disable question (ttstpq0100) f.martel Tools Development 5 20th January 2010 15:26
Question on abort.program jcook331 Tools Development 2 29th November 2004 19:12
bdbpre / bdbpost problem with msql fmorais Tools Administration & Installation 4 23rd January 2003 18:45


All times are GMT +2. The time now is 04:40.


©2001-2018 - Baanboard.com - Baanforums.com