View previous topic :: View next topic
|
Author |
Message |
krithikaj
New User
Joined: 10 Aug 2008 Posts: 45 Location: India
|
|
|
|
Hi,
I have a table that can hold about 2billion records(LRECL=55). This table is ppulated everyday with 18million rows on an average. When I was trying to run control statement (-START DB(DBNAME) SPACENAM(TSNAME) ACCESS(FORCE)), the table showed ABNORMAL COMPLETION and the status was RW,UTUT, as such when I am unable to access that table.
I would like to know if there is anything that can be done to remove UTUT status.
Thanks,
Krithika J |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Krithika,
Quote: |
I would like to know if there is anything that can be done to remove UTUT status. |
Why do you want to remove the UTUT mode? Did you assess the util termination effects. |
|
Back to top |
|
|
krithikaj
New User
Joined: 10 Aug 2008 Posts: 45 Location: India
|
|
|
|
I would like to remove it and see that this this tablespace is in RW mode.
Also i am unable to query on that table and whenever I try to SELECT/UPDATE this table, I get -904 error.
Could you tell me if you need any more details that would help you in solving this issue.
Thanks,
Krithika J |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Krithika,
Quote: |
I would like to remove it and see that this this tablespace is in RW mode. |
Best and the safest way is to wait for the utility to release the lock.
If you think the utility is stopped, terminate the utility. If the TS is not in RW after util term, take appropriate action on the TS. |
|
Back to top |
|
|
krithikaj
New User
Joined: 10 Aug 2008 Posts: 45 Location: India
|
|
|
|
Actually the TS is in RW,UTUT now. Do you think the time the utility takes to release the lock does deppend on the # of rows in table?
One more question is which utility are you talking about...little confused?
Thanks,
Krithika J |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Quote: |
Do you think the time the utility takes to release the lock does deppend on the # of rows in table? |
Yes, provided utility is active.
Quote: |
One more question is which utility are you talking about...little confused? |
We have 'n' DB2 utilities. How do I know which utility are you running against the |
|
Back to top |
|
|
krithikaj
New User
Joined: 10 Aug 2008 Posts: 45 Location: India
|
|
|
|
Ok...I deleted few rows from this table (using SPUFI) before I used IBM uility.
Thanks,
Krithika J |
|
Back to top |
|
|
sachinbhavsar
New User
Joined: 15 Feb 2006 Posts: 9 Location: Stockholm,Sweden
|
|
|
|
Hi
could you please tel me which utility you used to remove TS from RW,UTUT state. |
|
Back to top |
|
|
krithikaj
New User
Joined: 10 Aug 2008 Posts: 45 Location: India
|
|
|
|
Go to Platinum and sel COMMAND PROCESSOR option. Enter "-Term Utility(database name)" and enter.
OR
in SPUFI, go to DB2 Commands and type "-Term Utility(database name)" and enter.
Thanks,
K J |
|
Back to top |
|
|
sachinbhavsar
New User
Joined: 15 Feb 2006 Posts: 9 Location: Stockholm,Sweden
|
|
|
|
Thanks, I am able to manipulate with table data now. |
|
Back to top |
|
|
ramangouda patil
New User
Joined: 09 Apr 2008 Posts: 39 Location: India
|
|
|
|
Isnt "-Term Utility(Utility name)" the command to terminate any stopped utility ?
The Utility name can be got from DISPLAY UTILITY command for that TS
Please correct me if I am wrong |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Ramangouda,
It will be UTILID.
Sushanth |
|
Back to top |
|
|
|