SQL query of ADSM backups table

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 wh

EXPORT SERVER not dumping backup index data

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 ind

Re: Cut MVS CPU Utilization

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 Ide

Problem deleting database backup volhistory records

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

Re: Oracle 64bit backups

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]>

Re: TSM 3.7 Database unload/reload

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. Tha

Re: backup copy pools

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? > >

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

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

Errors trying to connect Oracle/RMAN with TDP

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: === ERRO

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 begin:vcard n:Marshall;Erika x-mozilla-html:FALSE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] fn:Erik

Re: certification

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: certific

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 cu

Deleting archive files revised

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

search for hal.dll

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

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

Re: using adsm to restore nt 4.0 server

> 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

Re: ADSM and SQL-Backtrack

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' /*

Re: ADSM and SQL-Backtrack

> 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 i

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 McN

Re: ADSM and SQL-Backtrack

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 obje

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 poi

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

Re: Deleting a archive file

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 >>-Dele

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 specifi

Re: Is TSM 3.7.3.6 Stable?

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? On

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

Re: Move / Delete Volume

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, Birg

using adsm to restore nt 4.0 server

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 on

Re: Move / Delete Volume

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 dat

Re: installing 4.1 clinet fro solaris

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

Backupsets from a MVS server

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

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.

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

Re: ADSM 4.1

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

installing 4.1 clinet fro solaris

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

Cut MVS CPU Utilization

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

Re: ADSM 4.1

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 ba

AW: Problems with BACKINT

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 PR

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 wo

Re: ADSM 4.1

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 t

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

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

Re: backup copy pools

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?? s

Re: Onbar and Solaris error

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 t

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

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

schedule failing .

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

TDP for Oracle in Solaris cluster

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-4146

Re: Show commands

>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. (Ho

Re: ADSM for Exchange Restores

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

Re: Backing up legacy systems / standard input?

>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

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:[EM

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! D

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

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

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