Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I determine a table from a tablespace page?

Status
Not open for further replies.
zeat

zeat

Programmer
Oct 16, 2002
3
US
I have a job that occasionally fails due to an unavailable resource type 302 (tablespace page). The tablespace in question contains 49 tables. So the question is - how can I find the table given the tablespace page ID?

e.g DFPREC13.FSAPP013.X'000192'

Many thanks
Zeat
 
Sort by date Sort by votes
Can you tie back what you have in the above email to

SYSIBM.SYSTABLEPART
SYSIBM.SYSTABLES
SYSIBM.SYSTABLESPACE

Cheers
Greg
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question
Conditionally have a subfile display record blink 1
Replies
5
Views
760
mikrom
mikrom
evr72
  • Locked
  • Question
Update field from one table with a join table
Replies
1
Views
389
evr72
evr72
C
  • Locked
  • Question
AS400 Compile Error
Replies
8
Views
763
chuckw0325
C
handle907
  • Locked
  • Question
Tablespace utilization rate is 80% but only few small tables there.
Replies
0
Views
292
handle907
handle907
gdg1976
  • Locked
  • Question
hi all, input TAB1 COL1
Replies
0
Views
272
gdg1976
gdg1976

Part and Inventory Search

Sponsor

Back
Top