View previous topic :: View next topic
|
Author |
Message |
Antonio
New User
Joined: 01 Mar 2006 Posts: 1
|
|
|
|
Hi,
We have a strange situation if I use of
DISPLAY DATABASE(AAAAAAAA) SPACENAM(BBBBBBB) LOCKS and BBBBBBB is a TS partitioned.
The result: I don?t see the partitions.
NAME TYPE PART STATUS CONNID CORRID LOCKINFO
-------- ---- ---- ------------------ -------- ------------ ---------
E2515HC TS RW
E2515HC TS RW
With the command
DISPLAY DATABASE(XXXXXX) SPACENAM(YYYYYY) CLAIMERS/ USE
the result is:
NAME TYPE PART STATUS CONNID CORRID CLAIMINFO
-------- ---- ---- ------------------ -------- ------------ --------
E2515HC TS 001 RW
E2515HC TS 002 RW
E2515HC TS 003 RW
E2515HC TS 004 RW
E2515HC TS RW
This is normal? We have DB2V7
Thanks, |
|
Back to top |
|
|
amitava Warnings : 1 Active User
Joined: 30 Oct 2005 Posts: 186 Location: India
|
|
|
|
Hey Antonio,
After watching ur doubt, I also ran ur display command. But it is running fine. I think probably u have used the spacenam in two different commands are differrent(I mean to display the lock and to display the using space). I am sending you the command I ran and also the output -
Code: |
-DIS DB(RMWDEVEL) SPACE(RM0067*) CLAIMERS |
[img]DSNT360I -DBST ***********************************
DSNT361I -DBST * DISPLAY DATABASE SUMMARY
* GLOBAL CLAIMERS
DSNT360I -DBST ***********************************
DSNT362I -DBST DATABASE = RMWDEVEL STATUS = RW
DBD LENGTH = 524952
DSNT397I -DBST
NAME TYPE PART STATUS CONNID CORRID CLAIMINFO
-------- ---- ----- ----------------- -------- ------------ --------
RM0067TS TS 0001 RW
-THRU 0026
RM0067X0 IX 0001 RW
-THRU 0026
RM0067X1 IX L* RW
RM0067X2 IX L* RW
RM0067X3 IX L* RW
RM0067X4 IX L* RW
RM0067X5 IX L* RW
RM0067X6 IX L* RW
******* DISPLAY OF DATABASE RMWDEVEL ENDED **********************
DSN9022I -DBST DSNTDDIS 'DISPLAY DATABASE' NORMAL COMPLETION [/img]
Code: |
-DIS DB(RMWDEVEL) SPACE(RM0067*) LOCKS |
[img]DSNT360I -DBST ***********************************
DSNT361I -DBST * DISPLAY DATABASE SUMMARY
* GLOBAL LOCKS
DSNT360I -DBST ***********************************
DSNT362I -DBST DATABASE = RMWDEVEL STATUS = RW
DBD LENGTH = 524952
DSNT397I -DBST
NAME TYPE PART STATUS CONNID CORRID LOCKINFO
-------- ---- ----- ----------------- -------- ------------ ---------
RM0067TS TS 0001 RW
-THRU 0026
RM0067X0 IX 0001 RW
-THRU 0026
RM0067X1 IX L* RW
RM0067X2 IX L* RW
RM0067X3 IX L* RW
RM0067X4 IX L* RW
RM0067X5 IX L* RW
RM0067X6 IX L* RW
******* DISPLAY OF DATABASE RMWDEVEL ENDED **********************[/img]
[/code] |
|
Back to top |
|
|
|