expiration errors, now what

2015-11-18 Thread Lee, Gary
I have recently started having 1,698 errors during expiration. In tsm 5, you would audit the database. Now not sure how to go about determining then fixing the errors. Recently audited the disk pool, after having to rebuild the server from scratch. That took 72 hours. No errors were found at that

Client Management Service

2015-11-18 Thread David Ehresman
Does anyone know what IBM Passport is calling the 7.1.3 version of Client Management Service (CMS). I don't see a download file that sounds like it fits the description. David

Re: Does a DB2 db ever shrink?

2015-11-18 Thread Krzysztof Przygoda
Hi Check by q option if you have all reorg related options enabled (in 6.3.5 some are disabled by default). Then if they are on you can simply track progress of reorg process by checking actlog for those messages: ANR0293I,ANR0294I – table reorg status reorg ANR0317I,ANR0318I – index reorg statu

Re: TSM Expired Objects List...

2015-11-18 Thread David Ehresman
As Eric pointed out, QUIET=NO only shows detail down to the filespace level not the file level. I'm not sure what data you are looking for but maybe a select statement against the backups table looking for STATE='INACTIVE_VERSION' and an appropriate date comparison against DEACTIVATE_DATE would

Re: Does a DB2 db ever shrink?

2015-11-18 Thread Loon, EJ van (ITOPT3) - KLM
Maybe the space can only be released to the OS as soon as a DB2 reorg has finished for the tables in question, I don't know. In that case it could take up to 20 days before the space can be released... Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM:

Re: Does a DB2 db ever shrink?

2015-11-18 Thread Rhodes, Richard L.
Thanks! What is weird is that there doesn't seem to be anything to release. TSM is reporting that it has only 12,944 free blocks. After deleting 12% of the files (65m) and expiration completing, we were expecting the free blocks to be in the millions. I don't need the space back, I just wa