Reduce DB in 6.2.2.2

[Alexander Heindl]

Hi,

I have a TSM-Server instance with a 188 GB Database:
Space Used by Database(MB): 188,032

Although deleting several (big) filespaces which are not needed anymore, 
database ist not shrinking. I thought with 6.1 (an 6.2) this is done 
automatically?

Best Regards,
Alex

__ 
Ing. Alexander Heindl

Generali IT-Solutions GmbH
WIs

Kratochwjlestraße 4, 1220 Wien
Telefon: +43 (0)1 53401-13160
Fax: +43 1 532 09 49 3160
E-Mail: alexander.hei...@generali.at

http://www.generali.at

Generali IT-Solutions GmbH, Sitz in Wien
registriert beim Handelsgericht Wien unter FN 215738 m
DVR-Nr.: 266. 
Die Gesellschaft gehört zur Unternehmensgruppe der 
Assicurazioni Generali S.p.A., Triest, eingetragen im 
Versicherungsgruppenregister der ISVAP unter der 
Nummer 026.
__ 



smime.p7s
Description: S/MIME Cryptographic Signature

Re: Reduce DB in 6.2.2.2

[Grigori Solonovitch]

To release DB space I am using for TSM 5.5:
1) estimate dbreorgstats
2) dsmserv UNLOADDB devclass= volumenames=
3) dsmserv LOADFORMAT ...
4) dsmserv LOADDB devclass= volumenames=
5) dsmserv AUDITDB fix=yes, if required

It takes time, but works fine.



Grigori G. Solonovitch


From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Alexander Heindl
Sent: Thursday, February 03, 2011 2:32 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Reduce DB in 6.2.2.2

Hi,

I have a TSM-Server instance with a 188 GB Database:
Space Used by Database(MB): 188,032

Although deleting several (big) filespaces which are not needed anymore, 
database ist not shrinking. I thought with 6.1 (an 6.2) this is done 
automatically?

Best Regards,
Alex

__
Ing. Alexander Heindl

Generali IT-Solutions GmbH
WIs

Kratochwjlestraße 4, 1220 Wien
Telefon: +43 (0)1 53401-13160
Fax: +43 1 532 09 49 3160
E-Mail: alexander.hei...@generali.at

http://www.generali.at

Generali IT-Solutions GmbH, Sitz in Wien
registriert beim Handelsgericht Wien unter FN 215738 m
DVR-Nr.: 266.
Die Gesellschaft gehört zur Unternehmensgruppe der
Assicurazioni Generali S.p.A., Triest, eingetragen im
Versicherungsgruppenregister der ISVAP unter der
Nummer 026.
__


CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail 
message and any attachments hereto may be legally privileged and confidential. 
The information is intended only for the recipient(s) named in this message. If 
you are not the intended recipient you are notified that any use, disclosure, 
copying or distribution is prohibited. If you have received this in error 
please contact the sender and delete this message and any attachments from your 
computer system. We do not guarantee that this message or any attachment to it 
is secure or free from errors, computer viruses or other conditions that may 
damage or interfere with data, hardware or software.

Please consider the environment before printing this Email.

Re: Reduce DB in 6.2.2.2

[Hart, Charles A]

Doest DB2 do Online Re-oirgs?  Or was the intend to clean up a 5.x DB for a 
migrate to 6.2? 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Grigori Solonovitch
Sent: Thursday, February 03, 2011 5:44 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Reduce DB in 6.2.2.2

To release DB space I am using for TSM 5.5:
1) estimate dbreorgstats
2) dsmserv UNLOADDB devclass= volumenames=
3) dsmserv LOADFORMAT ...
4) dsmserv LOADDB devclass= volumenames=
5) dsmserv AUDITDB fix=yes, if required

It takes time, but works fine.



Grigori G. Solonovitch


From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Alexander Heindl
Sent: Thursday, February 03, 2011 2:32 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Reduce DB in 6.2.2.2

Hi,

I have a TSM-Server instance with a 188 GB Database:
Space Used by Database(MB): 188,032

Although deleting several (big) filespaces which are not needed anymore, 
database ist not shrinking. I thought with 6.1 (an 6.2) this is done 
automatically?

Best Regards,
Alex

__
Ing. Alexander Heindl

Generali IT-Solutions GmbH
WIs

Kratochwjlestraße 4, 1220 Wien
Telefon: +43 (0)1 53401-13160
Fax: +43 1 532 09 49 3160
E-Mail: alexander.hei...@generali.at

http://www.generali.at

Generali IT-Solutions GmbH, Sitz in Wien registriert beim Handelsgericht Wien 
unter FN 215738 m
DVR-Nr.: 266.
Die Gesellschaft gehört zur Unternehmensgruppe der Assicurazioni Generali 
S.p.A., Triest, eingetragen im Versicherungsgruppenregister der ISVAP unter der 
Nummer 026.
__


CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail 
message and any attachments hereto may be legally privileged and confidential. 
The information is intended only for the recipient(s) named in this message. If 
you are not the intended recipient you are notified that any use, disclosure, 
copying or distribution is prohibited. If you have received this in error 
please contact the sender and delete this message and any attachments from your 
computer system. We do not guarantee that this message or any attachment to it 
is secure or free from errors, computer viruses or other conditions that may 
damage or interfere with data, hardware or software.

Please consider the environment before printing this Email.

This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.

Re: Reduce DB in 6.2.2.2

[Prather, Wanda]

Yes, it does online reorgs by default.  I think it checks every hour, and 
starts a reorg of any tables that need it.  It suspends the reorg if other 
activity picks up, and picks up where it left off when other activity is low.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Hart, 
Charles A
Sent: Thursday, February 03, 2011 9:08 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Reduce DB in 6.2.2.2

Doest DB2 do Online Re-oirgs?  Or was the intend to clean up a 5.x DB for a 
migrate to 6.2? 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Grigori Solonovitch
Sent: Thursday, February 03, 2011 5:44 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Reduce DB in 6.2.2.2

To release DB space I am using for TSM 5.5:
1) estimate dbreorgstats
2) dsmserv UNLOADDB devclass= volumenames=
3) dsmserv LOADFORMAT ...
4) dsmserv LOADDB devclass= volumenames=
5) dsmserv AUDITDB fix=yes, if required

It takes time, but works fine.



Grigori G. Solonovitch


From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Alexander Heindl
Sent: Thursday, February 03, 2011 2:32 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Reduce DB in 6.2.2.2

Hi,

I have a TSM-Server instance with a 188 GB Database:
Space Used by Database(MB): 188,032

Although deleting several (big) filespaces which are not needed anymore, 
database ist not shrinking. I thought with 6.1 (an 6.2) this is done 
automatically?

Best Regards,
Alex

__
Ing. Alexander Heindl

Generali IT-Solutions GmbH
WIs

Kratochwjlestraße 4, 1220 Wien
Telefon: +43 (0)1 53401-13160
Fax: +43 1 532 09 49 3160
E-Mail: alexander.hei...@generali.at

http://www.generali.at

Generali IT-Solutions GmbH, Sitz in Wien registriert beim Handelsgericht Wien 
unter FN 215738 m
DVR-Nr.: 266.
Die Gesellschaft gehört zur Unternehmensgruppe der Assicurazioni Generali 
S.p.A., Triest, eingetragen im Versicherungsgruppenregister der ISVAP unter der 
Nummer 026.
__


CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail 
message and any attachments hereto may be legally privileged and confidential. 
The information is intended only for the recipient(s) named in this message. If 
you are not the intended recipient you are notified that any use, disclosure, 
copying or distribution is prohibited. If you have received this in error 
please contact the sender and delete this message and any attachments from your 
computer system. We do not guarantee that this message or any attachment to it 
is secure or free from errors, computer viruses or other conditions that may 
damage or interfere with data, hardware or software.

Please consider the environment before printing this Email.

This e-mail, including attachments, may include confidential and/or proprietary 
information, and may be used only by the person or entity to which it is 
addressed. If the reader of this e-mail is not the intended recipient or his or 
her authorized agent, the reader is hereby notified that any dissemination, 
distribution or copying of this e-mail is prohibited. If you have received this 
e-mail in error, please notify the sender by replying to this message and 
delete this e-mail immediately.

Re: copypool-only TSM server on a VM

[Keith Arbogast]

Neil and Steve et al;
I appreciate your comments, though I am not the seer that dreamed of this.
...

The intention behind it could be to share tape drives without using a Library 
Manager, and to add TSM servers without buying more hardware.  Our TSM server 
databases and boot disk are on the SAN.  I'm confident the TSM/VM servers would 
be given the resources they needed.

One reasonable concern for building TSM servers on VM's would be that a 
virtualized server is not as stable as a physical server. Vmotion works most of 
the time. ESX hosts do crash, and if they lose their HBAs will take all their 
guests down with them. 

Best wishes,
Keith
 


   

TSM I Series client

[David W Daniels/AC/VCU]

Is anyone out there using successfully TSM to backup any iSeries(AS/400_
boxes? If so, where did you get the client from TSM or IBM? Also what are
the pros and cons.
** Don't be a phishing victim - VCU and other reputable organizations will
never use email to request that you reply with your password, social
security number or confidential personal information. For more details
visit http://infosecurity.vcu.edu/phishing.html

Re: Reduce DB in 6.2.2.2

[Joerg Pohlmann]

You might want to also look at:

http://www-01.ibm.com/support/docview.wss?uid=swg21452146&myns=swgtiv&mynp=OCSSGSG7&mync=E

also APAR IC69506 Automatic Index Reorgs of the Tivoli Storage Manager database 
does not occur.

Regards,

Joerg Pohlmann
250-585-3711

- Original Message -
From: "Prather, Wanda" 
Date: Thursday, February 3, 2011 9:46 am
Subject: Re: [ADSM-L] Reduce DB in 6.2.2.2
To: ADSM-L@VM.MARIST.EDU

> Yes, it does online reorgs by default.  I think it checks 
> every hour, and starts a reorg of any tables that need it.  
> It suspends the reorg if other activity picks up, and picks up 
> where it left off when other activity is low.
> 
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On 
> Behalf Of Hart, Charles A
> Sent: Thursday, February 03, 2011 9:08 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] Reduce DB in 6.2.2.2
> 
> Doest DB2 do Online Re-oirgs?  Or was the intend to clean 
> up a 5.x DB for a migrate to 6.2? 
> 
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On 
> Behalf Of Grigori Solonovitch
> Sent: Thursday, February 03, 2011 5:44 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] Reduce DB in 6.2.2.2
> 
> To release DB space I am using for TSM 5.5:
> 1) estimate dbreorgstats
> 2) dsmserv UNLOADDB devclass= volumenames=
> 3) dsmserv LOADFORMAT ...
> 4) dsmserv LOADDB devclass= volumenames=
> 5) dsmserv AUDITDB fix=yes, if required
> 
> It takes time, but works fine.
> 
> 
> 
> Grigori G. Solonovitch
> 
> 
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On 
> Behalf Of Alexander Heindl
> Sent: Thursday, February 03, 2011 2:32 PM
> To: ADSM-L@VM.MARIST.EDU
> Subject: [ADSM-L] Reduce DB in 6.2.2.2
> 
> Hi,
> 
> I have a TSM-Server instance with a 188 GB Database:
> Space Used by Database(MB): 188,032
> 
> Although deleting several (big) filespaces which are not needed 
> anymore, database ist not shrinking. I thought with 6.1 (an 6.2) 
> this is done automatically?
> 
> Best Regards,
> Alex
> 
> __
> Ing. Alexander Heindl
> 
> Generali IT-Solutions GmbH
> WIs
> 
> Kratochwjlestraße 4, 1220 Wien
> Telefon: +43 (0)1 53401-13160
> Fax: +43 1 532 09 49 3160
> E-Mail: 
> alexander.hei...@generali.at
> http://www.generali.at
> 
> Generali IT-Solutions GmbH, Sitz in Wien registriert beim 
> Handelsgericht Wien unter FN 215738 m
> DVR-Nr.: 266.
> Die Gesellschaft gehört zur Unternehmensgruppe der Assicurazioni 
> Generali S.p.A., Triest, eingetragen im 
> Versicherungsgruppenregister der ISVAP unter der Nummer 026.
> __
> 
> 
> CONFIDENTIALITY AND WAIVER: The information contained in this 
> electronic mail message and any attachments hereto may be 
> legally privileged and confidential. The information is intended 
> only for the recipient(s) named in this message. If you are not 
> the intended recipient you are notified that any use, 
> disclosure, copying or distribution is prohibited. If you have 
> received this in error please contact the sender and delete this 
> message and any attachments from your computer system. We do not 
> guarantee that this message or any attachment to it is secure or 
> free from errors, computer viruses or other conditions that may 
> damage or interfere with data, hardware or software.
> 
> Please consider the environment before printing this Email.
> 
> This e-mail, including attachments, may include confidential 
> and/or proprietary information, and may be used only by the 
> person or entity to which it is addressed. If the reader of this 
> e-mail is not the intended recipient or his or her authorized 
> agent, the reader is hereby notified that any dissemination, 
> distribution or copying of this e-mail is prohibited. If you 
> have received this e-mail in error, please notify the sender by 
> replying to this message and delete this e-mail immediately.
>

Re: Reduce DB in 6.2.2.2

[Dave Canan]

Alex, is the issue here that the database is not shrinking or is this a
question about reorgs? There are currently several APARs against the DB2
V9.7 that will not allow the DB to be reduced when reorgs occur. These will
be addressed in a future service level of TSM and DB2. If you have questions
about enabling index reorgs, you should contact TSM support for assistance.
There are several things to be aware of before index reorgs are enabled, so
PLEASE contact them first.

Also, if you'd like we could arrange a call here to discuss this further. I
realize the time differences involved, but we could arrange something. Let
me know.

Dave Canan
IBM Advanced Technical Support
ddcananATUSDOTIBMDOTCOM
916-723-2410



On Thu, Feb 3, 2011 at 3:32 AM, Alexander Heindl <
alexander.hei...@generali.at> wrote:

> Hi,
>
> I have a TSM-Server instance with a 188 GB Database:
> Space Used by Database(MB): 188,032
>
> Although deleting several (big) filespaces which are not needed anymore,
> database ist not shrinking. I thought with 6.1 (an 6.2) this is done
> automatically?
>
> Best Regards,
> Alex
>
> __
> Ing. Alexander Heindl
>
> Generali IT-Solutions GmbH
> WIs
>
> Kratochwjlestraße 4, 1220 Wien
> Telefon: +43 (0)1 53401-13160
> Fax: +43 1 532 09 49 3160
> E-Mail: *alexander.hei...@generali.at* 
> *
> **http://www.generali.at* 
>
> Generali IT-Solutions GmbH, Sitz in Wien
> registriert beim Handelsgericht Wien unter FN 215738 m
> DVR-Nr.: 266.
> Die Gesellschaft gehört zur Unternehmensgruppe der
> Assicurazioni Generali S.p.A., Triest, eingetragen im
> Versicherungsgruppenregister der ISVAP unter der
> Nummer 026.
> __
>
>

Re: TSM I Series client

[Prather, Wanda]

Yes.
I have customers who have used it successfully, and customers who have found it 
inadequate.
Whether it works for you depends largely on the amount of data per day you have 
to deal with.

The code is on the FTP site.
ftp://ftp.software.ibm.com/storage/tivoli-storage-management/maintenance/client/v5r5/OS400/v553/

It's not a "client" like the windows or Unix client, it's an API for BRMS.
BRMS is a backup product for the I-Series.  The API lets BRMS send data to TSM.

Pros:
*   If the customer is already using BRMS, the setup is very easy.  Follow 
instructions in the redbook.
*   You install the API on the I-Series, and that gives BRMS an additional 
destination to select for sending data.  Your I-Series folks don't really need 
to learn anything new, they still use their BRMS interface, run their BRMS jobs 
like always, the data just goes over the network to TSM instead of to local 
tape, making their lives easier.
*   Easy way to get your AS400 data to TSM media and rolled into your DR 
vaulting scheme.
*   No license required.

Cons:
*   If the customer isn't using BRMS already, it's a steep learning curve 
(BRMS may be a $cost item for I-Series, not sure).
*   You can only send "library" data to TSM, the bootable system/OS backup 
(sorry I don't know the I-Series name for that) still has to be done to local, 
I-Series-readable media - usually a DVD.
*   Speed is the big issue.  There is something funky about the API so that 
you get SLOWER than GIGE speed. Dunno why there has been no initiative in 
Tivoli to fix that (or if the problem is on the BRMS side).  But plan on it 
being relatively slow.

If the customer is doing local backups to 3490-style tape now, switching to 
Tivoli will be the same speed or even faster, and it will be a good thing.

If the customer is doing local backups to LTO3-4 tape now, switching to Tivoli 
will slow things down.  If there isn't too much data, fine.  You might be able 
to deal with it by rescheduling some backups - was able to work it at one 
customer by running backups in parallel instead of serially.

If you have less than 400GB per day to back up, you can probably make it work.
More than that, it will probably not be satisfactory.
YMMV



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David 
W Daniels/AC/VCU
Sent: Thursday, February 03, 2011 11:30 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] TSM I Series client

Is anyone out there using successfully TSM to backup any iSeries(AS/400_ boxes? 
If so, where did you get the client from TSM or IBM? Also what are the pros and 
cons.
** Don't be a phishing victim - VCU and other reputable organizations will 
never use email to request that you reply with your password, social security 
number or confidential personal information. For more details visit 
http://infosecurity.vcu.edu/phishing.html

Windows 2008 System State Backup: Incremental

[Moyer, Joni M]

Hi Everyone,

Does anyone know what version of the TSM Windows Client is needed in order to 
only do an incremental system state backup?  And does anything special need to 
be done once I have the client upgraded to the needed release?  This is needed 
more for my Windows 2008 servers which have large system state backups.

Thanks in advance!




This e-mail and any attachments to it are confidential and are intended solely 
for use of the individual or entity to whom they are addressed. If you have 
received this e-mail in error, please notify the sender immediately and then 
delete it. If you are not the intended recipient, you must not keep, use, 
disclose, copy or distribute this e-mail without the author's prior permission. 
The views expressed in this e-mail message do not necessarily represent the 
views of Highmark Inc., its subsidiaries, or affiliates.

Re: Windows 2008 System State Backup: Incremental

[David E Ehresman]

TSM client 6.2.2.0 works well for system state incremental backup.

>>> "Moyer, Joni M"  2/3/2011 1:31 PM >>>
Hi Everyone,

Does anyone know what version of the TSM Windows Client is needed in
order to only do an incremental system state backup?  And does anything
special need to be done once I have the client upgraded to the needed
release?  This is needed more for my Windows 2008 servers which have
large system state backups.

Thanks in advance!




This e-mail and any attachments to it are confidential and are intended
solely for use of the individual or entity to whom they are addressed.
If you have received this e-mail in error, please notify the sender
immediately and then delete it. If you are not the intended recipient,
you must not keep, use, disclose, copy or distribute this e-mail without
the author's prior permission. The views expressed in this e-mail
message do not necessarily represent the views of Highmark Inc., its
subsidiaries, or affiliates.

Re: Windows 2008 System State Backup: Incremental

[Moyer, Joni M]

Hi David,

Do you have to customize the client or tell it to only do an incremental backup 
of the system state with the 6.2.2.0 client?  Or does it just do it 
automatically?

Thanks again!

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David 
E Ehresman
Sent: Thursday, February 03, 2011 2:05 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Windows 2008 System State Backup: Incremental

TSM client 6.2.2.0 works well for system state incremental backup.

>>> "Moyer, Joni M"  2/3/2011 1:31 PM >>>
Hi Everyone,

Does anyone know what version of the TSM Windows Client is needed in
order to only do an incremental system state backup?  And does anything
special need to be done once I have the client upgraded to the needed
release?  This is needed more for my Windows 2008 servers which have
large system state backups.

Thanks in advance!




This e-mail and any attachments to it are confidential and are intended
solely for use of the individual or entity to whom they are addressed.
If you have received this e-mail in error, please notify the sender
immediately and then delete it. If you are not the intended recipient,
you must not keep, use, disclose, copy or distribute this e-mail without
the author's prior permission. The views expressed in this e-mail
message do not necessarily represent the views of Highmark Inc., its
subsidiaries, or affiliates.

Re: Windows 2008 System State Backup: Incremental

[David E Ehresman]

No more and or less customization than a v5 client.  If you backup
system state, it automatically does an incremental.

David

>>> "Moyer, Joni M"  2/3/2011 2:10 PM >>>
Hi David,

Do you have to customize the client or tell it to only do an
incremental backup of the system state with the 6.2.2.0 client?  Or does
it just do it automatically?

Thanks again!

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf
Of David E Ehresman
Sent: Thursday, February 03, 2011 2:05 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Windows 2008 System State Backup: Incremental

TSM client 6.2.2.0 works well for system state incremental backup.

>>> "Moyer, Joni M"  2/3/2011 1:31 PM >>>
Hi Everyone,

Does anyone know what version of the TSM Windows Client is needed in
order to only do an incremental system state backup?  And does
anything
special need to be done once I have the client upgraded to the needed
release?  This is needed more for my Windows 2008 servers which have
large system state backups.

Thanks in advance!




This e-mail and any attachments to it are confidential and are
intended
solely for use of the individual or entity to whom they are addressed.
If you have received this e-mail in error, please notify the sender
immediately and then delete it. If you are not the intended recipient,
you must not keep, use, disclose, copy or distribute this e-mail
without
the author's prior permission. The views expressed in this e-mail
message do not necessarily represent the views of Highmark Inc., its
subsidiaries, or affiliates.