Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Issue removing UTUT state of the table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Issue removing UTUT state of the table
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: 1439
Location: Bangalore,India

PostPosted: Wed Aug 13, 2008 9:18 am    Post subject:
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    Post subject:
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: 1439
Location: Bangalore,India

PostPosted: Wed Aug 13, 2008 9:31 am    Post subject:
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    Post subject:
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: 1439
Location: Bangalore,India

PostPosted: Wed Aug 13, 2008 9:37 am    Post subject:
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    Post subject:
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    Post subject: Remove, TS is in RW,UTUT
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    Post subject: Reply to: Issue removing UTUT state of the table
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    Post subject:
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    Post subject: Reply to: Issue removing UTUT state of the table
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: 1013
Location: India

PostPosted: Thu Nov 12, 2009 10:45 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
No new posts PC (UTF-8) -> z/OS (EBCDIC) -> ... prino All Other Mainframe Topics 4 Fri Sep 01, 2017 1:47 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us