SQL query of ADSM backups table

[Paul Ewing]

Hi,

I am querying the adsm server backups table  for a file space with a
management class that specifies
verexists = 7,verdeleted 1,rexextra 8,retonly 90.

I am expecting to see 8 versions of the data outputted from the sql query,
however only seem to get the latest version.
Can anyone tell me what I am doing wrong?.

select * from backups where node_name = 'UNIXDATA' and filespace_name =
'xxx' and
hl_name = 'yyy' and ll_name = ''

Our server is on OS/390  ADSM Version 3, Release 1, Level 2.55

Cheers
Geoff.

EXPORT SERVER not dumping backup index data

[MacDonald, David DA]

I'm doing an export of a 5Gig database, with the following command:

export server devclass=expfile vol=data1.exp,data2.exp,data3.exp,data4.exp 
filedata=none

My understanding is that this command will dump the entire contents of the database 
(i.e. admin, node, policy info, as well as backup index information). In reality it 
dumps about 16k of data, which from the activity log seems to be only the admin, node, 
and policy info, but no backup file information.

If I use the "filedata=all" option, it appears to start dumping actual backup files 
(dumped 13 Gig before filling up the filesystem).

Is this the right way to dump index information (we're migrating to another server, 
and taking the existing tape storage pools with us). Is the command working how it is 
supposed to?


Please CC replies to me directly. Thanks for any help you can provide.


David Macdonald
Unix Services (Wollongong)
CSC TS
+61 2 4275 7163

EOM

NOTICE - This message contains information intended only for the use of the addressee 
named above.  It may also be confidential and/or privileged.  If you are not the 
intended recipient of this message you are hereby notified that you must not 
disseminate, copy or take any action in reliance on it.  If you have received this 
message in error please notify [EMAIL PROTECTED]

Re: Cut MVS CPU Utilization

[Bill Colwell]

Darlene,

you were the victim of a bug;  I am attaching the apar below.
This bug bit me once too.  I didn't recognize it from your previous
post, but this post rang a bell with me.  It is fixed at the 3.7.2 level.
I don't know what level of 3.1.2.* has the fix.

Bill
- - -
Item PQ33718

  APAR Identifier .. PQ33718   Last Changed..00/01/27
  SERVER HANG DURING BACKUP STORAGEPOOL IF WAIT=YES OPTION IS USED


  Symptom .. IN INCORROUT Status ... CLOSED  PER
  Severity ... 2  Date Closed . 99/12/09
  Component .. 5697TSMVS  Duplicate of 
  Reported Release . 370  Fixed Release  999
  Component Name TIVOLI STR MGR   Special Notice
  Current Target Date ..00/03/27  Flags
  SCP ...
  Platform 

  Status Detail: ASSIGNMENT - APAR has been assigned to a
  programmer.

  PE PTF List:

  PTF List:
  Release 370   : PTF not available yet


  Parent APAR:IY03390
  Child APAR list:


  ERROR DESCRIPTION:
  SERVER HANG DURING BACKUP STORAGEPOOL IF WAIT=YES OPTION IS USED
  If a backup stg process is started in foreground the according
  SmAdminCommandThread uses the function bfWaitRemainingCopyProcs
  for synchronization with the backup threads. If this function
  is called with an invalid handle it can loop (or even abend)
  thru the global list of copy-control-blocks.Since it is holding
  a mutex on BFV when processing this list it can block other
  threads.


  LOCAL FIX:
  Use wait=no option on backup stg commands.


  PROBLEM SUMMARY:
  
  * USERS AFFECTED:  *
  ADSM V310 and ADSM V312 server users.  Also Tivoli Storage
  Manager V370 server users.
  
  * PROBLEM DESCRIPTION: *
  The processing for BACKUP STORAGEPOOL with the WAIT=YES
  parameter may hang and/or abend the server.
  
  * RECOMMENDATION:  *
  Apply the ptf that resolves this fix once it is available.
  
  The BACKUP STORAGEPOOL processing with the WAIT=YES parameter
  has been altered.  Specifically, the algorithm used to manage
  waiting for completion when the WAIT=YES parameter is
  specified has been altered to prevent a possible hang
  condition or server abend.  The nature of the problem
  depends on timing between multiple threads on the server
  and memory that is shared between those threads.


  PROBLEM CONCLUSION:
  The BACKUP STORAGEPOOL processing with the WAIT=YES parameter
  was not sharing memory properly between threads.  Because
  of this memory sharing error the process could cause the
  server to hang or else abend depending upon the state
  and usage of the memory.
- - -
In <[EMAIL PROTECTED]>, on 09/18/00
   at 04:57 PM, Darlene E Wnukowski <[EMAIL PROTECTED]> said:

>Good news! I have been running for a week with rewritten ADSM backup scripts
>and my CPU utilization has not gone above 10% of our 7060-H50. Most of the
>time it's under 5%. I rewrote my daily ADSM backup scripts to remove the
>parameter "wait=yes". I had to break the scripts up to do one command in each
>and check for the completion of the previous task before issuing another
>command or running another script, but it worked!! I am willing to send copies
>of the scripts I am running to you if requested. Neither I nor my company are
>warranting them but you are free to adapt them to your needs.



>Darlene E. Wnukowski
>Lead Systems Programmer
>Schreiber Foods, Inc.
>[EMAIL PROTECTED]
>920-455-6268





>**

>This email and any files transmitted with it are confidential
>and intended solely for the use of the individual or entity
>to whom they are addressed. If you have received this email
>in error please notify [EMAIL PROTECTED]

>This footnote also confirms that this email message has been
>swept by MIMEsweeper for the presence of computer viruses.

>**

--
--
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
[EMAIL PROTECTED]
--

Problem deleting database backup volhistory records

[Trevor Foley]

G'day,

I've got a small problem with deleting database backup records from the volhistory 
file. I have records in there going back about 5 weeks but we normally only keep a few 
days worth. If I do 'delete volh type=dbb todate=today-5' no records are removed even 
though 8 records more than that age exist as shown by 'q volh type=dbb'.

The cause I think is the backup series number. The numbers for the 8 records that I 
cannot remove are 1377 through 1380 (there are a mix of full and incremental backups). 
Whereas the more recent backup series are 1248 through 1250. How I managed to get some 
older backup series with higher numbers I have no idea.

Any ideas as to how I can fix this? One option is to wait the 130 or so days until the 
current backup series number reach the older numbers. But my concern is that if I wait 
until then I might find myself in a position where I am unable to perform a database 
backup due to conflicting backup series numbers.


thanks,

Trevor

--
This message and any attachment is confidential and may be privileged or otherwise 
protected from disclosure.  If you have received it by mistake please let us know by 
reply and then delete it from your system; you should not copy the message or disclose 
its contents to anyone.

Re: Oracle 64bit backups

[Neil Rasmussen]

Currently, there is no solution for TDP for Oracle on HPUX-11 64-bit.

Regards,


Neil G. Rasmussen
TDP Oracle
Phone:  408-256-8265, t/l 276-8265
E-mail:  [EMAIL PROTECTED]


Good Friend <[EMAIL PROTECTED]> on 09/18/2000 12:32:55 PM

Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

To:   [EMAIL PROTECTED]
cc:(bcc: Neil Rasmussen/Tivoli Systems)
Subject:  Re: Oracle 64bit backups




So there is noway currently to used TDPO on  8.1.6 64 bit Oracle DB's?

Thanks,
allwyn x37218

- Original Message -
From: "Neil Rasmussen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 18, 2000 3:17 PM
Subject: Re: Oracle 64bit backups


> Allwyn,
>
> TDPO does not currently support HP 64 bit, it is in plan for future
release.
> However, a date has not been set yet for this release.
>
>
> Regards,
>
>
> Neil G. Rasmussen
> TDP Oracle
> Phone:  408-256-8265, t/l 276-8265
> E-mail:  [EMAIL PROTECTED]
>
>
> Good Friend <[EMAIL PROTECTED]> on 09/18/2000 06:43:49 AM
>
> Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>
> To:   [EMAIL PROTECTED]
> cc:(bcc: Neil Rasmussen/Tivoli Systems)
> Subject:  Oracle 64bit backups
>
>
>
>
> Hello,
>
> Is anyone using TSM for Oracle 8.1.6 running on hp clients?
> I've checked the Tivoli site but could not find any info on this.
>
> thanks,
> allwyn
>

Re: TSM 3.7 Database unload/reload

[Trevor Foley]

Hi Jeff,

We ran on unload-load on a 46GB database a few months back. The database was >90% 
utilised before the unload-load and 52% afterwards. Besides the obvious benefit of 
significantly reducing the database size, we have also seen better performance, 
particularly with database backups.

That's the good news. The bad news is that all up our server was off the air for 
around 24 hours. And that was with playing a few tricks. We normally run the database 
with *SM mirroring enabled. We split the mirrors and used one set for the unload and 
one set for the load. This also gave us an easy backout path without having to restore 
the database. We then forced our 3590 tape drives to write in uncompressed mode with 
resulted in multiple tapes being need to write the unload data. The advantage here is 
that as soon as one tape was full, the unload would start writing to the 2nd tape and 
we could use the first tape to start the load. So even though the unload took just 
under 16 hours we were able to start the load after only 6 hours. The load took 17.5 
hours. Note that the unload-load utilities do not support automatic tape libraries so 
we also had to run the 3590s, which are in a 3494 library, in manual mode.

The unload-load ran on a 4-way RS/6000 R50 with 512MB memory, SSA disks, AIX 4.3.2 and 
TSM 3.7.3.6.


regards,

Trevor

-Original Message-
From: Jeff Connor [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 19 September 2000 2:04 AM
To: [EMAIL PROTECTED]
Subject: TSM 3.7 Database unload/reload


 Our TSM V3.7 server running on OS/390 has a 32GB database
that's 85% utilized.  We have been adding volumes over the last 5
or so years starting with ADSM version 1 and have never done an
unload/reload/re-org.  I've been thinking of trying to unload and
reload this servers database and was wondering what other TSM 3.7
or 4.1 users have experienced after attempting an unload/reload.
I remember hearing stories in the past on the listserv about this
process running for days, database growing in size on the reload,
etc.  I'm wondering if the long outage is worth it and what gains
you might have realized in terms of better performance, database
size reduction, etc. after unloading/reloading your database.
Any idea how many hours it might take to perform this process on
a 32GB database?


Thanks
Jeff Connor
Niagara Mohawk Power Corp

--
This message and any attachment is confidential and may be privileged or otherwise 
protected from disclosure.  If you have received it by mistake please let us know by 
reply and then delete it from your system; you should not copy the message or disclose 
its contents to anyone.

Re: backup copy pools

[Jim Sporer]

What is your mountlimit set to for the device class 3590tape?
Jim Sporer


At 09:12 AM 9/18/2000 -0500, you wrote:
>I am trying to backup my disk pool to a tape pool.  I need to run multiple
>session to get a decent backup time but I can't seem to get it to run
>multiple sessions.  Any advice?
>
>AIX - 4.3.3
>ADSM Server - 3.1.2.40
>
>adsm> q sch dr_pr1 t=a f=d
>
>  Schedule Name: DR_PR1
>Description:
>Command: ba stg db_dpool dr_pr1db1 maxpr=3
>   Priority: 7
>Start Date/Time: 09/11/00   23:00:00
>   Duration: 1 Hour(s)
> Period: 1 Day(s)
>Day of Week: Any
> Expiration:
>Active?: Yes
>Last Update by (administrator): ADMIN
>  Last Update Date/Time: 09/14/00   17:21:43
>   Managing profile:
>
>
>adsm> q stg db_dpool f=d
>
>Storage Pool Name: DB_DPOOL
>Storage Pool Type: Primary
>Device Class Name: DISK
>  Estimated Capacity (MB): 373,632.0
> Pct Util: 25.1
> Pct Migr: 25.1
>  Pct Logical: 100.0
> High Mig Pct: 1
>  Low Mig Pct: 1
>  Migration Delay: 0
>   Migration Continue: Yes
>  Migration Processes: 6
>Next Storage Pool: DB_TPOOL
> Reclaim Storage Pool:
>   Maximum Size Threshold: No Limit
>   Access: Read/Write
>  Description:
>Overflow Location:
>Cache Migrated Files?: No
>   Collocate?:
>Reclamation Threshold:
>  Maximum Scratch Volumes Allowed:
>Delay Period for Volume Reuse:
>   Migration in Progress?: Yes
> Amount Migrated (MB): 337,662.00
>Elapsed Migration Time (seconds): 155,146
> Reclamation in Progress?:
>  Volume Being Migrated/Reclaimed:
>   Last Update by (administrator): ADMIN
>Last Update Date/Time: 09/18/00   03:00:02
>
>
>
>adsm> q stg dr_pr1db1 f=d
>
>Storage Pool Name: DR_PR1DB1
>Storage Pool Type: Copy
>Device Class Name: 3590TAPE
>  Estimated Capacity (MB): 200,478,940.6
> Pct Util: 0.4
> Pct Migr:
>  Pct Logical: 99.7
> High Mig Pct:
>  Low Mig Pct:
>  Migration Delay:
>   Migration Continue:
>  Migration Processes:
>Next Storage Pool:
> Reclaim Storage Pool:
>   Maximum Size Threshold:
>   Access: Read/Write
>  Description:
>Overflow Location:
>Cache Migrated Files?:
>   Collocate?: No
>Reclamation Threshold: 100
>  Maximum Scratch Volumes Allowed: 9,999
>Delay Period for Volume Reuse: 0 Day(s)
>   Migration in Progress?:
> Amount Migrated (MB):
>Elapsed Migration Time (seconds):
> Reclamation in Progress?: No
>  Volume Being Migrated/Reclaimed:
>   Last Update by (administrator): ADMIN
>Last Update Date/Time: 09/10/00   18:56:26
>
>
>
>Thanks in advance
>Becky Davidson
>Data Manager/AIX Administrator
>EDS/Earthgrains
>voice: 314-259-7589
>fax: 314-877-8589
>email: [EMAIL PROTECTED]

Re: ON-bar, informix & ADSM 3.1 for Linux

[Bhaskarla, Sunil]

IMHO, I am afraid linux isn't commercially good enough right now...


|-Original Message-
|From: Erika Marshall [mailto:[EMAIL PROTECTED]]
|Sent: Monday, September 18, 2000 3:53 PM
|To: [EMAIL PROTECTED]
|Subject: ON-bar, informix & ADSM 3.1 for Linux
|
|
|Running ADSM v. 3.1 on AIX, using Informix on Linux -
|brand new to this site and they tell me there is no ON-BAR
|api for this configuration ? Anyone know anything about that ?
|
|Thanks
|

Errors trying to connect Oracle/RMAN with TDP

[Christopher A Campbell]

Please help. Our project is light on RMAN skills. Please can someone advise
us.

Our environment is

Solaris 2.6
TDP 2.1.10
Oracle 8.1.6

We get this error when attempting to do a RMAN backup:

RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03007: retryable error occurred during execution of command: allocate
RMAN-07004: unhandled exception during command execution on channel ch1
RMAN-10035: exception raised in RPC: ORA-19554: error allocating device,
device
type: SBT_TAPE, device name:
ORA-19557: device error, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
Additional information: 4110
ORA-19511: SBT error = 4110, errno = 0, BACKUP_DIR environment variable is
not set
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.DEVICEALLOCATE
Recovery Manager complete.


And here's the script we are trying to run:

run {
2> allocate channel ch1 type 'sbt_tape' parms
3>   'ENV=(DSMI_ORC_CONFIG=/usr/bin/dsm.opt,
4>DSMO_AVG_SIZE=50)';
5> backup database;
6> sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
7> }

We believe we have executed the 'link' operation from RMAN to TDP - maybe
not??
What should we check?
What can we test?
Any help greatly appreciated.

Chris Campbell
Tivoli Services TeamITS, IBM Global Services
IBM Ireland, 24/32 Pembroke Road, Dublin 4, Ireland
Phone  :  +353-1-815-4146Internal 50-4146 Fax +353-1-815-4304
Internet :  [EMAIL PROTECTED]

ON-bar, informix & ADSM 3.1 for Linux

[Erika Marshall]

Running ADSM v. 3.1 on AIX, using Informix on Linux -
brand new to this site and they tell me there is no ON-BAR
api for this configuration ? Anyone know anything about that ?

Thanks

begin:vcard
n:Marshall;Erika
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
fn:Erika Marshall
end:vcard

Re: certification

[Shekhar Dhotre]

thanks , several times i have visited to this page , but couldnot locate ,
happens  :)





"[EMAIL PROTECTED]/P=Internet/A= /C=us" on 09/18/2000 03:06:49 PM
Please respond to "[EMAIL PROTECTED]/P=Internet/A= /C=us" @ X400
To: "[EMAIL PROTECTED]/P=Internet/A= /C=us"@X400
cc:

Subject: Re: certification

Shekhar,

Select Information Technology Certifications from the menu.  When the
registration page appears is a line that says:

If you have never registered online before, click here  to get
your online login.
Click on 'here' and follow the prompts

Sean McNamara
Senior Analyst
PJM Interconnection L.L.C.
(610)666-4206







> -Original Message-
> From: Shekhar Dhotre [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, September 18, 2000 14:56
> To:   [EMAIL PROTECTED]
> Subject:  certification
>
> Hi all,
> I want to appear  for test 599, Tivoli Storage Cert.  trying to call
> 1-800-959-exam./ 1-866-prometric  the answer comes
> checked www.2test.com  , for booking test , but on that web page it asks ,
> user
> id and login name .
> from where do i get this  , if you point register offline it again points to
> www.2test.com .
> how to register for this test?
> i am in Massachusets.. Somebody from Tivoli pls.  help.
>
> shekhar
>
>
>
>
>
>
> "[EMAIL PROTECTED]/P=Internet/A= /C=us" on 09/18/2000 02:47:36
> PM
> Please respond to "[EMAIL PROTECTED]/P=Internet/A= /C=us" @
> X400
> To: "[EMAIL PROTECTED]/P=Internet/A= /C=us"@X400
> cc:
>
> Subject: Re: Deleting a archive file
>
> In the Windows and OS/2 Backup/Archive Clients,
> you can select Delete Archive Data from the Utilities menu.
> You can then navigate and delete specific files.
> I don't know about other platforms.
>
> On Monday, September 18, 2000 11:16 AM, Bart Colbert
> [SMTP:[EMAIL PROTECTED]] wrote:
> > Hello,
> >
> >  Does anyone know how you can delete a specific archive files by say
> > "object_id"?
> >
> >  Say you have two archives with the description of
> >  "ARCHIVE1" and "ARCHIVE2"
> >
> >  You can run a select
> >
> >  select object_id from archives where description='ARCHIVE1'
> >
> >  But the delete archive is filespec specific, and I have not found a simple
> > solution.
> >
> > Thanks for any help,
> > Bart

Re: Oracle 64bit backups

[Good Friend]

So there is noway currently to used TDPO on  8.1.6 64 bit Oracle DB's?

Thanks,
allwyn x37218

- Original Message -
From: "Neil Rasmussen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 18, 2000 3:17 PM
Subject: Re: Oracle 64bit backups


> Allwyn,
>
> TDPO does not currently support HP 64 bit, it is in plan for future
release.
> However, a date has not been set yet for this release.
>
>
> Regards,
>
>
> Neil G. Rasmussen
> TDP Oracle
> Phone:  408-256-8265, t/l 276-8265
> E-mail:  [EMAIL PROTECTED]
>
>
> Good Friend <[EMAIL PROTECTED]> on 09/18/2000 06:43:49 AM
>
> Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>
> To:   [EMAIL PROTECTED]
> cc:(bcc: Neil Rasmussen/Tivoli Systems)
> Subject:  Oracle 64bit backups
>
>
>
>
> Hello,
>
> Is anyone using TSM for Oracle 8.1.6 running on hp clients?
> I've checked the Tivoli site but could not find any info on this.
>
> thanks,
> allwyn
>

Deleting archive files revised

[Bart Colbert]

Let me revise the problem a little.


dsmc archive -archmc=ARCH_MC "/path/*" -subdir=yes -description="ARCHIVE1"
dsmc archive -archmc=ARCH_MC "/path/*" -subdir=yes -description="ARCHIVE2"

Now two files exist call /path/myfile one with the description of ARCHIVE1
and the other with ARCHIVE2

if I were to delete archive /path/myfile both are gone

Both have seperate object_id from the select table.

Is there a method (known, without writing a api program) that will allow
for extracting the object data and then specificly deleting each file.

In the example I would like to leave /path/myfile desc=ARCHIVE1
Thanx,
Bart

search for hal.dll

[Tim Brown]

search adsm-l hal.dll   from 19990101 to TODAY


begin:vcard
n:Brown;Tim
tel;fax:914-486-5921
tel;work:914-486-5643
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Specialist
x-mozilla-cpt:;8176
fn:Tim  Brown
end:vcard

Re: Oracle 64bit backups

[Neil Rasmussen]

Allwyn,

TDPO does not currently support HP 64 bit, it is in plan for future release.
However, a date has not been set yet for this release.


Regards,


Neil G. Rasmussen
TDP Oracle
Phone:  408-256-8265, t/l 276-8265
E-mail:  [EMAIL PROTECTED]


Good Friend <[EMAIL PROTECTED]> on 09/18/2000 06:43:49 AM

Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

To:   [EMAIL PROTECTED]
cc:(bcc: Neil Rasmussen/Tivoli Systems)
Subject:  Oracle 64bit backups




Hello,

Is anyone using TSM for Oracle 8.1.6 running on hp clients?
I've checked the Tivoli site but could not find any info on this.

thanks,
allwyn

Re: using adsm to restore nt 4.0 server

[Thomas Denier]

> i tried this same tactic once on a windows nt 4.0 server platform and it
> did not work.
> since the hardware was totally different windows would not startup after
> i installed nt 4.0 into
> a separate partition and then restored the original windows nt c: drive
> via adsm...

This has been the subject of extensive discussion, although in terms of
disaster recovery rather than hardware upgrades. Essentially, hal.dll and the
hardware portion of the registry have to be copied from the partition with the
newly installed Windows NT to the partition restored from ADSM. Searching the
archives for 'hal.dll' should turn up more detailed instructions.

Re: ADSM and SQL-Backtrack

[Mark A. Adams]

BackTrack had a problem with expiring it's own data.
Here are some scripts that we used to find more info
about the particular files. Hope this will help you.

Mark Adams
(402) 963-8237

/* This will show all files for a particular node */
select * from contents where node_name='SQL_BACKTRACK'

/* This script is designed to pull the files*/
/* for SQL_BACKTRACK node given a certain month */
/* for the year 2000*/
select filespace_name, hl_name, -
ll_name from backups where -
node_name='SQL_BACKTRACK' and -
substr(varchar(backup_date),1,7)='2000-$1'

/* This script is designed to pull the files*/
/* for SQL_BACKTRACK node given a certain month */
/* for the year 1999*/
select node_name, filespace_name, hl_name, -
ll_name, backup_date from backups where -
node_name='SQL_BACKTRACK' and -
substr(varchar(backup_date),1,7)='1999-$1' -
order by backup_date

/* This script obtains all nodes and their  */
/* total amount of occupancy*/
select node_name "NODE", type, sum(num_files) -
 "# FILES", sum(physical_mb) "PHY(MB)", -
 sum(logical_mb) "LOG(MB)" from occupancy -
 group by node_name, type order by type


-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Lu Ann Mezera
Sent: Monday, September 18, 2000 1:03 PM
To: [EMAIL PROTECTED]
Subject: Re: ADSM and SQL-Backtrack


I am looking there when I am in the dsm GUI.  The folder is there but when I
try to expand it, it is empty.  Is there another way to look at it in the
dsm GUI or should I use a different ADSM tool?  Thanks for your help.

Lu Ann Mezera
Data Center Supervisor
Lab Safety Supply
(608) 757-4909 voice
(608) 757-4652 fax
[EMAIL PROTECTED]


-Original Message-
From: Fluker, Tom R [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 18, 2000 12:02 PM
To: [EMAIL PROTECTED]
Subject: Re: ADSM and SQL-Backtrack


look at "/BACKTRACK:oracatalog" your backups are there

Tom Fluker
Viasystems Technologies

> -Original Message-
> From: Lu Ann Mezera [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, September 18, 2000 12:18 PM
> To:   [EMAIL PROTECTED]
> Subject:  ADSM and SQL-Backtrack
>
> We have ADSM 3.2.1  and are in the processing of implementing SQL
> Backtrack
> to backup up our Oracle databases on AIX and SQL Server 7.0 databases on
> NT.
> We know that Backtrack is pushing the backups to ADSM because when our
> Information Architect goes into Backtrack to do a database restore, she is
> successful.  Also, the amount of scratch tapes in our MagStar are rapidly
> depleting.  When we do a QUERY OCCUPANCY * *  command in dsmadmc, we see
> two
> (2) names for our Database AIX node where the Oracle databases are
> installed
> called /BACKTRACK:tmp-control-dir and /BACKTRACK:oracatalog.  I can see
> there are 30,000+ files and 240+ gig worth of data.
>
> This is my question.  When I go into the ADSM gui, I see the high level
> file
> space structure of those 2 /BACKTRACK filespaces but don't see any
> file/directory detail.  Why is this?

Re: ADSM and SQL-Backtrack

[Thomas Denier]

> This is my question.  When I go into the ADSM gui, I see the high level file
> space structure of those 2 /BACKTRACK filespaces but don't see any
> file/directory detail.  Why is this?

SQL-BackTrack is based on the ADSM API client. ADSM is designed so that
backup/archive clients cannot obtain information about individual files backed
up by API clients, API clients cannot obtain information about files backed up
by the backup/archive client, and different types of API clients (for example,
SQL-BackTrack and Tivoli Data Protection) cannot obtain information about each
others files. Client-side query facilities for files sent to ADSM by
SL-BackTrack, if they exist at all, are part of SQL-BackTrack.

Re: certification

[Sean McNamara]

Shekhar,

Select Information Technology Certifications from the menu.  When the
registration page appears is a line that says:

If you have never registered online before, click here  to get
your online login.
Click on 'here' and follow the prompts

Sean McNamara
Senior Analyst
PJM Interconnection L.L.C.
(610)666-4206







> -Original Message-
> From: Shekhar Dhotre [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, September 18, 2000 14:56
> To:   [EMAIL PROTECTED]
> Subject:  certification
>
> Hi all,
> I want to appear  for test 599, Tivoli Storage Cert.  trying to call
> 1-800-959-exam./ 1-866-prometric  the answer comes
> checked www.2test.com  , for booking test , but on that web page it asks ,
> user
> id and login name .
> from where do i get this  , if you point register offline it again points to
> www.2test.com .
> how to register for this test?
> i am in Massachusets.. Somebody from Tivoli pls.  help.
>
> shekhar
>
>
>
>
>
>
> "[EMAIL PROTECTED]/P=Internet/A= /C=us" on 09/18/2000 02:47:36
> PM
> Please respond to "[EMAIL PROTECTED]/P=Internet/A= /C=us" @
> X400
> To: "[EMAIL PROTECTED]/P=Internet/A= /C=us"@X400
> cc:
>
> Subject: Re: Deleting a archive file
>
> In the Windows and OS/2 Backup/Archive Clients,
> you can select Delete Archive Data from the Utilities menu.
> You can then navigate and delete specific files.
> I don't know about other platforms.
>
> On Monday, September 18, 2000 11:16 AM, Bart Colbert
> [SMTP:[EMAIL PROTECTED]] wrote:
> > Hello,
> >
> >  Does anyone know how you can delete a specific archive files by say
> > "object_id"?
> >
> >  Say you have two archives with the description of
> >  "ARCHIVE1" and "ARCHIVE2"
> >
> >  You can run a select
> >
> >  select object_id from archives where description='ARCHIVE1'
> >
> >  But the delete archive is filespec specific, and I have not found a simple
> > solution.
> >
> > Thanks for any help,
> > Bart

Re: ADSM and SQL-Backtrack

[David M. Hendrix]

Lu Ann,

Backtrack uses the ADSM API and therefore using the BA GUI will yield
nothing.  You can compile and use the sample API program included with the
client and use that as a text interface to view objects, or, you can use
the show versions command from the server admin interface.

30,000 objects seems quite a bit.  I'm sure it depends on your retention
and # data files.  Check the # generations that your DBAs have set to make
sure everything is okay.  Also make sure the management class you have them
bound to has:

vere=1 verd=0 rete=0 reto=0

This allows the backtrack software to correctly control versioning.
Otherwise, you'll have objects that take much longer to expire than what
you might have envisioned.

David Hendrix





Lu Ann Mezera <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 09/18/2000
12:03:13 PM

Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

Sent by:  "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>


To:   [EMAIL PROTECTED]
cc:

Subject:  Re: ADSM and SQL-Backtrack


I am looking there when I am in the dsm GUI.  The folder is there but when
I
try to expand it, it is empty.  Is there another way to look at it in the
dsm GUI or should I use a different ADSM tool?  Thanks for your help.

Lu Ann Mezera
Data Center Supervisor
Lab Safety Supply
(608) 757-4909 voice
(608) 757-4652 fax
[EMAIL PROTECTED]


-Original Message-
From: Fluker, Tom R [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 18, 2000 12:02 PM
To: [EMAIL PROTECTED]
Subject: Re: ADSM and SQL-Backtrack


look at "/BACKTRACK:oracatalog" your backups are there

Tom Fluker
Viasystems Technologies

> -Original Message-
> From: Lu Ann Mezera [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, September 18, 2000 12:18 PM
> To:   [EMAIL PROTECTED]
> Subject:  ADSM and SQL-Backtrack
>
> We have ADSM 3.2.1  and are in the processing of implementing SQL
> Backtrack
> to backup up our Oracle databases on AIX and SQL Server 7.0 databases on
> NT.
> We know that Backtrack is pushing the backups to ADSM because when our
> Information Architect goes into Backtrack to do a database restore, she
is
> successful.  Also, the amount of scratch tapes in our MagStar are rapidly
> depleting.  When we do a QUERY OCCUPANCY * *  command in dsmadmc, we see
> two
> (2) names for our Database AIX node where the Oracle databases are
> installed
> called /BACKTRACK:tmp-control-dir and /BACKTRACK:oracatalog.  I can see
> there are 30,000+ files and 240+ gig worth of data.
>
> This is my question.  When I go into the ADSM gui, I see the high level
> file
> space structure of those 2 /BACKTRACK filespaces but don't see any
> file/directory detail.  Why is this?

certification

[Shekhar Dhotre]

Hi all,
I want to appear  for test 599, Tivoli Storage Cert.  trying to call
1-800-959-exam./ 1-866-prometric  the answer comes
checked www.2test.com  , for booking test , but on that web page it asks , user
id and login name .
from where do i get this  , if you point register offline it again points to
www.2test.com .
how to register for this test?
i am in Massachusets.. Somebody from Tivoli pls.  help.

shekhar






"[EMAIL PROTECTED]/P=Internet/A= /C=us" on 09/18/2000 02:47:36 PM
Please respond to "[EMAIL PROTECTED]/P=Internet/A= /C=us" @ X400
To: "[EMAIL PROTECTED]/P=Internet/A= /C=us"@X400
cc:

Subject: Re: Deleting a archive file

In the Windows and OS/2 Backup/Archive Clients,
you can select Delete Archive Data from the Utilities menu.
You can then navigate and delete specific files.
I don't know about other platforms.

On Monday, September 18, 2000 11:16 AM, Bart Colbert
[SMTP:[EMAIL PROTECTED]] wrote:
> Hello,
>
>  Does anyone know how you can delete a specific archive files by say
> "object_id"?
>
>  Say you have two archives with the description of
>  "ARCHIVE1" and "ARCHIVE2"
>
>  You can run a select
>
>  select object_id from archives where description='ARCHIVE1'
>
>  But the delete archive is filespec specific, and I have not found a simple
> solution.
>
> Thanks for any help,
> Bart

Re: Deleting a archive file

[Doug Thorneycroft]

In the Windows and OS/2 Backup/Archive Clients,
you can select Delete Archive Data from the Utilities menu.
You can then navigate and delete specific files.
I don't know about other platforms.

On Monday, September 18, 2000 11:16 AM, Bart Colbert
[SMTP:[EMAIL PROTECTED]] wrote:
> Hello,
>
>  Does anyone know how you can delete a specific archive files by say
> "object_id"?
>
>  Say you have two archives with the description of
>  "ARCHIVE1" and "ARCHIVE2"
>
>  You can run a select
>
>  select object_id from archives where description='ARCHIVE1'
>
>  But the delete archive is filespec specific, and I have not found a simple
> solution.
>
> Thanks for any help,
> Bart

Re: Deleting a archive file

[Shekhar Dhotre]

Delete Archive

The delete archive command deletes archived files from TSM storage. Your
administrator must give you authority to delete archived files.

Attention: When you delete archived files, you cannot retrieve them. Verify
that the files are obsolete before you delete them.

Syntax

>>-Delete ARchive---+---+---+- filespec---+><
'- options--'   '- "filespec"-'


Parameters

options
 You can use these command line options with the delete archive
 command: description, noprompt, and pick. See the command line options




"[EMAIL PROTECTED]/P=Internet/A= /C=us" on 09/18/2000 02:27:08 PM
Please respond to "[EMAIL PROTECTED]/P=Internet/A= /C=us" @ X400
To: "[EMAIL PROTECTED]/P=Internet/A= /C=us"@X400
cc:

Subject: Deleting a archive file

Hello,

 Does anyone know how you can delete a specific archive files by say
"object_id"?

 Say you have two archives with the description of
 "ARCHIVE1" and "ARCHIVE2"

 You can run a select

 select object_id from archives where description='ARCHIVE1'

 But the delete archive is filespec specific, and I have not found a simple
solution.

Thanks for any help,
Bart

Deleting a archive file

[Bart Colbert]

Hello,

 Does anyone know how you can delete a specific archive files by say
"object_id"?

 Say you have two archives with the description of
 "ARCHIVE1" and "ARCHIVE2"

 You can run a select

 select object_id from archives where description='ARCHIVE1'

 But the delete archive is filespec specific, and I have not found a simple
solution.

Thanks for any help,
Bart

Re: Is TSM 3.7.3.6 Stable?

[Othonas Xixis]

Yes, it is stable, we are using it for about 3 months with no problems.
Make sure yr atape, atldd, and SAN euipment are in their latest
version/firmware.

Cheers.

"T.Y. Wu" wrote:

> To support Fibre Channel 3590 interface, I need to go up to 3.7.3.6.  Is
> this a stable level for production?  One entry dated 7/17 stated that
> tape reclaim or del vol would crash the server at this level.   Has
> anybody else bad experience with 3.7.3.6?
>
> Our server environment:  M80/3494/3590, AIX 4330-ML04, TSM 3.7.2.0.
> Atape and atldd are all current.
>
> Thanks, T.Y.

Re: ADSM and SQL-Backtrack

[Lu Ann Mezera]

I am looking there when I am in the dsm GUI.  The folder is there but when I
try to expand it, it is empty.  Is there another way to look at it in the
dsm GUI or should I use a different ADSM tool?  Thanks for your help.

Lu Ann Mezera
Data Center Supervisor
Lab Safety Supply
(608) 757-4909 voice
(608) 757-4652 fax
[EMAIL PROTECTED]


-Original Message-
From: Fluker, Tom R [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 18, 2000 12:02 PM
To: [EMAIL PROTECTED]
Subject: Re: ADSM and SQL-Backtrack


look at "/BACKTRACK:oracatalog" your backups are there

Tom Fluker
Viasystems Technologies

> -Original Message-
> From: Lu Ann Mezera [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, September 18, 2000 12:18 PM
> To:   [EMAIL PROTECTED]
> Subject:  ADSM and SQL-Backtrack
>
> We have ADSM 3.2.1  and are in the processing of implementing SQL
> Backtrack
> to backup up our Oracle databases on AIX and SQL Server 7.0 databases on
> NT.
> We know that Backtrack is pushing the backups to ADSM because when our
> Information Architect goes into Backtrack to do a database restore, she is
> successful.  Also, the amount of scratch tapes in our MagStar are rapidly
> depleting.  When we do a QUERY OCCUPANCY * *  command in dsmadmc, we see
> two
> (2) names for our Database AIX node where the Oracle databases are
> installed
> called /BACKTRACK:tmp-control-dir and /BACKTRACK:oracatalog.  I can see
> there are 30,000+ files and 240+ gig worth of data.
>
> This is my question.  When I go into the ADSM gui, I see the high level
> file
> space structure of those 2 /BACKTRACK filespaces but don't see any
> file/directory detail.  Why is this?

Re: Move / Delete Volume

[Matthew Glanville]

From: Matthew Glanville

I had a similar problem with TSM 3.7.1 on Solaris 2.6 on two different
servers...

I had to audit my database to fix it.  It worked on one of my servers, on
the other the AUDIT Crashes!  I gotta make another call to IBM/Tivoli... :(

Matthew Glanville





"Ulbrink, Birger" <[EMAIL PROTECTED]> on 18/09/2000 08:11:09

Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

To:   [EMAIL PROTECTED]
cc:(bcc: Matthew Glanville/437358/EKC)
Subject:  Move / Delete Volume






For several month I have had 3 copypool tapes, with a pct util of 0.1%,
0.4%
and 0.5%, that is reclaimed several times pr. day.

As you see below moving the data is not possible because there are no data
and deleting, even with discard=yes, is not possible because the volume
still contains data!
Does anyone have a hint!

I am using Windows NT 4.0 SP6a, TSM 3.7.1 server and client.


-
18-09-2000 11:07:32 ANR0984I Process 482 for SPACE RECLAMATION started in
the BACKGROUND at 11:07:32.
18-09-2000 11:07:32 ANR1040I Space reclamation started for volume B0014,
storage pool COPYPOOL1 (process number 482).
18-09-2000 11:07:32 ANR1040I Space reclamation started for volume A0054,
storage pool COPYPOOL1 (process number 482).
18-09-2000 11:07:32 ANR1040I Space reclamation started for volume B0004,
storage pool COPYPOOL1 (process number 482).
18-09-2000 11:07:32 ANR0985I Process 482 for SPACE RECLAMATION running in
the BACKGROUND completed with completion state SUCCESS at 11:07:32.
18-09-2000 11:07:32 ANR1041I Space reclamation ended for volume B0014.
18-09-2000 11:07:32 ANR1041I Space reclamation ended for volume A0054.
18-09-2000 11:07:32 ANR1041I Space reclamation ended for volume B0004.
--
18-09-2000 11:28:14 ANR2017I Administrator ADMIN issued command: MOVE DATA
A0054 STGPOOL=COPYPOOL1 WAIT=YES
18-09-2000 11:28:14 ANR2209W Volume A0054 contains no data.
18-09-2000 11:29:45 ANR2017I Administrator ADMIN issued command: DELETE
VOLUME A0054 DISCARDDATA=YES WAIT=YES
18-09-2000 11:29:45 ANR2406E DELETE VOLUME: Volume A0054 still contains
data.
-


Med venlig hilsen / Kind regards
Birger Ulbrink
Netværksadministrator / Network administration

METRO Cash & Carry ApS.
IT afdelingen /  IT department
Ejby Industrivej 111
DK 2600 Glostrup

Tel  +45 43467700
Tel  +45 43467819 (direct)
Fax +45 43452321
Email   [EMAIL PROTECTED] 

using adsm to restore nt 4.0 server

[Tim Brown]

i am able to use adsm to migrate a novell server to a new server in the
case where
the server hardware is being upgraded. this is a fairly simple task
since the only major differences
between the old server and the new server are the ethernet, disk and
cdrom drivers...

i tried this same tactic once on a windows nt 4.0 server platform and it
did not work.
since the hardware was totally different windows would not startup after
i installed nt 4.0 into
a separate partition and then restored the original windows nt c: drive
via adsm...

is this inability to upgrade a windows nt 4.0 server to a new hardware
platform a problem
with nt or adsm. with what i have read nt 4.0 restoration must be done
to a similar hardware
 platform. what have others done to upgrade windows nt to a new server
and can adsm
 be used in conjunction...

tim brown


begin:vcard
n:Brown;Tim
tel;fax:914-486-5921
tel;work:914-486-5643
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Specialist
x-mozilla-cpt:;8176
fn:Tim  Brown
end:vcard

Re: Move / Delete Volume

[Doug Thorneycroft]

Have you tried running audit vol A0054 f=y

On Monday, September 18, 2000 5:11 AM, Ulbrink, Birger
[SMTP:[EMAIL PROTECTED]] wrote:
> For several month I have had 3 copypool tapes, with a pct util of 0.1%, 0.4%
> and 0.5%, that is reclaimed several times pr. day.
>
> As you see below moving the data is not possible because there are no data
> and deleting, even with discard=yes, is not possible because the volume
> still contains data!
> Does anyone have a hint!
>
> I am using Windows NT 4.0 SP6a, TSM 3.7.1 server and client.
>
>
> -
> 18-09-2000 11:07:32 ANR0984I Process 482 for SPACE RECLAMATION started in
> the BACKGROUND at 11:07:32.
> 18-09-2000 11:07:32 ANR1040I Space reclamation started for volume B0014,
> storage pool COPYPOOL1 (process number 482).
> 18-09-2000 11:07:32 ANR1040I Space reclamation started for volume A0054,
> storage pool COPYPOOL1 (process number 482).
> 18-09-2000 11:07:32 ANR1040I Space reclamation started for volume B0004,
> storage pool COPYPOOL1 (process number 482).
> 18-09-2000 11:07:32 ANR0985I Process 482 for SPACE RECLAMATION running in
> the BACKGROUND completed with completion state SUCCESS at 11:07:32.
> 18-09-2000 11:07:32 ANR1041I Space reclamation ended for volume B0014.
> 18-09-2000 11:07:32 ANR1041I Space reclamation ended for volume A0054.
> 18-09-2000 11:07:32 ANR1041I Space reclamation ended for volume B0004.
> --
> 18-09-2000 11:28:14 ANR2017I Administrator ADMIN issued command: MOVE DATA
> A0054 STGPOOL=COPYPOOL1 WAIT=YES
> 18-09-2000 11:28:14 ANR2209W Volume A0054 contains no data.
> 18-09-2000 11:29:45 ANR2017I Administrator ADMIN issued command: DELETE
> VOLUME A0054 DISCARDDATA=YES WAIT=YES
> 18-09-2000 11:29:45 ANR2406E DELETE VOLUME: Volume A0054 still contains
> data.
> -
>
>
> Med venlig hilsen / Kind regards
> Birger Ulbrink
> Netverksadministrator / Network administration
>
> METRO Cash & Carry ApS.
> IT afdelingen /  IT department
> Ejby Industrivej 111
> DK 2600 Glostrup
>
> Tel  +45 43467700
> Tel  +45 43467819 (direct)
> Fax +45 43452321
> Email   [EMAIL PROTECTED] 

Re: installing 4.1 clinet fro solaris

[Viswanathan, Ramesh (CNA)]

Try the following:

1. Change directory to the location where you unpacked the package
2. Execute the command: /usr/sbin/pkgadd -d .

Don't forget the trailing '.' which points to the current directory.  You
should get as screen similar to:

# pkgadd -d .

The following packages are available:
  1  TIVsmCapi Tivoli Storage Manager Solaris 32/64bit API
   (sparc) Version 3 Release 7 Level 2
  2  TIVsmCba  Tivoli Storage Manager Solaris 2.6 Client
   (sparc) Version 3 Release 7 Level 2
  3  TIVsmCdoc Tivoli Storage Manager Solaris 2.6 Documentation
   (sparc) Version 3 Release 7 Level 2
  4  TIVsmChsm Tivoli Storage Manager Solaris 2.6 HSM Client
   (sparc) Version 3 Release 7 Level 2

Select package(s) you wish to process (or 'all' to process
all packages). (default: all) [?,??,q]:

You can then select the packgages you want to install.

Ramesh

Backupsets from a MVS server

[Sterling James]

Hello,
I'm running a TSM 3.7 server on OS390 2.5. My question is;
Is anyone using backupsets from MVS? Or has anyone considered using
backupsets
What techniques is or could be used to make them accessible to the clients?

TIA

Re: ADSM and SQL-Backtrack

[Fluker, Tom R]

look at "/BACKTRACK:oracatalog" your backups are there

Tom Fluker
Viasystems Technologies

> -Original Message-
> From: Lu Ann Mezera [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, September 18, 2000 12:18 PM
> To:   [EMAIL PROTECTED]
> Subject:  ADSM and SQL-Backtrack
>
> We have ADSM 3.2.1  and are in the processing of implementing SQL
> Backtrack
> to backup up our Oracle databases on AIX and SQL Server 7.0 databases on
> NT.
> We know that Backtrack is pushing the backups to ADSM because when our
> Information Architect goes into Backtrack to do a database restore, she is
> successful.  Also, the amount of scratch tapes in our MagStar are rapidly
> depleting.  When we do a QUERY OCCUPANCY * *  command in dsmadmc, we see
> two
> (2) names for our Database AIX node where the Oracle databases are
> installed
> called /BACKTRACK:tmp-control-dir and /BACKTRACK:oracatalog.  I can see
> there are 30,000+ files and 240+ gig worth of data.
>
> This is my question.  When I go into the ADSM gui, I see the high level
> file
> space structure of those 2 /BACKTRACK filespaces but don't see any
> file/directory detail.  Why is this?

ADSM and SQL-Backtrack

[Lu Ann Mezera]

We have ADSM 3.2.1  and are in the processing of implementing SQL Backtrack
to backup up our Oracle databases on AIX and SQL Server 7.0 databases on NT.
We know that Backtrack is pushing the backups to ADSM because when our
Information Architect goes into Backtrack to do a database restore, she is
successful.  Also, the amount of scratch tapes in our MagStar are rapidly
depleting.  When we do a QUERY OCCUPANCY * *  command in dsmadmc, we see two
(2) names for our Database AIX node where the Oracle databases are installed
called /BACKTRACK:tmp-control-dir and /BACKTRACK:oracatalog.  I can see
there are 30,000+ files and 240+ gig worth of data.

This is my question.  When I go into the ADSM gui, I see the high level file
space structure of those 2 /BACKTRACK filespaces but don't see any
file/directory detail.  Why is this?

Re: ADSM 4.1

[Lloyd Dieter]

Larry-

Also, don't forget that the licensing scheme has changed, and you will need to re-run 
the "register license" command.

-Lloyd

Dominic_Talbot wrote:
>
> Hello, please view the information below:
> When the Tivoli Storage Manager Version 4.1 is started over a database that
> was written by ADSM or a previous version of Tivoli Storage Manager, the
> database is automatically upgraded.
> I have tried it, at it did upgrade automatically, make sure that you backup
> your database, devconfig, volhist before you do it, just in case
>
> Regards
> Dominic Talbot
>
> > -Original Message-

> > From: Lawrence Clark [SMTP:[EMAIL PROTECTED]]
> > Sent: 18 September 2000 07:19
> > To:   [EMAIL PROTECTED]
> > Subject:  ADSM 4.1
> >
> > Hi:
> > We were expecting to migrate to TSM 3.7 from ADSM 3.1. Instead  TSM 4.1
> > was delivered.
> > Has anyone done this, and can 4.1 go over a 3.1 install? Does it do the db
> > upgrade as part of the install?
> >
> > Larry Clark
> > NYS Thruway Authority

--
-
Lloyd Dieter-   Senior Technology Consultant
   Synergy, Inc.   http://www.synergyinc.cc   [EMAIL PROTECTED]
 Main:716-389-1260fax:716-389-1267
-

installing 4.1 clinet fro solaris

[Shekhar Dhotre]

Hi all,
Downloaded  package from tivoli web site , uncompressed  by command
compress -d  IP22087 ,  unpacked ,
when tried to install , gives following error.



# pkgadd -d TIVsmCapi
pkgadd: ERROR: no packages were found in 


what could be the problme ? I am following exact steps in Readme .ftp


shekhar

Cut MVS CPU Utilization

[Darlene E Wnukowski]

Good news! I have been running for a week with rewritten ADSM backup scripts
and my CPU utilization has not gone above 10% of our 7060-H50. Most of the
time it's under 5%. I rewrote my daily ADSM backup scripts to remove the
parameter "wait=yes". I had to break the scripts up to do one command in each
and check for the completion of the previous task before issuing another
command or running another script, but it worked!! I am willing to send copies
of the scripts I am running to you if requested. Neither I nor my company are
warranting them but you are free to adapt them to your needs.



Darlene E. Wnukowski
Lead Systems Programmer
Schreiber Foods, Inc.
[EMAIL PROTECTED]
920-455-6268





**

This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity
to whom they are addressed. If you have received this email
in error please notify [EMAIL PROTECTED]

This footnote also confirms that this email message has been
swept by MIMEsweeper for the presence of computer viruses.

**

Re: ADSM 4.1

[Dominic_Talbot]

Hello, please view the information below:
When the Tivoli Storage Manager Version 4.1 is started over a database that
was written by ADSM or a previous version of Tivoli Storage Manager, the
database is automatically upgraded.
I have tried it, at it did upgrade automatically, make sure that you backup
your database, devconfig, volhist before you do it, just in case

Regards
Dominic Talbot

> -Original Message-
> From: Lawrence Clark [SMTP:[EMAIL PROTECTED]]
> Sent: 18 September 2000 07:19
> To:   [EMAIL PROTECTED]
> Subject:  ADSM 4.1
>
> Hi:
> We were expecting to migrate to TSM 3.7 from ADSM 3.1. Instead  TSM 4.1
> was delivered.
> Has anyone done this, and can 4.1 go over a 3.1 install? Does it do the db
> upgrade as part of the install?
>
> Larry Clark
> NYS Thruway Authority

AW: Problems with BACKINT

[Rupp Thomas (Illwerke)]

I had the same problem. Uninstalling the 4.1 backup client and the TDP agent
3.1
didn't help. After uninstalling I had to remove the TSM*.DLL and
BLKHOOK*.DLL from
C:\WINNT\SYSTEM32.
Then I reinstalled and everything worked fine.

Kind regards
Thomas Rupp
Vorarlberger Illwerke AG
MAIL:   [EMAIL PROTECTED]
TEL:++43/5574/4991-251
FAX:++43/5574/4991-820-8251


> -Ursprüngliche Nachricht-
> Von:  Nicholas Cassimatis/Raleigh/IBM [SMTP:[EMAIL PROTECTED]]
> Gesendet am:  Montag, 18. September 2000 16:24
> An:   [EMAIL PROTECTED]
> Betreff:  Re: Problems with BACKINT
> 
> BKI0067E: Tivoli Data Protection for SAP R/3 needs Tivoli Storage
> Manager-API
> 3.X.X or older.
> 
> You have TSM 4.x on the system, but the version of BackInt doesn't support
> it.  You either need to upgrade to the TDP agent for SAP, or downlevel
> your
> ADSM code.
> 
> Nick Cassimatis
> [EMAIL PROTECTED]
> 
> "I'm one cookie away from happy." - Snoopy (Charles Schulz)

TSM 3.7 Database unload/reload

[Jeff Connor]

 Our TSM V3.7 server running on OS/390 has a 32GB database
that's 85% utilized.  We have been adding volumes over the last 5
or so years starting with ADSM version 1 and have never done an
unload/reload/re-org.  I've been thinking of trying to unload and
reload this servers database and was wondering what other TSM 3.7
or 4.1 users have experienced after attempting an unload/reload.
I remember hearing stories in the past on the listserv about this
process running for days, database growing in size on the reload,
etc.  I'm wondering if the long outage is worth it and what gains
you might have realized in terms of better performance, database
size reduction, etc. after unloading/reloading your database.
Any idea how many hours it might take to perform this process on
a 32GB database?


Thanks
Jeff Connor
Niagara Mohawk Power Corp

Re: ADSM 4.1

[Kirsten Gloeer]

Hi,

TSM 4.1 is said to be very instable. Ts is better to install TSM 4.1.1

Best regards,
Kirsten Gloeer

>Hi:
>We were expecting to migrate to TSM 3.7 from ADSM 3.1. Instead  TSM 4.1 was delivered.
>Has anyone done this, and can 4.1 go over a 3.1 install? Does it do the db upgrade as 
>part of the install?
>
>Larry Clark
>NYS Thruway Authority
>

ADSM 4.1

[Lawrence Clark]

Hi:
We were expecting to migrate to TSM 3.7 from ADSM 3.1. Instead  TSM 4.1 was delivered.
Has anyone done this, and can 4.1 go over a 3.1 install? Does it do the db upgrade as 
part of the install?

Larry Clark
NYS Thruway Authority

Re: Problems with BACKINT

[Nicholas Cassimatis/Raleigh/IBM]

BKI0067E: Tivoli Data Protection for SAP R/3 needs Tivoli Storage
Manager-API
3.X.X or older.

You have TSM 4.x on the system, but the version of BackInt doesn't support
it.  You either need to upgrade to the TDP agent for SAP, or downlevel your
ADSM code.

Nick Cassimatis
[EMAIL PROTECTED]

"I'm one cookie away from happy." - Snoopy (Charles Schulz)

Re: backup copy pools

[Tim Williams]

How many actual volumes are in db_dpool?...never mind, although that is a
consideration...
Check your disk pool: db_dpool and its setup!
See that this pool will migrate to DB_TPOOL AND that there's a migration in
process and you are wanting
to do a backup stgpool from db_dpool to dr_pr1db1??
so for migrations you are going to one pool..and for backup storage pool you
want to go do another??
good methodology??
Usually (I believe) one wants to clear disk dailyand to backup storage pools
from tape to tape...
not too sure about the why, but I wouldn't subscribe to this methodology...
FYI Thanks Tim

  Next Storage Pool: DB_TPOOL
  Migration in Progress?: Yes

 Command: ba stg db_dpool dr_pr1db1 maxpr=3







"Davidson, Becky" <[EMAIL PROTECTED]>
09/18/2000 09:12 AM

Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

To:   [EMAIL PROTECTED]
cc:

Subject:  backup copy pools

I am trying to backup my disk pool to a tape pool.  I need to run multiple
session to get a decent backup time but I can't seem to get it to run
multiple sessions.  Any advice?

AIX - 4.3.3
ADSM Server - 3.1.2.40

adsm> q sch dr_pr1 t=a f=d

 Schedule Name: DR_PR1
   Description:
   Command: ba stg db_dpool dr_pr1db1 maxpr=3
  Priority: 7
   Start Date/Time: 09/11/00   23:00:00
  Duration: 1 Hour(s)
Period: 1 Day(s)
   Day of Week: Any
Expiration:
   Active?: Yes
Last Update by (administrator): ADMIN
 Last Update Date/Time: 09/14/00   17:21:43
  Managing profile:


adsm> q stg db_dpool f=d

   Storage Pool Name: DB_DPOOL
   Storage Pool Type: Primary
   Device Class Name: DISK
 Estimated Capacity (MB): 373,632.0
Pct Util: 25.1
Pct Migr: 25.1
 Pct Logical: 100.0
High Mig Pct: 1
 Low Mig Pct: 1
 Migration Delay: 0
  Migration Continue: Yes
 Migration Processes: 6
   Next Storage Pool: DB_TPOOL
Reclaim Storage Pool:
  Maximum Size Threshold: No Limit
  Access: Read/Write
 Description:
   Overflow Location:
   Cache Migrated Files?: No
  Collocate?:
   Reclamation Threshold:
 Maximum Scratch Volumes Allowed:
   Delay Period for Volume Reuse:
  Migration in Progress?: Yes
Amount Migrated (MB): 337,662.00
Elapsed Migration Time (seconds): 155,146
Reclamation in Progress?:
 Volume Being Migrated/Reclaimed:
  Last Update by (administrator): ADMIN
   Last Update Date/Time: 09/18/00   03:00:02



adsm> q stg dr_pr1db1 f=d

   Storage Pool Name: DR_PR1DB1
   Storage Pool Type: Copy
   Device Class Name: 3590TAPE
 Estimated Capacity (MB): 200,478,940.6
Pct Util: 0.4
Pct Migr:
 Pct Logical: 99.7
High Mig Pct:
 Low Mig Pct:
 Migration Delay:
  Migration Continue:
 Migration Processes:
   Next Storage Pool:
Reclaim Storage Pool:
  Maximum Size Threshold:
  Access: Read/Write
 Description:
   Overflow Location:
   Cache Migrated Files?:
  Collocate?: No
   Reclamation Threshold: 100
 Maximum Scratch Volumes Allowed: 9,999
   Delay Period for Volume Reuse: 0 Day(s)
  Migration in Progress?:
Amount Migrated (MB):
Elapsed Migration Time (seconds):
Reclamation in Progress?: No
 Volume Being Migrated/Reclaimed:
  Last Update by (administrator): ADMIN
   Last Update Date/Time: 09/10/00   18:56:26



Thanks in advance
Becky Davidson
Data Manager/AIX Administrator
EDS/Earthgrains
voice: 314-259-7589
fax: 314-877-8589
email: [EMAIL PROTECTED]

Re: Onbar and Solaris error

[Scott Crockford]

Marc,
   I am assuming you meant Solaris 2.7, not 2.6.  Either way, the problem
is with your TSM client.  Anything before version 4 of the TSM client does
not contain the 64bit API that INFORMIX needs to preform the backup.  You
either have to upgrade your ADSM client to a version 4 or downgrade to the
32 INFORMIX database engine.  I personally had to choose the 32bit solution
as version 4 of the client wasn't available at the time I upgraded.

Scott Crockford
DBA

At 11:32 AM 9/18/00 +0200, you wrote:
>Hi All
>
>We are trying to configure Informix to backup to TSM. We are however getting
>the following error:
>   2000-09-15 13:53:44 10807  10805 An unexpected error occurred:  ld.so.1:
>/usr/informix/bin/onbar_d: fatal: /usr/lib/sparcv9/ibsad001.so: open failed:
>No such file or directory .
>  2000-09-15 13:53:44 10807  10805 Could not open XBSA library
>/usr/lib/sparcv9/ibsad001.so.
>  2000-09-15 13:53:44 10807  10805 An unexpected error occurred:  ld.so.1:
>/usr/informix/bin/onbar_d: fatal: /usr/lib/sparcv9/ibsad001.so: open failed:
>No such file or directory .
>  2000-09-15 13:53:44 10807  10805 Could not open XBSA library
>/usr/lib/sparcv9/ibsad001.so.
>  2000-09-15 13:53:44 10807  10805 /usr/informix/bin/onbar_d complete,
>returning 152 (0x98)
>
>
>Can anyone tell me in which manual i can find information for setting up
>Onbar to work with TSM. I have the old procedure for setting it up in AIX
>using ADSM but a few things are different i.e. no bsashr10.o file.
>TSM ver 3.7.1.0
>Solaris ver 2.6 (64biT)
>Informix IDS ver 9.2
>  Also link in /usr/lib/sparcv9/ibsad001.so is set correctly as well as all
>environement variables.
>The correct procedure or a point in the right direction would be greatly
>appreciated.
>
>Thanks
>Marc
>
>_
>
>Marc Layne
>Product Manager - Storage and Software Solutions
>Faritec
>
>Mobile: +27 82 4169086email: [EMAIL PROTECTED]
>Office:  + 27 21 7629702   http://www.faritec.co.za
>_

backup copy pools

[Davidson, Becky]

I am trying to backup my disk pool to a tape pool.  I need to run multiple
session to get a decent backup time but I can't seem to get it to run
multiple sessions.  Any advice?

AIX - 4.3.3
ADSM Server - 3.1.2.40

adsm> q sch dr_pr1 t=a f=d

 Schedule Name: DR_PR1
   Description:
   Command: ba stg db_dpool dr_pr1db1 maxpr=3
  Priority: 7
   Start Date/Time: 09/11/00   23:00:00
  Duration: 1 Hour(s)
Period: 1 Day(s)
   Day of Week: Any
Expiration:
   Active?: Yes
Last Update by (administrator): ADMIN
 Last Update Date/Time: 09/14/00   17:21:43
  Managing profile:


adsm> q stg db_dpool f=d

   Storage Pool Name: DB_DPOOL
   Storage Pool Type: Primary
   Device Class Name: DISK
 Estimated Capacity (MB): 373,632.0
Pct Util: 25.1
Pct Migr: 25.1
 Pct Logical: 100.0
High Mig Pct: 1
 Low Mig Pct: 1
 Migration Delay: 0
  Migration Continue: Yes
 Migration Processes: 6
   Next Storage Pool: DB_TPOOL
Reclaim Storage Pool:
  Maximum Size Threshold: No Limit
  Access: Read/Write
 Description:
   Overflow Location:
   Cache Migrated Files?: No
  Collocate?:
   Reclamation Threshold:
 Maximum Scratch Volumes Allowed:
   Delay Period for Volume Reuse:
  Migration in Progress?: Yes
Amount Migrated (MB): 337,662.00
Elapsed Migration Time (seconds): 155,146
Reclamation in Progress?:
 Volume Being Migrated/Reclaimed:
  Last Update by (administrator): ADMIN
   Last Update Date/Time: 09/18/00   03:00:02



adsm> q stg dr_pr1db1 f=d

   Storage Pool Name: DR_PR1DB1
   Storage Pool Type: Copy
   Device Class Name: 3590TAPE
 Estimated Capacity (MB): 200,478,940.6
Pct Util: 0.4
Pct Migr:
 Pct Logical: 99.7
High Mig Pct:
 Low Mig Pct:
 Migration Delay:
  Migration Continue:
 Migration Processes:
   Next Storage Pool:
Reclaim Storage Pool:
  Maximum Size Threshold:
  Access: Read/Write
 Description:
   Overflow Location:
   Cache Migrated Files?:
  Collocate?: No
   Reclamation Threshold: 100
 Maximum Scratch Volumes Allowed: 9,999
   Delay Period for Volume Reuse: 0 Day(s)
  Migration in Progress?:
Amount Migrated (MB):
Elapsed Migration Time (seconds):
Reclamation in Progress?: No
 Volume Being Migrated/Reclaimed:
  Last Update by (administrator): ADMIN
   Last Update Date/Time: 09/10/00   18:56:26



Thanks in advance
Becky Davidson
Data Manager/AIX Administrator
EDS/Earthgrains
voice: 314-259-7589
fax: 314-877-8589
email: [EMAIL PROTECTED]

Oracle 64bit backups

[Good Friend]

Hello,

Is anyone using TSM for Oracle 8.1.6 running on hp clients?
I've checked the Tivoli site but could not find any info on this.

thanks,
allwyn 

schedule failing .

[Shekhar Dhotre]

Any Idea?

Server Window Start:   23:30:17 on 09/17/00

Schedule will be refreshed in 12 hours.

Time remaining until execution: Querying server for next scheduled event.
Node Name: MEDRS1
Session established with server TSM: AIX-RS/6000
  Server Version 3, Release 7, Level 2.0
  Data compression forced on by the server
  Server date/time: 09/17/00   12:25:55  Last access: 09/17/00   01:21:26

Next operation scheduled:

Schedule Name: MEDRS
Action:Incremental
Objects:
Options:
Server Window Start:   23:30:17 on 09/17/00

Command will be executed in 11 hours and 10 minutes.

Time remaining until execution: 11:10:00
Executing scheduled command now.
IOT/Abort trap(coredump)
medrs1:

TDP for Oracle in Solaris cluster

[Christopher A Campbell]

Is anyone using TDP for Oracle in a Solaris cluster who would be prepared
to share
how they configured TDP/RMAN for failover between nodes?

Thanks Chris

Chris Campbell
Tivoli Services TeamITS, IBM Global Services
IBM Ireland, 24/32 Pembroke Road, Dublin 4, Ireland
Phone  :  +353-1-815-4146Internal 50-4146 Fax +353-1-815-4304
Internet :  [EMAIL PROTECTED]

Re: Show commands

[Richard Sims]

>See below and check Richard Sims' web page.
>Hey Richard, Thought about putting the sorted list within their own pages so it
>can come up quicker?

Hi, Tim - I have indeed been thinking of doing that.  The lineage of the
  document is a survival reference, to preserve hard-won facts.  (How
many times we all end up searching for a piece of information we saw months
ago and now need in a crunch.)  As such it was a flat file that was printed
and put into binders for reference.  I need to accommodate that need as well
as make it web-friendly.  Time is the hard part... ADSM/TSM is just a minor
part of the work I have to do.  But I'll certainly get to it.  I'm glad to
see that it's of use out there, as an experiential extension of official
vendor documentation, to the point that enhancements are sought.
Suggestions such as yours are always welcome.

  Richard of http://people.bu.edu/rbs/ADSM.QuickFacts

Re: ADSM for Exchange Restores

[Del Hoobler]

Paul,

The first thing I would do is get the latest version
of TDP for Exchange.  You should be getting
TDP for Exchange version 1.1.1.01, which can be found
on the ftp.software.ibm.com FTP server.
Look in

   /storage/tivoli-storage-management/patches/agents/ntexch/1.1.1

for:

   IC25816_01.EXE

Secondly, if you are not using/checking the "erase existing"
option during restore, you need to be very aware of the sequential order
of the restored AND pre-existing logs to make sure there is no gap in
sequence.

Thanks,

Del



Del Hoobler
IBM Corporation
[EMAIL PROTECTED]


Paul Dowie <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 09/17/2000 10:52:01 PM

Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

Sent by:  "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>


To:   [EMAIL PROTECTED]
cc:
Subject:  ADSM for Exchange Restores



Hi

Is anyone using ADSM for Exchange with differential backups ?. I am having
no problem with Full backups and then restoring but when restoring a
differential and then attempting to roll forward I am having inconsistent
problems with restarting the IS.

Server is OS390 v3.release1.level2.5, client is ADSM v1 r1 level 0

Does anyone have any best practise suggestions for restoring from incr or
diff ?

thanks

[EMAIL PROTECTED]

Re: Backing up legacy systems / standard input?

[Richard Sims]

>There was a rumour that adsmpipe would be supplied and supported with V4.

I'd be surprised if it were: IBM has consistently said that ADSMPIPE is
obsolete and part of the past.  What we really need, of course, is
long overdue enhancement of the capabilities of the command line clients.
  Richard

Re: ADSM for Exchange Restores

[Fenstermaker,Bob]

We have different sites around the world.
We use incremental/fulls for the those sites.
I have not had any problem restoring incrementals.

How are you doing the restores now?

What is your procedure?


Thanks

-Original Message-
From: Paul Dowie [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 17, 2000 10:52 PM
To: [EMAIL PROTECTED]
Subject: ADSM for Exchange Restores


Hi

Is anyone using ADSM for Exchange with differential backups ?. I am having
no problem with Full backups and then restoring but when restoring a
differential and then attempting to roll forward I am having inconsistent
problems with restarting the IS.

Server is OS390 v3.release1.level2.5, client is ADSM v1 r1 level 0

Does anyone have any best practise suggestions for restoring from incr or
diff ?

thanks

[EMAIL PROTECTED]

Move / Delete Volume

[Ulbrink, Birger]

For several month I have had 3 copypool tapes, with a pct util of 0.1%, 0.4%
and 0.5%, that is reclaimed several times pr. day.

As you see below moving the data is not possible because there are no data
and deleting, even with discard=yes, is not possible because the volume
still contains data!
Does anyone have a hint!

I am using Windows NT 4.0 SP6a, TSM 3.7.1 server and client.


-
18-09-2000 11:07:32 ANR0984I Process 482 for SPACE RECLAMATION started in
the BACKGROUND at 11:07:32.
18-09-2000 11:07:32 ANR1040I Space reclamation started for volume B0014,
storage pool COPYPOOL1 (process number 482).
18-09-2000 11:07:32 ANR1040I Space reclamation started for volume A0054,
storage pool COPYPOOL1 (process number 482).
18-09-2000 11:07:32 ANR1040I Space reclamation started for volume B0004,
storage pool COPYPOOL1 (process number 482).
18-09-2000 11:07:32 ANR0985I Process 482 for SPACE RECLAMATION running in
the BACKGROUND completed with completion state SUCCESS at 11:07:32.
18-09-2000 11:07:32 ANR1041I Space reclamation ended for volume B0014.
18-09-2000 11:07:32 ANR1041I Space reclamation ended for volume A0054.
18-09-2000 11:07:32 ANR1041I Space reclamation ended for volume B0004. 
--
18-09-2000 11:28:14 ANR2017I Administrator ADMIN issued command: MOVE DATA
A0054 STGPOOL=COPYPOOL1 WAIT=YES
18-09-2000 11:28:14 ANR2209W Volume A0054 contains no data.
18-09-2000 11:29:45 ANR2017I Administrator ADMIN issued command: DELETE
VOLUME A0054 DISCARDDATA=YES WAIT=YES
18-09-2000 11:29:45 ANR2406E DELETE VOLUME: Volume A0054 still contains
data. 
-


Med venlig hilsen / Kind regards
Birger Ulbrink
Netværksadministrator / Network administration
 
METRO Cash & Carry ApS.
IT afdelingen /  IT department
Ejby Industrivej 111
DK 2600 Glostrup

Tel  +45 43467700
Tel  +45 43467819 (direct)
Fax +45 43452321
Email   [EMAIL PROTECTED]  

Tim Melly/WESTH/PH/US/BAYER is out of the office.

[Tim Melly]

I will be out of the office from 09/18/2000 until 09/21/2000.

I will respond to your message when I return.

Onbar and Solaris error

[Marc Layne]

Hi All

We are trying to configure Informix to backup to TSM. We are however getting
the following error:
  2000-09-15 13:53:44 10807  10805 An unexpected error occurred:  ld.so.1:
/usr/informix/bin/onbar_d: fatal: /usr/lib/sparcv9/ibsad001.so: open failed:
No such file or directory .
 2000-09-15 13:53:44 10807  10805 Could not open XBSA library
/usr/lib/sparcv9/ibsad001.so.
 2000-09-15 13:53:44 10807  10805 An unexpected error occurred:  ld.so.1:
/usr/informix/bin/onbar_d: fatal: /usr/lib/sparcv9/ibsad001.so: open failed:
No such file or directory .
 2000-09-15 13:53:44 10807  10805 Could not open XBSA library
/usr/lib/sparcv9/ibsad001.so.
 2000-09-15 13:53:44 10807  10805 /usr/informix/bin/onbar_d complete,
returning 152 (0x98)


Can anyone tell me in which manual i can find information for setting up
Onbar to work with TSM. I have the old procedure for setting it up in AIX
using ADSM but a few things are different i.e. no bsashr10.o file.
TSM ver 3.7.1.0
Solaris ver 2.6 (64biT)
Informix IDS ver 9.2
 Also link in /usr/lib/sparcv9/ibsad001.so is set correctly as well as all
environement variables.
The correct procedure or a point in the right direction would be greatly
appreciated.

Thanks
Marc

_

Marc Layne
Product Manager - Storage and Software Solutions
Faritec

Mobile: +27 82 4169086email: [EMAIL PROTECTED]
Office:  + 27 21 7629702   http://www.faritec.co.za
_