IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Issue removing UTUT state of the table


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
krithikaj

New User


Joined: 10 Aug 2008
Posts: 45
Location: India

PostPosted: Wed Aug 13, 2008 8:56 am
Reply with quote

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
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India

PostPosted: Wed Aug 13, 2008 9:18 am
Reply with quote

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
View user's profile Send private message
krithikaj

New User


Joined: 10 Aug 2008
Posts: 45
Location: India

PostPosted: Wed Aug 13, 2008 9:23 am
Reply with quote

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
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India

PostPosted: Wed Aug 13, 2008 9:31 am
Reply with quote

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
View user's profile Send private message
krithikaj

New User


Joined: 10 Aug 2008
Posts: 45
Location: India

PostPosted: Wed Aug 13, 2008 9:35 am
Reply with quote

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
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India

PostPosted: Wed Aug 13, 2008 9:37 am
Reply with quote

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
View user's profile Send private message
krithikaj

New User


Joined: 10 Aug 2008
Posts: 45
Location: India

PostPosted: Wed Aug 13, 2008 9:40 am
Reply with quote

Ok...I deleted few rows from this table (using SPUFI) before I used IBM uility.

Thanks,
Krithika J
Back to top
View user's profile Send private message
sachinbhavsar

New User


Joined: 15 Feb 2006
Posts: 9
Location: Stockholm,Sweden

PostPosted: Wed Nov 11, 2009 12:31 pm
Reply with quote

Hi

could you please tel me which utility you used to remove TS from RW,UTUT state.
Back to top
View user's profile Send private message
krithikaj

New User


Joined: 10 Aug 2008
Posts: 45
Location: India

PostPosted: Wed Nov 11, 2009 12:44 pm
Reply with quote

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
View user's profile Send private message
sachinbhavsar

New User


Joined: 15 Feb 2006
Posts: 9
Location: Stockholm,Sweden

PostPosted: Wed Nov 11, 2009 3:22 pm
Reply with quote

Thanks, I am able to manipulate with table data now.
Back to top
View user's profile Send private message
ramangouda patil

New User


Joined: 09 Apr 2008
Posts: 39
Location: India

PostPosted: Wed Nov 11, 2009 8:45 pm
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Thu Nov 12, 2009 10:45 am
Reply with quote

Ramangouda,

It will be UTILID.

Sushanth
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
Search our Forums:

Back to Top