Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
26%
500 - 800 GB
3%
800 - 1200 GB
9%
1200 - 1500 GB
12%
1500 - 2000 GB
12%
> 2000 GB
21%
Total votes: 34

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 7th December 2018, 14:21
PugLife PugLife is offline
Junior Member
 
Join Date: Dec 2018
Posts: 3
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
Sponsored Links
  #2  
Old 7th December 2018, 14:39
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,146
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, 11:21
PugLife PugLife is offline
Junior Member
 
Join Date: Dec 2018
Posts: 3
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, 11:44
günther günther is offline
Guru
 
Join Date: Jan 2002
Location: Ehingen, Germany
Posts: 578
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 12th December 2018, 00:06
PugLife PugLife is offline
Junior Member
 
Join Date: Dec 2018
Posts: 3
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, 03:56
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,146
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
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 06:37
wild cards in Question joepte Tools Development 1 10th May 2012 08:27
Disable question (ttstpq0100) f.martel Tools Development 5 20th January 2010 16:26
Question on abort.program jcook331 Tools Development 2 29th November 2004 20:12
bdbpre / bdbpost problem with msql fmorais Tools Administration & Installation 4 23rd January 2003 19:45


All times are GMT +2. The time now is 12:05.


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