Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 13th August 2004, 21:20
Joy Conner's Avatar
Joy Conner Joy Conner is offline
Guru
 
Join Date: Aug 2001
Posts: 375
Joy Conner is on a distinguished road
Baan: IVc4 - DB: MS SQL - OS: Windows Server 2008 & 2008 R2
What does Reorganize Tables do when you check Data and Indexex

I have just completed archiving and now I am trying to estimate how long it will take to run Reorganize Tables with data and indexes checked. We are single logistic / multi finance which means that most of our data is shared between companies. A few weeks back I executed this for the td package and for 5 companies. The process completed in 4 hours. Then I ran it again for the tc package which also completed in 4 hours.

I monitored both executions and observed that the first thing it did was reload the data for the first company and set the reference counters. When it was done with the first company, it set reference counters for the next company skipping the data load because the data is shared.

What I want to understand is how the program will run if I execute it for all packages and for the same 5 companies. Will it reload the data for all packages and all companies before it proceeds to the reference counters?

The reason that I am asking is when it reloads the data, my system generates informix logs and there are space considerations that need to be monitored while the data is being loaded.

I'm hoping that I can walk away from this process when it starts to reset the reference counters.

Any advice will be appreciated.
Reply With Quote
  #2  
Old 13th August 2004, 21:29
dave_23's Avatar
dave_23 dave_23 is offline
Guru
 
Join Date: Oct 2002
Location: Portland, OR
Posts: 1,303
dave_23 will become famous soon enough
Baan: All - DB: Oracle / MS SQL / DB2 - OS: All
Hi Joy,

It reloads the data first, then does the reference counters..

Since you're using a real database (not tbase) you could just use
an informix export/import to acheive the same thing, only faster.

Dave
Reply With Quote
  #3  
Old 13th August 2004, 23:22
Joy Conner's Avatar
Joy Conner Joy Conner is offline
Guru
 
Join Date: Aug 2001
Posts: 375
Joy Conner is on a distinguished road
Baan: IVc4 - DB: MS SQL - OS: Windows Server 2008 & 2008 R2
Does it matter if I use BaaN or Informix to recapture lost disk space after deleting records?
Reply With Quote
  #4  
Old 13th August 2004, 23:32
dave_23's Avatar
dave_23 dave_23 is offline
Guru
 
Join Date: Oct 2002
Location: Portland, OR
Posts: 1,303
dave_23 will become famous soon enough
Baan: All - DB: Oracle / MS SQL / DB2 - OS: All
That mostly depends on informix export..
You'll need to export in a way that will compress the data within the table
(i.e., not export blank rows)
I'm mostly familiar with Oracle, in oracle we would do this with
exp compress=y.
I would guess that informix would have something similar.

The upside to using the informix dump, is that the dump itself is faster, and
you don't have to rebuild reference counters after you're finished..

Dave
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


All times are GMT +2. The time now is 23:57.


©2001-2017 - Baanboard.com - Baanforums.com