By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,557 Members | 1,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,557 IT Pros & Developers. It's quick & easy.

list database partition......

P: n/a
Hi All ,

I have a UDB 8.1 to look after, when i check on the DB partition groups, it
shows me only 2 groups ( as shown below) & misses IBMTEMPGROUP !!

I checked the IBM official documentation, they do say that when used show
details, "IBMTEMPGROUP" is not shown, but they do not give a reason as to
why it is not shown.

Anybody has an idea about this? Purely for information sake.

Regards,
GDR.

db2 => list database partition groups

DATABASE PARTITION GROUP
----------------------------
IBMCATGROUP
IBMDEFAULTGROUP
IBMTEMPGROUP

3 record(s) selected.

db2 => list database partition groups show detail

DATABASE PARTITION GROUP PMAP_ID DATABASE PARTITION NUMBER IN_USE
---------------------------- ------- ---------------------------- ------
IBMCATGROUP 0
0 Y
IBMDEFAULTGROUP 1 0 Y

2 record(s) selected.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.