| View previous topic :: View next topic |
| Author |
Message |
issac1029
Intermediate
Joined: 10 Dec 2005
Posts: 159
Topics: 75
|
 Posted: Fri Dec 29, 2006 11:18 pm Post subject: How to know the job name or the utility pend my space? |
 |
|
I run a DISPLAY in DB2 COMMAND LINE.
Then I found my tablespace is pending by other one's job or unility .
| Code: | | TSXXT075 TS RW,COPY |
Then I want to find out who job pending my tablespace, how to do with that ? |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Sat Dec 30, 2006 2:22 pm Post subject: |
|
|
issac1029,
You need to use the option CLAIMERS on the display command so that you can list all the jobs holding the resource.
| Code: |
-DISPLAY DATABASE(your db) SPACENAM(your ts name) CLAIMERS
|
Read about CLAIMERS by clicking me
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
anu.k
Beginner
Joined: 09 Nov 2006
Posts: 6
Topics: 4
|
| Posted: Fri Feb 09, 2007 10:51 pm Post subject: |
|
|
Hi Kolusu...
I tried this query in spufi..But it returns sqlcode -104 ..
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "DISPLAY". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: SELECT, INSERT, UPDATE, DELETE, OPEN, FETCH, CLOSE, ...
Plz advice.. |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Sat Feb 10, 2007 10:37 am Post subject: |
|
|
| anu.k wrote: | Hi Kolusu...
I tried this query in spufi..But it returns sqlcode -104 ..
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "DISPLAY". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: SELECT, INSERT, UPDATE, DELETE, OPEN, FETCH, CLOSE, ...
Plz advice.. |
anu.k,
You cannot run the DB2 commands in spufi. In the same DB2 Interactive panel you have option 7 to run DB2 commands. Option 1 is Spufi and option 2 is DCLGen ...
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
