View previous topic :: View next topic
|
Author |
Message |
chandu_usa99 Warnings : 2 New User
Joined: 21 Sep 2006 Posts: 3
|
|
|
|
Hi,
Can some one help me regarding the MODIFY STATISTICS.
I am trying to clean the History tables in Prod.
//MODIFY EXEC DSNUPROC,SYSTEM=PA0D,
// LIB='PA0D.DSNLOAD',
// UID='ACDCSA'
//DSNUPROC.SYSIN DD *
MODIFY STATISTICS TABLESPACE DSNDB06.SYSHIST
DELETE ALL AGE(50)
It suppose to clean all the History tables, But its not cleaing.
Am I doing wrong? Please kindly help me out. Thank you so much. |
|
Back to top |
|
|
anamikak
New User
Joined: 10 May 2006 Posts: 64 Location: Singapore
|
|
|
|
1. Do have a look at the SYSPRINT DD. What is the message given in the SYSOUT?
2. what are the history tables you have checked to see is the statistics have been deleted?
3.Sice you have given age as 50, the utility would delete only data that are older than 50 days.
Anamika |
|
Back to top |
|
|
chandu_usa99 Warnings : 2 New User
Joined: 21 Sep 2006 Posts: 3
|
|
|
|
Hi Anamika, Yes I know it will delete only 50 days older history.
In the SYSPRINT it is given me that statement has been processed, I dont know what to do. Please help me out.
I checked all History tables , still having data in it.
SYSTABLEPART_HIST
SYSTABLES_HIST
SYSINDEXES_HIST
SYSINDEXPART_HIST
SYSCOLUMNS_HIST
SYSCOLDIST_HIST |
|
Back to top |
|
|
|