Go Back > Forum > Baan SIGs > Enhancements

Maintenance Warning will be unavailable on Saturday 26th of January from 12hrs until Sunday 27 of January at 18hrs (GMT+1) due to infrastructure upgrades.

User login

Frontpage Sponsor


Google search

How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 42

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 15th May 2003, 04:40
NPRao's Avatar
NPRao NPRao is offline
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,076
NPRao will become famous soon enough
Baan: Baan 4-5,5.2(Reger),LN-6.1,Infor LN-10.x - DB: Oracle,MS-SQL - OS: HPUX, Linux, Windows
Check Table's Data Dictionary

We have had many issues with the bdbreconfig and I guess we customize heavily. We have code migrations every weekend and a Table/Domain migrations every 2 weeks.

Among the major issues with the bdbreconfig is that the actual change did not happen on the tables in certain companies. And we used to use some fake changes on the table to trick (also posted on the board here) the create/convert runtime sessions to make it work.

The session Check Table - ttaad4232m000 gives us only a top view of the problems with the 506-tables do not exists, 512-corrupted DD, 2017-wrong database login/password etc.

Hence, we developed this tool which checks the BaaN and Oracle Data Dictionaries across all the company in all the databases and gives a report.

It will be nice if there are any verification tools in the standard tools to do this process for Oracle/Informix, DB2 etc.
Attached Files
File Type: doc check-table-dd.doc (136.5 KB, 175 views)
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote

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
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 06:38
What does Reorganize Tables do when you check Data and Indexex Joy Conner Tools Administration & Installation 3 13th August 2004 23:32

All times are GMT +2. The time now is 15:37.

©2001-2018 - -