Oninit cdi / Archive
Talk to an expert →

Dropping temporary TBLspace 200464, recovering

Posted in 2009

Topics: Storage & Space Management, Server Administration, Versions, Editions & End-of-Life

MARS CHEN — — source: IIUG Forums & Mailing Lists

Dear All.... I've noticed that while I onmode -ky IDS(my case,IDS 7.31.UD8) , I got the messages in online.log : Dropping temporary TBLspace 200464, recovering 8 pages. Dropping temporary TBLspace 200465, recovering 8 pages. Dropping temporary TBLspace 200467, recovering 8 pages. Dropping temporary TBLspace 200468, recovering 8 pages. Dropping temporary TBLspace 200469, recovering 8 pages. Dropping temporary TBLspace 20046a, recovering 8 pages. Dropping temporary TBLspace 20046b, recovering 8 pages. Dropping temporary TBLspace 20046f, recovering 8 pages. Dropping temporary TBLspace 200475, recovering 8 pages. Dropping temporary TBLspace 200482, recovering 8 pages. I wonder if there is a chance or what sql , let me know what's the content of these temp tables ?! I can run "oncheck -pt 0x200464 " before shutdown , but I don't know how to get the temp table's partnum by sql .. Any suggestions ?.. Thanks !!

↪ replying to MARS CHEN
rroussey@comcast.net — — source: IIUG Forums & Mailing Lists

Older version of IDS. Not a problem, just temp tables that didn't go away with the user sessions being cleaned up when IDS shuts down. Bob ----- Original Message ----- From: "MARS CHEN" <mars@jsun.com> To: ids@iiug.org Sent: Friday, October 23, 2009 6:43:56 AM GMT -05:00 US/Canada Eastern Subject: Dropping temporary TBLspace 200464, recovering [17733] Dear All.... I've noticed that while I onmode -ky IDS(my case,IDS 7.31.UD8) , I got the messages in online.log : Dropping temporary TBLspace 200464, recovering 8 pages. Dropping temporary TBLspace 200465, recovering 8 pages. Dropping temporary TBLspace 200467, recovering 8 pages. Dropping temporary TBLspace 200468, recovering 8 pages. Dropping temporary TBLspace 200469, recovering 8 pages. Dropping temporary TBLspace 20046a, recovering 8 pages. Dropping temporary TBLspace 20046b, recovering 8 pages. Dropping temporary TBLspace 20046f, recovering 8 pages. Dropping temporary TBLspace 200475, recovering 8 pages. Dropping temporary TBLspace 200482, recovering 8 pages. I wonder if there is a chance or what sql , let me know what's the content of these temp tables ?! I can run "oncheck -pt 0x200464 " before shutdown , but I don't know how to get the temp table's partnum by sql .. Any suggestions ?.. Thanks !! ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary