Today I tried to delete a table.

Therefore I deleted the table definition (ttadv4520m000) and then the table with ttaad4231m000. Then I run a Create RDD over all domains an tables.

If I check $BSE/dict/.... I find there still a file for this table. If I try to access this table via ttaad4100, the system asks me, if I would like to allocate the file... I didn't continue here, but normaly the system would create the table!!

Stange do some of you have similar experiences?


Thanks
Spartacus

Only that sometimes the RDD gets stuck in shared memory and sometimes have to bring shared memory up and down before seeing changes...any chance of that?

Hmmmm..... we have some tools objects in shared memory. But nothing like bdbreconfig, bdbpost ......

Spartacus

I had the same experience, even after I deleted the file in the dict dir somehow Baan "knew" about the table as my Runtime kept erroring out saying the Table DD was missing.

not sure how to "clear" the shared memory - but use the "srdd_init6.1 -p" command to see what tables are actually loaded. Maybe the table you deleted is in the shared mem as the previous post by lbencic.

spartacus,

The table's DD file will always be present as you might use the same table in another company. Deleting a physical table means you are removing it from the database. The table's DD is removed when you delete the table from the session-ttadv4520m000. Hence, when you go into the GTM to the same table and company it asks you if the table storage has to be allocated or not. If the table was deleted or if the table is new and no runtime has been done, and you go into the GTM and try to get into it then an error message is given - Data Definition t<table-name> not found.

NPrao,

that is what I said, I deleted the table with ttadv4520m000. If I use GMT the system still offers me, to allocate the space. It doesn't tell me, that there is no table definition -what it should do- ????

May it can follow the advice of nick and check the shared memory.


Spartacus

Nick,

is there a possibility to redirekt the output of srdd_init6.2 (ERP)?

I tried "srdd_init6.2 -p > foo" but it doesn't work. The program prints a lot of information, but to fast to follow.

Btw. I'm on a Unix system.

Spartacus

Hi,

the output of the portingset programs is send to standard error. So srdd_init6.2 -p 2>foo.

Bye,

Garfield:rolleyes:

Hi Garfield,

thanks, I think this will work.


Spartacus