View previous topic :: View next topic
|
Author |
Message |
rexx77
New User
Joined: 14 Apr 2008 Posts: 78 Location: Mysore
|
|
|
|
Greetings,
I have loaded a particular table some time back, that was successful. This morning when i was checking the same table, i have got CHECK PENDING message.
I wanted to know when the table was loaded last time. I checked it in some SYSIBM tables, but not able to find any information.
If some one out there who knows any information regarding timestamp, please share it with me.
Regards |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hello There,
Have you checked in SYSIBM.SYSCOPY table? It should have entry with ICTYPE Operation type as
R - LOAD REPLACE LOG(Y)
S - LOAD REPLACE LOG(NO)
Y - LOAD LOG(NO)
Z - LOAD LOG(YES)
Then check respective value of IC Date & IC Time Column. |
|
Back to top |
|
|
rexx77
New User
Joined: 14 Apr 2008 Posts: 78 Location: Mysore
|
|
|
|
Thanks guptae for the information. It solved my question. |
|
Back to top |
|
|
|