Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Tablespace in UT state

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Mon Feb 10, 2014 2:07 pm    Post subject: Tablespace in UT state
Reply with quote

Hi,

Recently, I found an issue where tablespace was in UT state and IUD job abended because of resource unavailable.

I am not able to figure out how/why the tablespace was in UT. Is there a way I can check that? We are on DB2 10 NFM.
Back to top
View user's profile Send private message

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Mon Feb 10, 2014 5:07 pm    Post subject:
Reply with quote

maybe in SYSIBM.SYSCOPY.
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Mon Feb 10, 2014 5:56 pm    Post subject:
Reply with quote

where in syscopy UT status is recorded?
I think some one ran a start database command to start the TS in UT mode. But where can i check this information?
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Mon Feb 10, 2014 7:22 pm    Post subject:
Reply with quote

maybe it is reflected in syslog, but can't verify at this client.
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Mon Feb 10, 2014 8:56 pm    Post subject:
Reply with quote

A status of UT indicates that the table space is being accessed by some DB2 utility. I don't know any means to check what utility run by whom through SQL (as opposed to DB2). In an case, it strikes me as a bad idea to merely shrug and reset the status.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Tue Feb 11, 2014 11:47 am    Post subject:
Reply with quote

Did you recently migrate to a new release of db2? If you had a tablespace in UT status while on the previous release and migrated without terminating the utility or cleaning up the UT status, you won't find the utility in the new version of db2 and therefore won't be able to terminate it. You'll have to fall back to the previous release, terminate the utility and clean up the status, then re-migrate. (I've had to do this in the past but always check now before migrating.)

we sometimes do intentionally putting structures in UT status to make sure nothing is accessing them before dropping. This allows our image copy jobs to run without failing (would fail if space is stopped) but also prevents any user access to the structures.

Hope this information helps.
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Tue Feb 11, 2014 1:10 pm    Post subject:
Reply with quote

Quote:

we sometimes do intentionally putting structures in UT status to make sure nothing is accessing them before dropping.


I think it was put in UT status intentionally by someone.. Is there a way to check that out?
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Tue Feb 11, 2014 1:20 pm    Post subject:
Reply with quote

1) Did you check the DB2 log for the same?

2)Also,Try the DB2 DIAGNOSE utility with DISPLAY SYSUTIL. Its a long time since I used it, but I remember occasions when there were no outstanding utilities shown in -DIS UTIL(*), but the DIAGNOSE utility included details of incomplete utilities.

3)Go to BMC CATALOG MGR and on the command line type BMCUTIL

If none works, then let us know, also i will update you if I get more information on this.
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Wed Feb 12, 2014 2:22 pm    Post subject:
Reply with quote

I checked the DB2 logs, nothing in that.

I think when some one issues the statement
Code:
- STA DB(DBNAME) SPACENAM(SPNAME) ACCESS(UT)
it does not get logged in the db2 log.

I don't have BMC. Display utility will only list utilities that are active/stopped in the system. In this case there was no utility running on the table. someone just put the TS in UT status for no application access.

I want to know is there a way to find out who ran the below command.
Code:

- STA DB(DBNAME) SPACENAM(SPNAME) ACCESS(UT)
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Mon Feb 17, 2014 6:38 pm    Post subject:
Reply with quote

any idea how we can find this?
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 645
Location: Pennsylvania

PostPosted: Mon Feb 17, 2014 6:54 pm    Post subject:
Reply with quote

I just counted.

You asked five times, the same question.

Not once did you get the answer you needed.

How many more times are you going to ask?

It may be time to pull the plug on this one.....
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Tue Feb 18, 2014 12:57 am    Post subject:
Reply with quote

Are you sure , that the the version of DB2 is unchanged?
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 Image Copy of a tablespace that conta... Robin Sulsona DB2 4 Thu Jun 02, 2016 1:47 am
No new posts IBMHPU - Tablespace and Imagecopy chaitanya bharath DB2 1 Fri Apr 15, 2016 5:54 pm
No new posts Clearing restrictive state aprocon DB2 4 Fri Jan 01, 2016 2:33 am
No new posts Query on Image Copy Tablespace and QU... vickey_dw DB2 3 Fri Oct 23, 2015 10:55 am
No new posts UNLOAD from Image Copy Tablespace wit... alluri12 DB2 5 Wed Sep 23, 2015 7:00 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us