cancel
Showing results for 
Search instead for 
Did you mean: 

ODS Activation Queue Information

Former Member
0 Kudos

Hi Experts,

I want the information about the Activation queue table, where it is stored in the database, the active data table and change log table information is stored in RSODSO AND RSTSODS, but what about the Activation queue of the obs objects, can anyone please let me know in which Database table it is stored, it would be of great help.

Thanks,

Hem.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Try looking for these tables for activation queue.

/BIC/Aodsname40 or /BI0/Aodsname40

regards

Former Member
0 Kudos

Thanks Vikash,

You really helped cleared my doubt, because when go to manage data targets for ods objects, there are four button, the new data button is the one which holds this table name, and hence this one is the activation queue table.

Thanks,

Hem.

Former Member
0 Kudos

Hi Vikash,

I have one more entry in my statistics table, there are three entries for the ods object tables, one which ends with 00, the other with 40 as u said, and one more is which ends with 50, could u please let me know what is this table about. it has the same fields as the 40 series table.

thanks,

Hem.

Former Member
0 Kudos

Hi Hem!

40 is for new data

00 for active data

50 for rollback (when activation process fails. system execute a rollback in order to assure DB consistency ! rollback is the opposite of commit command!)

Hope it helps!

Bye,

Roberto

Former Member
0 Kudos

Thanks a lot Roberto,

solved all the problems and doubts.

Hem.

Answers (0)