SMQ1 QUERY PLZ

[Former Member]

HI EVERYBODY,

IF THE JOB SCHEDULED TO MOVE THE DATA FROM LBWQ TO RSA7. CAN WE FIND OUT THE STATUS IN SMQ1 (FOR QUEUED DELTA)

AND WHERE TO FIND OUT THE STATUS FOR (UNSERIALIZED DELTA).

WHAT ARE THE UPDATE TABLES USED IN (UNSERIALIZED DELTA) ARE THESE SAME FOR ALL THE DATASOURCES R ELSE THEY DIFFER FROM DATA SOURCE TO DATASOURCE.

THANKS AND REGARDS

NEELKAMAL

[Former Member · Accepted solution]

Hi Neel,

refer to OSS Note 378903 'Queue status in SMQ1, SMQ2 and table ARFCRSTATE' to look at the info related to the status inside SMQ1...

Hope it helps!

Bye,

Roberto

...about update table, this is always the same for all datasource (look in VBDATA and VBHDR tables...)

[Former Member · Accepted solution]

HI ROBERTO,

THANKYOU VERYMUCH FOR YOUR KIND INFORMATION WHICH IS VERY HELPFUL.

I FEEL VERY SORRY FOR MYSELF FOR ASKING AGAIN. CAN YOU KINDLY PROVIDE ME WITH THAT OSS NOTE AS I HAVE NO ACCESS.

THANKYOU VERY MUCH MY EMAIL ID IS SREEDHAR_NEELU@YAHOO.COM

THANKS AND REGARDS

NEELKAMAL