Re: Overflow location

Sandi If your collocated pool is completely full, then toward the end of that process you effectively didn't have collocation anyway as all your clients were being put onto the last available space. You must add more volumes to the pool one way or another. If you have no space in the library

Re: tsm db extension

> Do I need to be aware of anything ? > > I already have the allocated logical volumes for tsm db setup. > > /dev/vx/rdsk/datadb/tsmdbvol02, but it is not defined as tsm volume > > Steps I was going to follow: > > 1. Backup devconfig > 2. Backup volhist > > 3. Backup db --> ba db devc=3584mclass ty

Re: Wildcard question for backupset generation

You can specify ',' separated list of filespaces ( filesystems). Best Regards, Aftab S. Choudhry Sr. Systems Administrator Schenker Inc. 150 Albany Ave. Freeport, NY 11520 ph 516 403 5406 fax 516 377 3099 email [EMAIL PROTECTED] This message is intended only for the use of the ind

Severed Connection to Client When Scheduling

Hello All *** I have noticed in the activity log of one of the TSM servers that the schedule prompter is contacting the client, then the prompter's connection is severed, and then the backup is started at the client. This sequence is happening only on one TSM server and appears to invol

Re: Need to save permanent copy of all files currently being stored

Hi Richard, yes you can suspend deletion. A bullet on the page says so. But you can't add this feature on to an existing server, so it won't help the original poster. See the redbook at http://www-1.ibm.com/support/docview.wss?uid=rdb2sg24709800 for an architectural overview. It only takes dat

Re: Overflow location

Dear Steave, Thanks but that does not talk about my scenario. My scenario is that : 1- I have stg pool that has scratch volumes=9 2- Eventhough there are other scratch volumes avaiulble in the library but the system won't use those because of limit in point 1. 3- My backups would fail because it

Re: Need to save permanent copy of all files currently being stored

On Dec 1, 2004, at 12:18 PM, William F. Colwell wrote: ITSM has announced a special version of tsm to meet regulatory needs. I forget the exact details, I think there is an extra charge. A query license output includes these 2 lines - Is Tivoli Storage Manager for Data Retention in use ?: No Is T

Re: MS-SQL TDP return code - error

Thanks anyway. Will place a service call ! Del Hoobler <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 12/01/2004 01:26 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To [EMAIL PROTECTED] cc Subject Re: MS-SQL TDP return code - error Zolta

Wildcard question for backupset generation

Hello All! I have a quick question concerning the generate backupset command. I am trying to take a backupset that has the following filesystems included: <== fjsu103: ==> /p01 /p01/app/ibm/was/5.0 /p01/app/iw/tsite/iw-store /p02 /p02/app/ibm/was/5.0/backups Do I have to enter: generate backup

Re: SQL Help

Wanda, Actually it "works", but doesn't "work" when I plug it into the statement shown in the post to which I responded, I get results (not an error), but they are definitely goofy. I'll report back if I find anything more substantive on this subject, but I suspect that it may not be possible to

Re: MS-SQL TDP return code - error

Zoltan, Please call IBM support. I can't diagnose problem with this level of detail on the forum. The SQL Server log, VDI error log, Event Log, and Data Protection for SQL traces will help pinpoint the problem. IBM Service can look at the above documentation and help resolve the problem you are se

Re: MS-SQL TDP return code - error

Need more help with this. Still cant get past the error. Here is some information from the logs and the person setting things up: "The server is a Windows Server 2003. IIS 6 is installed. In addition, it is a Sharepoint Services Server. It also serves as a back end to Microsoft Project Server..

Re: IMAGE backups on AIX

Nope. The filesystem we were testing with is not in use by anything and can be dismounted. We even tried with -imagetype=dynamic. Same error message ! Aftab Choudhry <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 12/01/2004 12:13 PM Please respond to "ADSM: Dist S

Re: W2K and TSM server 5.2.3.1

If you need relief before you get to Win2003, what some people do is: 1) exclude the systemobject from TSM backups 2) set up a Windows scheduled task that backs up the systemobject to a flat file: The command is: C:\WINNT\system32\NTBACKUP.EXE backup systemstate /f c:\pathname\filename.bkf

Re: SQL Help

Andy, I don't think this is possible. DISTINCT doesn't help TSM always responds "unknown SQL column" when a results column is included in the group by It won't take a function in the GROUP BY And It won't let me do a SELECT inside the FROM -Original Message- From: ADSM: Dist Stor Ma

Re: W2K and TSM server 5.2.3.1

I think that is correct... But I have a TSM server that is 5.2.3.1 and the administrator is complaining about DB growth. At this point I am asusming W2K System Object backups. I don't think updating the client version will impact how the TSM server will handle System Objects.. -Origina

Re: Need to save permanent copy of all files currently being stored

ITSM has announced a special version of tsm to meet regulatory needs. I forget the exact details, I think there is an extra charge. A query license output includes these 2 lines - Is Tivoli Storage Manager for Data Retention in use ?: No Is Tivoli Storage Manager for Data Retention licensed ?:

Re: IMAGE backups on AIX

Zoltan, Hope, its not failing due to problem with unmounting the filesystem, during image backup, each filesystem gets remounted read-only, unless you specify, not to unmount (dynamic mode). Best Regards, Aftab S. Choudhry Sr. Systems Administrator . -Original Message- From: ADSM: Dist St

Re: W2K System Objects and TSM server 5.2.3.1

I thought I heard that in the TSM 5.3 versions would be the true incremental of some of the System Object componentsbut you need to find out what's growing your DB. Couple thingsFirst search back as far as you need (or can) in the server activity log for ANE4954I messages. This is the numb

Re: Need to save permanent copy of all files currently being stored

On Dec 1, 2004, at 11:13 AM, Prather, Wanda wrote: Mark's right, there is no GOOD way to do this. You can't create an "archive" with data that is already on TSM tapes, except as a backupset, which can be a pain to track and can't be browsed. ... I'll also add that the lack of a simple way to preser

Re: IMAGE backups on AIX

Thanks for the help. Unfortunately, we can not get it to work: ANS1168E ERROR: could not create image object. The client is V5.1.5.1 on AIX 4.3 (we can not upgrade to V5.1.6 or higher due to it requiring a bos.rte upgrade/reboot. These are our mail systems and unless they crash, getting a reboot

Re: W2K System Objects and TSM server 5.2.3.1

I think that is correct... But I have a TSM server that is 5.2.3.1 and the administrator is complaining about DB growth. At this point I am asusming W2K System Object backups. I don't think updating the client version will impact how the TSM server will handle System Objects.. -Original

Re: W2K System Objects and TSM server 5.2.3.1

I thought the relief in System Object backups (that TSM will not back up the files that haven't changed) was supposed to come with Win2K3 and XP, not Win2K? (But then, I'm easily confused...) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Adams, M

Re: W2K System Objects and TSM server 5.2.3.1

From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Adams, Matt (US - Hermitage) >Just wondering if anyone in the group is seeing any relief or >is the impact about the same in relation to the TSM DB and W2K >System Objects. > >Running TSM server version 5.2.3.1 on AIX 5.2 Clien

Re: Need to save permanent copy of all files currently being stored

Mark's right, there is no GOOD way to do this. You can't create an "archive" with data that is already on TSM tapes, except as a backupset, which can be a pain to track and can't be browsed. I've done this by using EXPORT along with some management class games (Mark, if you can find a hole in this

W2K System Objects and TSM server 5.2.3.1

Just wondering if anyone in the group is seeing any relief or is the impact about the same in relation to the TSM DB and W2K System Objects. Running TSM server version 5.2.3.1 on AIX 5.2 Client version 5.2.0.3. Regards, Matt Adams Information Technology Services Deloitte Services LP 615-882-6861

Re: Need to save permanent copy of all files currently being stored

From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Kinder >I have been ordered to create a permanent copy of one >directory (including all files and subdirectories that I >currently have stored on TSM for a particular client. These >files currently have a 30 day retentio

Re: Admin command line problem - solved

Andy, that was it. I had badly setup my locale environment variable (LANG). Thanx and best regards Ing. Jozef Zatko Login a.s. Dlha 2, Stupava tel.: (421) (2) 60252618 Andrew Raibeck <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 12/01/2004 02:20 PM Please respond

Need to save permanent copy of all files currently being stored

*SMers, I have been ordered to create a permanent copy of one directory (including all files and subdirectories that I currently have stored on TSM for a particular client. These files currently have a 30 day retention, and many of them change daily, so I have 30 copies of a number of these fil

Re: SQL Help

Try adding the DISTINCT keyword between SELECT and DATE(PENDING_DATE), i.e. select distinct date(pending_date) ... You'll want to verify that the results are correct by matching up the counts against the results of the select without DISTINCT. For example, using the output you show below, I'd

tsm db extension

Do I need to be aware of anything ? I already have the allocated logical volumes for tsm db setup. /dev/vx/rdsk/datadb/tsmdbvol02, but it is not defined as tsm volume Steps I was going to follow: 1. Backup devconfig 2. Backup volhist 3. Backup db --> ba db devc=3584mclass type=full 4. Define

Re: SQL Help

That does not give me the desired results: tsm: ULTSM> select date(pending_date) as "Date",count(*) from volumes where - cont> status='PENDING' group by pending_date Date Unnamed[2] -- --- 2004-11-27 1 2004-11-27 1 2004-11-27

Re: SQL Help

I guess if I'd read the entire e-mail, instead of assuming I knew what the problem was from the error, I'd have seen he was using caps for the where clause. Oh well, no coffee yet today. Good eye Gretchen. [EMAIL PROTECTED] "Gretchen L. Thiele" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Mana

Re: TDP for MSSQL Archiving for Long Tme question!

Mladen, One way to do this is to create a separate NODENAME with different policy settings and use that NODENAME to perform a full back up of your SQL Server databases once per month. Thanks, Del "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

Re: tsm server and nas client

Any idea if there is any restriction with mounting nas filesystem directly on our tsm server? I think if it's a soft/hard mount, might cause problems on tsm server? Please Advise Thanks -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van -

Re: SQL Help

The group by statement is incorrect, use the following: group by pending_date the conversion to date format is already taken care of in the first part of the select statement. David E Ehresman wrote: tsm: ULTSM> select date(pending_date) as "Date",count(*) from volumes where - cont> status='PENDING

Re: tsm server and nas client

Thanks for your reply, Yes it was permissioning errors -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: Wednesday, December 01, 2004 4:39 AM To: [EMAIL PROTECTED] Subject: Re: tsm server and nas client Hi Perpetua! In mos

Re: SQL Help

Try using capital letters. [EMAIL PROTECTED] David E Ehresman <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 12/01/2004 08:54 AM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To [EMAIL PROTECTED] cc Subject Re: SQL Help tsm: ULTSM> select d

Re: LAN-free Data transfer

We wait to hear from our dba that backups are running too long. Lan-free vs lan backups make a very noticable difference in their backup times. >>> [EMAIL PROTECTED] 11/30/2004 8:53:52 AM >>> Hello All! TSM 5.2.2.5 server AIX 5.2 Sun Solaris Lan-Free client 5.2.2.5 Once the lan-free data transfe

Re: SQL Help

tsm: ULTSM> select date(pending_date) as "Date",count(*) from volumes where - cont> status='PENDING' group by "Date" ANR2940E The reference 'Date' is an unknown SQL column name. | ...

Re: Admin command line problem

The admin CLI -DATAONLY option is platform neutral. Thus it doesn't matter on which OS you run the admin; it should work. Check your enUS/dsmclientV3.cat file and make sure it's modification time matches that of the dsmadmc module. If you continue to have trouble with this option, contact IBM tec

FIXEDIOBUFSIZE on Z/OS

Hi List I found the FIXEDIOBUFSIZE Parameter in the Tuning Guide. should i set the value to 16 like recomended togheter with resourceutil 10. The most tsm clients have resourceutil 2 in our environment, only 3 big nodes have 10. Does the Z/OS not manage the VSAM Buffers dynamic or do i not exactl

Re: Admin command line problem

IBM Tivoli Storage Manager Command Line Administrative Interface - Version 5, Release 2, Level 2.0 (c) Copyright by IBM Corporation and other(s) 1990, 2003. All Rights Reserved. working OK on AIX 5.2 with the 5.2.2.0 admin client Dwight E. Cook Systems Management Integration Professional, Ad

Re: Admin command line problem

But there are (at least I am no aware of any) no admin client instalation files. I have just baclient and api client. And when I start admin client I see following message: [EMAIL PROTECTED]:/usr# dsmadmc Tivoli Storage Manager Command Line Administrative Interface - Version 5, Release 2, Level 3.

Re: Admin command line problem

Sounds like your baclient is up to date on AIX, but not the admin client (they are different). -Original Message- From: Jozef Zatko [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 01, 2004 4:30 AM To: [EMAIL PROTECTED] Subject: Admin command line problem Hi fellows, I have strange p

Re: IMAGE backups on AIX

Hi Zoltan! The Image client was introduced in 3.7, so 3.7.0.0 is the minimum level. Whether you should use that level... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Zoltan Forray/AC/VCU [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 17:51 T

Re: tsm server and nas client

Hi Perpetua! In most cases the error "PrivIncrFileSpace: Received rc=106 from fioGetDirEntries" is caused by incorrect permissions. You mention the client to be a HP11, does that mean HP-UX version 11? If so, isn't TSM running under the root account? Kindest regards, Eric van Loon KLM Royal Dutch A

Admin command line problem

Hi fellows, I have strange problem with administrative command line - dsmadmc. According to manual, from version 5.2 there is a new option -dataonly=yes. This option is working on my Windows client (version 5.2.0.6), but not on my AIX client. On my AIX 5.1 system, I have TSM server 5.2.2.5 and TSM

TDP for MSSQL Archiving for Long Tme question!

Dear TSM's! I'm doing every day full backup and I'm dong log backup every two hours. I keep 7 versions of a backup! How can I store (select) each month one TDP Backup for Long time retention? Backup set doesn't work because it is only for B/A clients. I have tried with "tdpsqlc backup * set /files

sysback and tsm 64-bit api

Hello, we want to install sysback on systems where already installed tdp for oracle and tsm 64-bit api. Sysback needs the tsm 32-bit tsm api. Should I deinstall the 64-bit tsm api and install the 32-bit tsm api (performance of tdp for oracle ?), or can I install both (32-bit and 64-bit tsm api).