Tablespace in UT state

gylbharat · Posted: Mon Feb 10, 2014 2:07 pm

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.

GuyC · Posted: Mon Feb 10, 2014 5:07 pm

maybe in SYSIBM.SYSCOPY.

gylbharat · Posted: Mon Feb 10, 2014 5:56 pm

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?

GuyC · Posted: Mon Feb 10, 2014 7:22 pm

maybe it is reflected in syslog, but can't verify at this client.

Akatsukami · Posted: Mon Feb 10, 2014 8:56 pm

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.

Rohit Umarjikar · Posted: Tue Feb 11, 2014 11:47 am

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.

gylbharat · Posted: Tue Feb 11, 2014 1:10 pm

Rohit Umarjikar · Posted: Tue Feb 11, 2014 1:20 pm

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.

gylbharat · Posted: Wed Feb 12, 2014 2:22 pm

I checked the DB2 logs, nothing in that.

I think when some one issues the statement

gylbharat · Posted: Mon Feb 17, 2014 6:38 pm

any idea how we can find this?

daveporcelan · Posted: Mon Feb 17, 2014 6:54 pm

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.....

Rohit Umarjikar · Posted: Tue Feb 18, 2014 12:57 am

Are you sure , that the the version of DB2 is unchanged?