View previous topic :: View next topic
|
Author |
Message |
Gurumanoj Gurusamy
New User
Joined: 11 Nov 2010 Posts: 22 Location: Mumbai
|
|
|
|
Hi,
I have a database which has four tablespaces. In which three are normal and the fourth one has CLOB objects.
When I tried to run a Runstats on database first three tablespaces runstats completed fine and its failing in the forth one which has CLOB. When I did a small study come to know that Runstats do not support CLOB objects. Hence I need to omit that particular tablespace while doing a runstats on database.
Could you please advise how to ignore it and do runstats on other tablespaces?
Thanks |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Which release of DB2 is being used?
If you post the job you submitted, we may be able to offer an alternative. |
|
Back to top |
|
|
saiprasadh
Active User
Joined: 20 Sep 2006 Posts: 154 Location: US
|
|
|
|
Below mentioned command will exclude table space from RUNSTAT.
Code: |
LISTDEF RUNLST
INCLUDE TABLESPACE DBNAME.*
EXCLUDE TABLESPACE DBNAME.CLOBTS
RUNSTATS TABLESPACE LIST RUNLST
TABLE INDEX SHRLEVEL CHANGE |
|
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
I think TABLE INDEX keywords are not supported for LOB tablespaces. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi Guru,
I hope you are using LISTDEF utility, below will select only the non-lob tablespaces in the database.
Code: |
LISTDEF TS_LIST
INCLUDE TABLESPACE database.* BASE
|
Thanks,
Sushanth |
|
Back to top |
|
|
Gurumanoj Gurusamy
New User
Joined: 11 Nov 2010 Posts: 22 Location: Mumbai
|
|
|
|
Thanks All,
I used Base keyword in LISTDEF and it worked. |
|
Back to top |
|
|
|