Re: 5.1.5 only 32 bit for aix 4.3.3?

[Williams, Tim P {PBSG}]

read the readme for...the tsm client for aix 4.3.3...it is for
aix5 and aix 4 (but 32 bit)...
**
64 bit is only for aix 5, running 64 bit...
bootinfo -K
FYI

-Original Message-
From: Conko, Steven [mailto:[EMAIL PROTECTED]
Sent: Friday, March 07, 2003 10:25 AM
To: [EMAIL PROTECTED]
Subject: Re: 5.1.5 only 32 bit for aix 4.3.3?


> Is version 5.1.5 only available as a 32 bit application for AIX 4.3.3? I
> found the 64 bit b/a module for AIX 5.1, but only 32 bit for 4.3.3... any
> idea why??
>
> Steven A. Conko
> Senior Unix Systems Administrator
> ADT Security Services, Inc.
>

FW: table and column differences between v4 and v5.

[Williams, Tim P {PBSG}]

FYI...as this is probably undocumented
(I had scripted jobs/macros that went against tables/columns...)...
partial response to support:
this coulda/shoulda been doc'd...opinion...
changing cmd format...it has been debated that you'all own that...
now select/db queries...seem to have been made fair game
(our history)...
I'll send a note to marist listserv for other customers...here's what
I'll probably send:

Thanks Tim Williams
pbsg DFW/Texas...


TSM FOR AIX DIFFERENCES BETWEEN V4R2 LEVEL 2.0 AND
TSM FOR AIX __  V5R1 LEVEL 6.1
2 NEW TABLES...(the I in the left column means inserted or new...to v5
TSMD means deleted).
 I - DISKS
 D - DRIVEMAPS
 I - SAN

column differences (table listed on the left, column name on the right).
(I in the left column means inserted or new to V5 TSM, D means deleted)
 I - DATAMOVERS WWN
 I - DATAMOVERS SERIAL
 I - DATAMOVERS COPYTHREADS

 I - DISKS  NODE_NAME
 I - DISKS  DISK_NAME
 I - DISKS  WWN
 I - DISKS  SERIAL
 I - DISKS  ONLINE
 I - DISKS  LAST_UPDATE_BY
 I - DISKS  LAST_UPDATE

 D - DRIVEMAPS  SERVICE_NAME
 D - DRIVEMAPS  LIBRARY_NAME
 D - DRIVEMAPS  DRIVE_NAME
 D - DRIVEMAPS  DEVICE
 D - DRIVEMAPS  ONLINE
 D - DRIVEMAPS  DIRECTORY
 D - DRIVEMAPS  LAST_UPDATE_BY
 D - DRIVEMAPS  LAST_UPDATE

 D - DRIVES DEVICE
 I - DRIVES DRIVE_STATE

 D - LIBRARIES  DEVICE
 I - LIBRARIES  PRIMARY_LIB_MGR
 I - LIBRARIES  AUTOLABEL

 D - LICENSES   MGSYSLAN_ACT
 D - LICENSES   MGSYSLAN_LIC
 D - LICENSES   MGSYSSAN_ACT
 D - LICENSES   MGSYSSAN_LIC
 I - LICENSES   MGSYSLAN_ACT
 I - LICENSES   MGSYSLAN_LIC
 I - LICENSES   MGSYSSAN_ACT
 I - LICENSES   MGSYSSAN_LIC
 I - LICENSES   NDMP_ACT
 I - LICENSES   NDMP_LIC

 I - NODES  VALIDATEPROTOCOL
 I - NODES  TCP_NAME
 I - NODES  TCP_ADDRESS
 I - NODES  GUID

 I - PATHS  NODE_NAME
 I - PATHS  EXTERNAL_MANAGER
 D - PATHS  DEVICE_ID

 I - SANDEVICE_TYPE
 I - SANVENDOR
 I - SANPRODUCT
 I - SANSERIAL
 I - SANDEVICE
 I - SANIS_DATAMOVER
 I - SANNODE_WWN
 I - SANPORT_WWN
 I - SANLUN
 I - SANSCSI_PORT
 I - SANSCSI_BUS
 I - SANSCSI_TARGET

 I - SERVERSVALIDATEPROTOCOL

 I - SESSIONS   MOUNT_POINT_WAIT
 I - SESSIONS   INPUT_MOUNT_WAIT
 I - SESSIONS   INPUT_VOL_WAIT
 I - SESSIONS   INPUT_VOL_ACCESS
 I - SESSIONS   OUTPUT_MOUNT_WAIT
 I - SESSIONS   OUTPUT_VOL_WAIT
 I - SESSIONS   OUTPUT_VOL_ACCESS
 D - SESSIONS   MEDIA_STATE

 I - STATUS SERVERFREE_STATUS
 I - STATUS SERVERFREE_BATCH

 I - STGPOOLS   COPYSTGPOOLS
 I - STGPOOLS   COPYCONTINUE
 I - STGPOOLS   CRCDATA

 I - SUMMARYCOMM_WAIT

Re: Server AIX vs NT

[Williams, Tim P {PBSG}]

You may find that AIX handles the IP stack better than NT...opinion..

-Original Message-
From: Ray Baughman [mailto:rbaughman@;NATIONALMACHINERY.COM]
Sent: Monday, November 11, 2002 10:46 AM
To: [EMAIL PROTECTED]
Subject: Server AIX vs NT


Hello,

We are looking to replace our TSM server hardware, we are currently running
the TSM server on an IBM H50.  The bean counters are saying that an NT
server would be a lot cheaper than a UNIX server.  They have decided it
needs to be either an IBM UNIX server or an NT server.  Has anyone had any
experience with both NT and AIX servers, and if so what information do you
have regarding performance, stability etc. with one over the other.
Basically I've be told to either cost justify AIX or I'll end up on NT.

Any help would be appreciated.

Ray Baughman
Engineering Systems Administrator
TSM Administrator
National Machinery LLC
Phone 419-443-2257
Fax 419-443-2376
Email [EMAIL PROTECTED]

Re: old DBBackup tapes not moving to vaultretrieve

[Williams, Tim P {PBSG}]

look at:


tsm: ADSM>q drmstatus

  Recovery Plan Prefix:
  Plan Instructions Prefix:
Replacement Volume Postfix: @
 Primary Storage Pools:
Copy Storage Pools:
   Not Mountable Location Name: NOTMOUNTABLE
  Courier Name: COURIER
   Vault Site Name: VAULT
  DB Backup Series Expiration Days: 4 Day(s)
Recovery Plan File Expiration Days: 60 Day(s)
  Check Label?: No
 Process FILE Device Type?: No
 Command File Name:


and

tsm: ADSM>help set drmdbbackupexpiredays
SET DRMDBBACKUPEXPIREDAYS



-Original Message-
From: Jacque Mergens [mailto:jmergens@;EMAGEON.COM]
Sent: Friday, November 08, 2002 9:11 AM
To: [EMAIL PROTECTED]
Subject: old DBBackup tapes not moving to vaultretrieve


I have been running a site for a couple of months and suddenly
my old database backup tapes stopped moving to vaultretrieve after a
full backup.

The only change that I have (knowingly) made was to allow incremental
backups
using the database trigger.

Can anyone tell me if/why this would cause this problem?

The site is running on AIX 5.1
TSM 4.2


Jacque

Re: UNLOADDB Operational Questions

[Williams, Tim P {PBSG}]

A good exercise would be to bkup your db, restore it to a test environment,
unload from your test
env., load from your test env.
hopefully you have a test system
take your time checkpoints...
a thought.


-Original Message-
From: Gianluca Mariani1 [mailto:gianluca_mariani@;IT.IBM.COM]
Sent: Tuesday, October 29, 2002 10:16 AM
To: [EMAIL PROTECTED]
Subject: Re: UNLOADDB Operational Questions


John,
I cannot relieve your pains a lot. you are right basically. I can only say
that, as a rule of thumb, we generally consider the audit db to go through
1GB per hour. but this is really a rule of thumb and I suppose lots of
people will jump to my neck for giving this figure. it really depends. the
only thing I'd like to stress is that audit db should not be used as a
housekeeping tool. it is meant to be performed only when IBM asks for it. I
say this because I remember various posts proposing this non correct usage.
to reorg the db, you only have the unload/load procedure. and that too,
should not be approached lightly. do it with IBM support if possible. I
know this sounds patronizing but you would not believe the number of
problems that could have been avoided if support had been involved in such
operations from the start.
that said, I understand your frustration. we are not unaware of the
problem.
ciao.

Cordiali saluti
Gianluca Mariani
Tivoli TSM Global Response Team, Roma
Via Sciangai 53, Roma
 phones : +39(0)659664598
   +393351270554 (mobile)
[EMAIL PROTECTED]



"The people of Krikkit,are, well, you know, they're just a bunch of real
sweet guys, you know, who just happen to want to kill everybody. Hell, I
feel the same way some mornings..."



 John Bremer
 <[EMAIL PROTECTED]
 OV>To
 Sent by: "ADSM: [EMAIL PROTECTED]
 Dist Stor  cc
 Manager"
 <[EMAIL PROTECTED]   bcc
 ST.EDU>
   Subject
 Re: UNLOADDB Operational Questions
 29/10/2002
 16:43


 Please respond
 to "ADSM: Dist
  Stor Manager"






I*SMers,

Well, I didn't see many responses to Paul's question about unload - reload
database reorganization, and most disconcerting, nothing from the gurus in
Tucson.

I looked back in the archives, and there are a lot of exchanges regarding
this issue, but my conclusion is, no one really knows how long this will
take for large databases (>100GB).  Evidently a database audit is not
necessary if no errors are encountered, and the unload - reload really does
improve performance and reduce database size.

Given this, why doesn't IBM Tivoli / ADSM provide us with better ways to
reorg our databases?  In our situation, we can't possibly risk a reorg,
considering the downtime could run into days or weeks.

One response I saw in the archives told us that a 46GB database was reduced
to 26GB and select statements "that would never finish before" now run in
seconds to minutes.  However, the time involved was 16 hours unload, 7
hours reload, and if an audit had been necessary, another 92 hours
there.  Why such a heavy price for something that would help us all?

This is a sad state of affairs (my opinion).

John Bremer

Re: Account log file

[Williams, Tim P {PBSG}]

alphabetic and numeric...(alphabetic for if u put it in a spreadsheet...and
numeric for a count of columns):
From:   Tim Williams on 08/01/2001 08:25 AM
To: Rais Din/Frito-Lay/US@Frito-Lay
c

[pbsxsz4][/flapps/adsm/adsmlogs]>tail -5 dsmaccnt.log
4,0,ADSM,06/13/2001,09:45:59,PBSXDR2,oracle,AIX,1,Tcp/Ip,1,1,4449,0,0,0,
0,0,0,4455,4,1,2,0,4,0,0,0,0,1,2
4,0,ADSM,06/13/2001,09:48:13,US504WX5,,WinNT,1,Tcp/Ip,1,0,0,0,0,62,10873,0,0
,10895,552,543,7,0,4,0,0,0,0,1,2
4,0,ADSM,06/13/2001,09:48:13,US504WX5,,WinNT,1,Tcp/Ip,1,0,0,0,0,0,0,0,0,1862
,666,660,0,0,5,0,0,0,0,1,2
4,0,ADSM,06/13/2001,09:48:46,PBSXAP1,oracle,AIX,1,Tcp/Ip,1,1,41780,0,0,0
,0,0,0,41787,25,6,19,0,4,0,0,0,0,1,2
4,0,ADSM,06/13/2001,09:49:13,PBSXAP1,oracle,AIX,1,Tcp/Ip,1,1,41947,0,0,0
,0,0,0,41954,25,5,20,0,4,0,0,0,0,1,2

  Contents
a 1   Product version (should be numeric  and
one position)
 b 2 Product sublevel(should be numeric and one
position)
 c 3 Product name, 'ADSM',(should be alpha and 4 positions)
 d 4 Date of accounting (mm/dd/) (obvious)
 e 5 Time of accounting (hh:mm:ss)  (obvious)
 f 6   Node name of TSM client   (combination of
alpha and numbers..current longest is 15 I believe - make 20?)
 g7  Client owner name (UNIX)(more than
likely alpha only, but could have numbers - make 15?)
examples:  oracle, bobjprod, ldapdb2, dbsacprd, weblogic, vblbatch
 h8  Client Platform
(examples: TDP Oracle AIX, TDP MSExchg NT,  AIX, WinNT - longest 14, make
20?)
 i9  Authentication method used
...1 or 0 single
digit
j 10  Communication method used for the sessionshould be
alphabetic...let's make it a length of 10
examples:HTTPIPXSPXNETBIOS NONESHAREDMEM SNALU6.2
SNMPTCPIP
k 11  Normal server termination indicator (Normal=X'01',
Abnormal=X'00') ..1 or 0   single digit
l 12  Number of archive database objects inserted during the
session (highest value in last 2 (9 days) sessions has been
10,777,650 let's make 12)
m 13  Amount of archived files, in kilobytes, sent by the client
to the server  <<< make 12 digits)
 n14   Number of archived database objects retrieved during the
session ..let's make 12
 o15  Amount of space, in kilobytes, retrieved by archived
objects  <<< make 12 digits)
 p16  Number of backup database objects inserted during the
session(highest value in last 2 (9 days) sessions has been 107929,
let's make 12)
 q17  Amount of backup files, in kilobytes, sent by the client
to the server  <<< make 12 digits)
 r18  Number of backup database objects retrieved during the
session make 12 digits.
s 19  Amount of space, in kilobytes, retrieved by backed up
objects <<< make 12 digits)
t 20  Amount of data, in kilobytes, communicated between the
client node and the server during the
  session(highest value in last
2 (9 days) sessions has been 111,381,275  let's make 12 digits)
 u 21  Duration of the session, in seconds
(highest value in last 2 (9 days) sessions has been 62052) let's make 6
digits)
 v 22  Amount of idle wait time during the session, in seconds
(highest value in last 2 (9 days) sessions has been 62048) let's make 6
digits)
 w 23  Amount of communications wait time during the session, in
seconds  (highest value in last 2 (9 days) sessions has been 52792)
let's make 6 digits)
 x 24  Amount of media wait time during the session, in seconds
(highest value in last 2 (9 days) sessions has been 10301. let's make 6
digits)
 y 25  Client session type. A value of 1 or 4 indicates a
general client session. A value of 5 indicates a(single numeric digit)
  client session that is running a schedule.
 z 26   Number of space-managed database objects inserted during
the session ..not in use.not needed..
 aa 27  Amount of space-managed data, in kilobytes, sent by the
client to the server ..not in use.not needed..
 ab 28  Number of space-managed database objects retrieved
during the session ..not in use.not needed..
ac 29   Amount of space, in kilobytes, retrieved by
space-managed objects ..not in use.not needed..
ad 30   Product release

..single digit...
ae 31   Product level
..single digit...

Re: SQL - punting for help

[Williams, Tim P {PBSG}]

Thank you too!
some perspective...if you are wanting to know what has been deleted from a
node (hence inactive)...
vs active...
and the expiredays (I believe).(delete last instances/versions/copies after
x days have past)..hasn't completed...this will help you understand what you
can attempt
to restore

-Original Message-
From: Andrew Raibeck [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 6:23 PM
To: [EMAIL PROTECTED]
Subject: Re: SQL - punting for help


I just tried this, with some modifications (added the DISTINCT keyword
and the FILESPACE_NAME column):

select distinct b.filespace_name, b.hl_name, b.ll_name from backups b
   where b.node_name='MYNODE' and b.state=inactive_version and
   (b.filespace_name || b.hl_name || b.ll_name) not in
   (select a.filespace_name || a.hl_name || a.ll_name from backups a
   where a.node_name='MYNODE' and a.state=active_version)

It worked for me. But I used a very small test case, so maybe my test
was not entirely comprehensive. This was run on a 5.1.0.0 TSM server.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




"Seay, Paul" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
09/20/2002 14:19
Please respond to "ADSM: Dist Stor Manager"


To: [EMAIL PROTECTED]
cc:
Subject:Re: SQL - punting for help



It is probably not going to happen with the current database performance,
but this would normally accomplish the task:

select b.hl_name, b.ll_name from backups b where b.node_name='your node'
and
b.state=inactive_version and (b.hl_name || b.ll_name) not in (select
a.hl_name || a.ll_name from backups a where a.node_name='your node' and
a.state=active_version)

I tried it on a single node and it did not find what I was looking for.  I
am going to turn in a problem record on it because it should work.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-
From: Williams, Tim P {PBSG} [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 1:59 PM
To: [EMAIL PROTECTED]
Subject: SQL - punting for help


Ok. This one is teasing me...puzzeling...
trying to get, from the backups table files that ONLY are inactive (if the
file has an active copy, I don't want to have this in the output). have
tried...myself... anyone? have tried state<>state, but this doesn't
work
? Thanks tim

Re: SQL - punting for help

[Williams, Tim P {PBSG}]

Thanks!!! I'll give it a try!!


-Original Message-
From: Seay, Paul [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 4:20 PM
To: [EMAIL PROTECTED]
Subject: Re: SQL - punting for help


It is probably not going to happen with the current database performance,
but this would normally accomplish the task:

select b.hl_name, b.ll_name from backups b where b.node_name='your node' and
b.state=inactive_version and (b.hl_name || b.ll_name) not in (select
a.hl_name || a.ll_name from backups a where a.node_name='your node' and
a.state=active_version)

I tried it on a single node and it did not find what I was looking for.  I
am going to turn in a problem record on it because it should work.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-----
From: Williams, Tim P {PBSG} [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 1:59 PM
To: [EMAIL PROTECTED]
Subject: SQL - punting for help


Ok. This one is teasing me...puzzeling...
trying to get, from the backups table files that ONLY are inactive (if the
file has an active copy, I don't want to have this in the output). have
tried...myself... anyone? have tried state<>state, but this doesn't work
? Thanks tim

SQL - punting for help

[Williams, Tim P {PBSG}]

Ok. This one is teasing me...puzzeling...
trying to get, from the backups table files that ONLY are inactive (if the
file has
an active copy, I don't want to have this in the output).
have tried...myself...
anyone?
have tried state<>state, but this doesn't work
?
Thanks tim

Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND

[Williams, Tim P {PBSG}]

accounting logs...when you have resourceutilization higher than 1...there's
multiple entries
in the dsmaccnt.log file...
I preferred to use a select statement and get totals out of the summary
table, but that's
screwed up now...
argh!

-Original Message-
From: Mr. Lindsay Morris [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 10:03 AM
To: [EMAIL PROTECTED]
Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND


For the record, Servergraph/TSM doesn't use the summary table, so problems
there won't make it give incorrect results.
It uses the accouting logs which have always been reliable.

-
Mr. Lindsay Morris
Lead Architect, Servergraph
859-253-8000 ofc
425-988-8478 fax


> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> Bill Boyer
> Sent: Friday, September 20, 2002 10:17 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND
>
>
> Yeah, but this used to work just fine. If we're assuming that the
> problem is
> that the multiple backup sessions (RESOURCEUTILIZATION) is causing the
> error, then why did it work after this came out in the V3.7? It
> only "broke"
> sometime in the late 4.1/4.2 and 5.1 versions of the server. If it used to
> work, and now doesn't,...why is it so hard to "fix" it?? So many of us
> developed scripts/code and in the case of Lindsay Morris, commercial
> software (ServerGraph/TSM), that is not working, giving incorrect results,
> and making us look bad in the eye of our management.
>
> Bill
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> Joel Fuhrman
> Sent: Friday, September 20, 2002 5:13 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND
>
>
> To me is seems as though the worker sessions should be informing
> the control
> session as to the amount of work they have done.  Each time the worker
> reports in, the control session would send a heart beat to the server thus
> avoiding this annoying timeout.
>
> On Wed, 18 Sep 2002, Seay, Paul wrote:
>
> > The problem is the summary table is broken right now.  I just
> got off the
> > phone with Level 2.  We think we have identified the cause of
> the problem.
> > As it turns out the SUMMARY table records are written by the "control"
> > session, not the actual backup sessions.  What is happening is
> the control
> > sessions are timing out and a new control session is being
> formed to send
> > the statistics information.  If you look at the start and end timestamps
> > with the following select and then look at the activity log you will see
> > what I am talking about.  This select lists all sessions that
> have a byte
> > count of zero.  You will notice the start and end timestamps are usually
> the
> > same or only a few seconds apart.  The reason is the wrong numbers are
> being
> > recorded.
> >
> > select entity, number, start_time, end_time from summary where
> bytes=0 and
> > start_time >current_timestamp-5 days and activity = 'BACKUP'
> order by 1,3
> >
> > The issue is I can envision this is going to be very difficult to fix in
> the
> > current design.
> >
> > It will be interesting.
> >
> >
> >
> > Paul D. Seay, Jr.
> > Technical Specialist
> > Naptheon Inc.
> > 757-688-8180
> >
> >
> > -Original Message-
> > From: Mark Bertrand [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, September 18, 2002 2:39 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Backup reporting
> >
> >
> > Paul and all,
> >
> > When I attempt to use any of the following select statements my
> "Total MB"
> > returned is always 0. I get my list of nodes but there is never any
> numbers
> > for size.
> >
> > Since this is my first attempt at select statements, I am sure I doing
> > something wrong. I have tried from command line and through macro's.
> >
> > I am trying this on a W2K TSM v4.2.2 server.
> >
> > Thanks,
> > Mark B.
> >
> > -Original Message-
> > From: Seay, Paul [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, September 16, 2002 11:43 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Backup reporting
> >
> >
> > See if these will help:
> >
> > /* SQL Script:   */
> > /*   */
> > /* backup_volume_last_24hours.sql*/
> > /* Date   Description*/
> > /* 2002-06-10 PDS Created*/
> >
> > /* Create Report of total MBs per each session */
> >
> > select entity as "Node Name  ", cast(bytes/1024/1024 as
> decimal(10,3))
> > as "Total MB  ",  cast(substr(cast(end_time-start_time as char(17)),3,8)
> as
> > char(8)) as "Elapsed  ", substr(cast(start_time as  char(26)),1,19) as
> > "Date/Time  ", case when cast((end_time-start_time)
> seconds as
> > decimal) >0 the

Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND

[Williams, Tim P {PBSG}]

The fix for this is at these levels (per apar doc):
 Apply patch 4.2.2.5, 5.1.1.1 or higher, available through
  Tivoli Web Page to resolve this problem, or fixing
  PTF when available.


Here's a blerb from my etr/pmr (problem ticket):
The APAR you are referring to is IC34462.  This issue is specific to
the summary table not being updated when client sessions are severed and
the session has to be re-established.  This APAR is currently open, but
I have added you to the interested parties list for this APAR.  There
was also another APAR (IC33455) which addressed an issue with the
summary table simply not being updated properly during client backups.


Here's the actual 2 apars...the doc on the problem/issue:
FYI Thanks Tim


 APAR Identifier .. IC34462   Last Changed..02/09/19
  BYTES FIELD IN SUMMARY TABLE SHOWS VALUE 0 IF THE BACKUP SESSION
  IS LOST AND THEN REOPENED AGAIN (I.E. MSG ANS1809E)

  Symptom .. IN INCORROUT Status ... OPEN
  Severity ... 2  Date Closed .
  Component .. 5698ISMSV  Duplicate of 
  Reported Release . 51A  Fixed Release 
  Component Name TSM SERVER 510   Special Notice
  Current Target Date ..  Flags
  SCP ... AIXRSC
  Platform  AIX

  Status Detail: Not Available

  PE PTF List:

  PTF List:


  Parent APAR:
  Child APAR list:


  ERROR DESCRIPTION:
  When a backup session is lost and then reopened again
  successfully (e.g. MSG ANS1809E can be seen in the
  dsmsched.log), not all values in the SUMMARY TABLE of the TSM
  server will show the correct backup statistics. The BYTES field
  shows in that case a value of 0, while e.g the fields EXAMINED
  and AFFECTED show correct values.
  .
  Example:
  
  1.) select * from summary where activity='BACKUP':
 START_TIME: 2002-08-28 19:32:06.00
   END_TIME: 2002-08-28 19:54:17.00
   ACTIVITY: BACKUP
 NUMBER: 366
 ENTITY: LWLSAP2
   COMMMETH: Tcp/Ip
ADDRESS: 172.20.13.42:33133
  SCHEDULE_NAME: MO-FR-1800
   EXAMINED: 71137
   AFFECTED: 251
 FAILED: 0
  BYTES: 0  <= |
   IDLE: 0
 MEDIAW: 0
  PROCESSES: 1
 SUCCESSFUL: YES
VOLUME_NAME:
 DRIVE_NAME:
   LIBRARY_NAME:
   LAST_USE:
  .
  2.) dsmsched.log:
  08/28/02   18:01:25 Scheduler has been started by Dsmcad.
  08/28/02   18:01:25 Querying server for next scheduled event.
  08/28/02   18:01:25 Node Name: LWLSAP2
  ...
  08/28/02   18:59:19 ANS1898I * Processed66,000 files
  *
  08/28/02   19:31:50 Normal File--> 2,048,008,192
  /oracle/09p2/daten6/TBS_APOLLO4_IMG_TBS_2.ora  Sent
  08/28/02   19:31:50 ANS1809E Session is lost; initializing
  session reopen procedure.
  08/28/02   19:32:06 ... successful
  08/28/02   19:32:09 ANS1898I * Processed66,500 files
  *
  ...
  08/28/02   19:54:16 Total number of objects inspected:   71,137
  08/28/02   19:54:16 Total number of objects backed up:  251
  08/28/02   19:54:16 Total number of objects updated:  0
  08/28/02   19:54:16 Total number of objects rebound:  0
  08/28/02   19:54:16 Total number of objects deleted:  0
  08/28/02   19:54:16 Total number of objects expired: 63
  08/28/02   19:54:16 Total number of objects failed:   0
  08/28/02   19:54:16 Total number of bytes transferred:  6.46 GB


  08/28/02   19:54:16 Data transfer time:  1,868.07 sec
  08/28/02   19:54:16 Network data transfer rate:  3,629.75 KB/sec
  08/28/02   19:54:16 Aggregate data transfer rate:1,001.56 KB/sec
  08/28/02   19:54:16 Objects compressed by:   19%
  08/28/02   19:54:16 Elapsed processing time:   01:52:50
  
  It seems that when a session is lost and then reopened again,
  the new session descriptor does not hold the value for the bytes
  transfered so far anymore.
  .
  This problem was seen on a TSM AIX and NT 5.1.1.4 server, but
  maybe all TSM server levels will be affected which inlcude the
  fix for APAR IC33455.
  .
  Recreation:
  Unplug the network cable during a backup session => session lost
  Plug the network cable in again => backup session restarts
  Then check the SUMMARY TABLE for the BYTES field


  LOCAL FIX:
  Do not believe the values reported in the SUMMARY TABLE. Check
  the DSMSCHED.LOG or the ACTLOG for the correct backup
  statistics.



APAR Identifier .. IC33455   Last Changed..02/07/19
  SUMMARY TABLE NOT BEING FULLY UPDATED


  Symptom .. IN INCORROUT Status ... CLOSED  PER
  Severity ... 2  Date Closed . 02/06/07
  Component .. 5698TSMAX  Duplicate of 
  Reported Release . 420  Fixed Release  999
  Component Name TSM AIX SERVER   Special Notice
  Current Target Date ..  Flags
 

Re: tapes getting marked PRIVATE

[Williams, Tim P {PBSG}]

is the db backup from the dbbackuptrigger (based on log filling?)?  check
device class
is this db backup from a command (check device class in use...

-Original Message-
From: Theresa Whitney [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 8:45 AM
To: [EMAIL PROTECTED]
Subject: tapes getting marked PRIVATE


It looks to me that each time I run a db backup TSM will attempt to grab
a tape, think it finds an I/O error on the label read, then marks the
tape PRIVATE and then moves on to the next tape.  That wouldn't be such
a problem except that it will do this to almost every tape in my
library.

I have had the drive hardware checked in the library and had both
drives replaced.  Did not have the picker checked.

This problem does not seem to be happening during a regular data backup
- only during the DB backup.

Anyone seen this before or have any ideas.?

Theresa Whitney
Technical Systems Admin
Northside ISD
ph: (210) 706-8837
fax: (210) 706-8877
email:  [EMAIL PROTECTED]

Re: 4.2.x selects from DRIVE table

[Williams, Tim P {PBSG}]

I sent all the apar on thisdid no one get it?
I was the originator of this aparmonths ago...
?
tw

-Original Message-
From: Seay, Paul [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 7:21 PM
To: [EMAIL PROTECTED]
Subject: Re: 4.2.x selects from DRIVE table


Yes, I have seen this, but I forgot to open a PMR on it.  I guess I need to.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-
From: David Stabler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 9:26 AM
To: [EMAIL PROTECTED]
Subject: Re: 4.2.x selects from DRIVE table


gotta be a bugit's broke in my 4.2.X AIX server, too, but...

select device,device_type from drives

works, and

select device,element from drives

has device blank.  WEIRD.

-drs-

>>> [EMAIL PROTECTED] 09/19/02 09:13AM >>>
Something odd I noticed this morning about 4.2.x servers on AIX and Solaris
-

"query drive f=d"
and
"select * from drives"

Displays values in the Device field, whereas a

"select device from drives"

displays a blank device field.

This holds for 4.2.1.15 on Solaris and 4.2.2.{patch of the day} on AIX.

I went back to an older server (3.x) on AIX, and a "select device from
drives"  shows the devices, as I expected.

Anyone else able to reproduce this?  Is this WAD or a new 'feature'?

Re: TSM Scheduler on WinNT and Win2K

[Williams, Tim P {PBSG}]

I too am experiencing this problem. I have not opened it up as an issue,
yet.
I was the "apar owner" of the issue with device...from the drive
tableand
offered that up to this listserv...
FYI Thanks Tim

-Original Message-
From: Martinez, Matt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 3:07 PM
To: [EMAIL PROTECTED]
Subject: Re: TSM Scheduler on WinNT and Win2K


I am using 5.11. I am using the recovery options for Win2k also. But that
doesn't help me with NT4.0 Clients.

Thanks,
Matt

 -Original Message-
From:   Rushforth, Tim [mailto:[EMAIL PROTECTED]]
Sent:   Thursday, September 19, 2002 3:38 PM
To: [EMAIL PROTECTED]
Subject:Re: TSM Scheduler on WinNT and Win2K

Are you running 5.11 client?

Some people (including me) are having this problem.

I have PMR # 40368 open with Tivoli on this.

A workaround I use on Windows 2000 is to set the Recovery Options on the
service to restart after 2 minutes on failure.

Tim Rushforth
City of Winnipeg

-Original Message-
From: Martinez, Matt [mailto:[EMAIL PROTECTED]]
Sent: September 19, 2002 2:13 PM
To: [EMAIL PROTECTED]
Subject: TSM Scheduler on WinNT and Win2K

Hi all,

The TSM Scheduler Service on most of my Win2k and NT4.0 boxes will
not start up after a reboot. When I go in and start the service manually it
starts up fine. I can't seem to find any errors in the Event Log. Any help
you can provide will be appreciated.

Thanks,
Matt

Re: Problem deleting filespace SYSTEM OBJECT

[Williams, Tim P {PBSG}]

 but did it FIX the problem?

-Original Message-
From: Burton, Robert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 2:32 PM
To: [EMAIL PROTECTED]
Subject: Re: Problem deleting filespace SYSTEM OBJECT


we are having the same problemand the auditdb for a 37 GB database took
over 26 HRs...

thanks
Robert Burton 
Enterprise Storage Network Analyst 
Royal Bank of Canada 
315 Front St West 
Toronto, On, M5V 3A4 
* 416-348-3849 
* [EMAIL PROTECTED]  


-Original Message-
From: Gerhard Rentschler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 11:42 AM
To: [EMAIL PROTECTED]
Subject: Problem deleting filespace SYSTEM OBJECT


Hello,
I ran into the following problem with TSM 5.1.1.4 on AIX 4.3.3.
Using the command
del filespace rus_zsdsinz 'SYSTEM OBJECT'
I get the following messages in the activity log:
09/18/02 16:20:33 ANR0984I Process 452 for DELETE FILESPACE started in
the
   BACKGROUND at 16:20:33.
09/18/02 16:20:33 ANR0800I DELETE FILESPACE * (fsId=4) for node
RUS_ZSDSINZ
   started as process 452.
09/18/02 16:20:33 ANR0802I DELETE FILESPACE * (fsId=4) (backup/archive
data)
   for node RUS_ZSDSINZ started.
09/18/02 16:20:34 ANRD imfsdel.c(1860): ThreadId<84> Error 1123
deleting
   group leader 0 585684848.
09/18/02 16:20:34 ANR0985I Process 452 for DELETE FILESPACE running in
the
   BACKGROUND completed with completion state FAILURE at
   16:20:34.
I opened a PMR. Level 1 suggested to run the command "cleanup backupgroup"
and retry the delete filespace command. It didn't help. The next advice was
to upgrade to TSM 5.1.1.6 and retry the cleanup backupgroup and del
filespace. The next thing to do would be a dsmserv auditdb. However, this
would take a lot of time with my 55 GB database.

Has anyone else seen this? Level 1 told me that he found only one similar
problem.
Best regards
Gerhard
---
Gerhard Rentschleremail:[EMAIL PROTECTED]
Regional Computing Center tel.   ++49/711/685 5806
University of Stuttgart   fax:   ++49/711/682357
Allmandring 30a
D 70550
Stuttgart
Germany


--
This e-mail may be privileged and/or confidential, and the sender does not
waive any related rights and obligations. Any distribution, use or copying
of this e-mail or the information it contains by other than an intended
recipient is unauthorized. If you received this e-mail in error, please
advise me (by return e-mail or otherwise) immediately. 

Ce courriel est confidentiel et protégé. L'expéditeur ne renonce pas aux
droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou
copie de ce message ou des renseignements qu'il contient par une personne
autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez
ce courriel par erreur, veuillez m'en aviser immédiatement, par retour de
courriel ou par un autre moyen. 



==

Re: 4.2.x selects from DRIVE table

[Williams, Tim P {PBSG}]

known problem


Item IC33890

  APAR Identifier .. IC33890   Last Changed..02/07/04
  OUTPUT FROM SELECT COMMAND FOR THE DRIVES TABLE WILL NOT RETURN
  A DEVICE VALUE IF THE DEVICE_TYPE IS NOT SPECIFIED/REQUESTED.

  Symptom .. IN INCORROUT Status ... CLOSED  UR1
  Severity ... 4  Date Closed . 02/07/04
  Component .. 5698TSMAX  Duplicate of 
  Reported Release . 420  Fixed Release  999
  Component Name TSM AIX SERVER   Special Notice
  Current Target Date ..  Flags
  SCP ... AIXRSC
  Platform  AIX

  Status Detail: Not Available

  PE PTF List:

  PTF List:
  Release 420   : PTF not available yet


  Parent APAR:
  Child APAR list:


  ERROR DESCRIPTION:
  The output from a select statement against the TSM drives table
  in TSM 4.2 does not return a value in the device column unless
  the device_type is specified in the select command. If select
  * is used the device is returned. If select device_type, device
  is used then the device is returned. Or if device_type is part
  of the where predicate then the device is returned.
  With the code/function changes occuring in the code with the
  introdction of the path defintion the device is returned in
  the select statements from the paths table. In TSM 5.1 this will
  be the only table that the device will be in (it is no longer in
  the drive definition).


  LOCAL FIX:
  Us the paths table to find the device if a select statement
  is needed without specifying the device_type.


  PROBLEM SUMMARY:
  
  * USERS AFFECTED: All Solaris, HP, AIX and Windows 4.2 TSM *
  * users.   *
  
  * PROBLEM DESCRIPTION: DEVICE field does not contain data in   *
  *  the output of a SELECT from the DRIVES  *
  *  table unless the DEVICE_TYPE field is   *
  *  selected either by name or by the use   *
  *  of * to select all fields.  The *
  *  DEVICE_TYPE field does not need to be   *
  *  one of the displayed fields, but it *
  *  does need to be referenced in the   *
  *  SELECT statement for the DEVICE field   *
  *  to contain data.*
  
  * RECOMMENDATION:  *
  
  Make sure to include the DEVICE_TYPE field somewhere in the
  SELECT statment to get the DEVICE field included.  No code
  change is being made for this APAR as in the V5 server the
  DEVICE field is no longer part of the DRIVES table and is only
  available in the PATHS table, and there is a simple
  circumvention to obtain the data in the V4.2 server.


  PROBLEM CONCLUSION:


  TEMPORARY FIX:


  COMMENTS:


  MODULES/MACROS:   NONE


  SRLS:  NONE


  RTN CODES:


  CIRCUMVENTION:


  MESSAGE TO SUBMITTER:


For IBMLink customer support in the U.S, call 1-800-543-3912.

[ IBM Home | Shop | Contact | Search | Priv

-Original Message-
From: David Stabler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 8:26 AM
To: [EMAIL PROTECTED]
Subject: Re: 4.2.x selects from DRIVE table


gotta be a bugit's broke in my 4.2.X AIX server, too, but...

select device,device_type from drives

works, and

select device,element from drives

has device blank.  WEIRD.

-drs-

>>> [EMAIL PROTECTED] 09/19/02 09:13AM >>>
Something odd I noticed this morning about 4.2.x servers on AIX and
Solaris
-

"query drive f=d"
and
"select * from drives"

Displays values in the Device field, whereas a

"select device from drives"

displays a blank device field.

This holds for 4.2.1.15 on Solaris and 4.2.2.{patch of the day} on
AIX.

I went back to an older server (3.x) on AIX, and a "select device from
drives"  shows the devices, as I expected.

Anyone else able to reproduce this?  Is this WAD or a new 'feature'?

Re: finding old filespaces from unix clients...

[Williams, Tim P {PBSG}]

Good stuff...thanks!

-Original Message-
From: bbullock [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 03, 2002 1:31 PM
To: [EMAIL PROTECTED]
Subject: Re: finding old filespaces from unix clients...


As with most TSM commands, are a million ways to skin this cat. Here
is a sql query I use:

select node_name, Filespace_name, (current_timestamp-backup_end)days as
"days_since_backup" from filespaces where
cast((current_timestamp-backup_end) days as decimal) >=180 order by
"days_since_backup"

In my case, I only start to clean up the orphaned filesystems after
they have not had a backup in the last 180 day (thus the 180 in the
command). It gives me a listing of the node, the filespace and the number of
days since a backup on that filespace completed.

Thanks,
Ben


-Original Message-
From: Cook, Dwight E [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 03, 2002 10:48 AM
To: [EMAIL PROTECTED]
Subject: finding old filespaces from unix clients...


I've noticed that if an entire filesystem is removed from a unix TSM client,
the environment (as a whole) will keep that data until manually purged.
I think this is OK/FINE/WHAT I WANT because you never know why an entire
filesystem has gone away (might just be varied offline, etc...)

but I still see obsolete data hanging on out there from 1998, 1999-ish so
what I've done is

select node_name,filespace_name as "filespace_name ",cast(backup_start as
varchar(10)) as bkupst, cast(backup_end as varchar(10)) as bkupend from
adsm.filespaces where cast(backup_end as varchar(7))<>'2002-09' > old_FS_out


or use ~where cast(backup_end as varchar(4))<>'2002'

this gives me a list of filesystems that I might manually purge after
further investigation.

just thought I'd pass this along.

Dwight E. Cook
Software Application Engineer III
Science Applications International Corporation
509 S. Boston Ave.  Suite 220
Tulsa, Oklahoma 74103-4606
Office (918) 732-7109

Re: Tape a given file is on?

[Williams, Tim P {PBSG}]

a crude way is...for a single file...issue a restore to another filename and
watch
what tape mount gets called...you can also cancel the restore once the
mount is requested (q sess f=d...).
FYI

-Original Message-
From: Alexander Verkooijen [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 30, 2002 9:56 AM
To: [EMAIL PROTECTED]
Subject: Re: Tape a given file is on?


On 30-Aug-02 David E Ehresman wrote:

> Given a file that has been backed up by a node, how do I find out which
> tape the current copy of the file is on without doing a restore?

Ah, I would love to have SQL query that answered this question.
Obviously this information is in the database
somewhere otherwise TSM wouldn't know which
tape to mount when performing a restore.

But for some reason it isn't in the pseudo-tables the SQL
interface uses.

The CONTENTS table tells you which file is on
which tape but it doesn't tell whether the
file is the active version or not.

And the BACKUPS table holds information
about all the different versions of a file
but it doesn't tell you which tape it is on.

Very frustrating.

Regards,

Alexander
---
Alexander Verkooijen([EMAIL PROTECTED])
Senior Systems Programmer
SARA High Performance Computing

Re: backupset volumes

[Williams, Tim P {PBSG}]

generate backupset doesn't show any info on the q vol, because the tape
doesn't get put into any stgpool.
SO, with that DRM is useless, I believe.
Note files and dirs onlyquestion registry (NT).
I had to watch the mounts to figure out what node was on what tapes
even the backupset table doesn't look like it will help

tsm: ADSM>select * from backupsets

 NODE_NAME: CHINTBI1
BACKUPSET_NAME: PREFX.341006383
 OBJECT_ID: 341006383
 DATE_TIME: 2002-08-27 15:51:53.00
 RETENTION: 2
   DESCRIPTION: timtst
  DEVCLASS: 3580_DEVCLASS

 NODE_NAME: US531W3Z
BACKUPSET_NAME: TESTING.341006640
 OBJECT_ID: 341006640
 DATE_TIME: 2002-08-27 17:47:57.00
 RETENTION: 2
   DESCRIPTION: tedtest
  DEVCLASS: 3580_DEVCLASS

 NODE_NAME: US531WT7
BACKUPSET_NAME: PREFX.341477968
 OBJECT_ID: 341477968
 DATE_TIME: 2002-08-28 14:59:15.00
 RETENTION: 30
   DESCRIPTION: timtst
  DEVCLASS: 3580_DEVCLASS

answer to 1=?
2=?

-Original Message-
From: Jin Bae Chi [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 12:47 PM
To: [EMAIL PROTECTED]
Subject: backupset volumes


Hi, TSMers,

We are running TSM 4.2 on AIX4.3.3 and I have 2 questions that couldn't
find answers from books.

1.  Now that I started to generate backupsets for several nodes, but I
couldn't tell which volumes belong to which node when 'q libvol'. The
server shows only 'backupset' and when 'q vol  f=d', it doesn't
give any info about vol of backupset. I plan to take them to off-site,
but when it expires (30 days), how I do know which need to come back to
on-site? Any recommendation for managing volumes of backupsets?


2.  Does TSM supports to generate backupset or client image backup on
DVD-ROM? My clients wouldn't fit on 1 or 2 regular CD-ROM.

Thanks for your expertise!!




Jin Bae Chi (Gus)
Data Center
614-287-2496
614-287-5488 Fax
e-mail: [EMAIL PROTECTED]

Re: tsm client is down-level with this server version

[Williams, Tim P {PBSG}]

You can't find ANY os/2 code?
os/2 isn't supported any longer. We still have it here too.
I do have the install executable...for v3.7.2.0 for os/2 if u need it.

-Original Message-
From: Oscar Kolsteren [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 3:17 AM
To: [EMAIL PROTECTED]
Subject: tsm client is down-level with this server version


Hi All,

Situation :

NT and OS/2 environment with TSM client 3.7.* and we have a AIX server
running
with 4.2.1.7.

Recently we installed some new servers with clientsversion 4.2. At the same
time
some administrators upgraded there local TSM version to 4.2.

If they want some info from a server running 3.7 and contact this server
from
their local installation the server won't backup anymore because we get the
message " tsm client is down-level with this server version".

When we upgrade the TSM client on this server everything is solved.

This is a known problem and has to do with unicode and non-unicode.

But now my problem :

There is no upgrade available for OS/2 and I can't backup this machine
anymore.
Does someone has a solution for this problem ???
(Remove the client and start all over is no option...)

Thanx,

Oscar Kolsteren
Postbank NV
Netherlands


-
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.

Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-

Re: lto specialist

[Williams, Tim P {PBSG}]

Yepbut try...to disable ethernet and re-enable ethernet...
this should get you arount the reboot
The above hasn't worked only once, I believe, then we
resorted to a reboot.

to the IBM bcc'dother accounts having the same problem(s).
FYI!!

Thanks Tim

-Original Message-
From: Davidson, Becky [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 21, 2002 9:39 AM
To: [EMAIL PROTECTED]
Subject: lto specialist


Has anyone else experienced the need to on an almost weekly basis reboot
their IBM 3584 so that you can get access to the LTO Specialist again?

Everything else seems to work fine I just can't get into the gui.  I am
running at library code level 2460.

Any thoughts or wisdom would be greatly appreciated.

Becky Davidson
Data Manager
EDS/Sara Lee Bakery Group
voice: 314-259-7589
fax: 314-877-8589
email: [EMAIL PROTECTED]

Re: More on mount points

[Williams, Tim P {PBSG}]

I had some issues with mount points not being available.
I also have my mount limit set to drives.
I ended up recycling my tsm server process and this
cleared the situation...
FYI

-Original Message-
From: David Longo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 8:31 AM
To: [EMAIL PROTECTED]
Subject: Re: More on mount points


For each device class there is a "Mount limit", generally this
is set to DRIVES, which allows that devclass to use as many drives
as you have.  Maybe yours is set to a specific number.  Each tape
pool you have, then uses a devclass and therefore is limited to
using no more than that many drives.

David Longo

>>> [EMAIL PROTECTED] 08/15/02 09:05AM >>>
Can anyone give me any help on the mountpoint problem I posted earlier?

>>I turned on collocation last week and now I am getting this message:
>>
>>ANR1082W Space reclamation terminated for volume 4A0023 - insufficient
number of mount points >>available for removable media.
>>
>>I looked up the error message and it tells me:User Response: If necessary,
make more mount points available
>>
>>Is this the same as mount limit for the server?  I see that you can
specify number of mount points for a
>>node.  But how can you specify this for a tape?

David Mac



"MMS " made the following
 annotations on 08/15/2002 09:32:02 AM

--
This message is for the named person's use only.  It may contain
confidential, proprietary, or legally privileged information.  No
confidentiality or privilege is waived or lost by any mistransmission.  If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it, and notify the
sender.  You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient.  Health First reserves the right to monitor all e-mail
communications through its networks.  Any views or opinions expressed in
this message are solely those of the individual sender, except (1) where the
message states such views or opinions are on behalf of a particular entity;
and (2) the sender is authorized by the entity to give such views or
opinions.


==

"FW: sql and output redirection...how to..RE: Deactivate ALL admi n sch edules? (how-to)"

[Williams, Tim P {PBSG}]

retrying posting...
"
-Original Message-
From: Williams, Tim P {PBSG}
Sent: Thursday, August 15, 2002 1:37 PM
To: 'ADSM: Dist Stor Manager'
Subject: sql and output redirection...how to..RE: Deactivate ALL admin
sch edules? (how-to)


set sqldisplaymode wide
tsm: ADSM>select 'update schedule ' || trim(schedule_name) || ' type=a
active=no ' from admin_schedules

Unnamed[1]

update schedule AM_BACKUP_DB_FULL type=a active=no
update schedule AUDIT_LICENSES type=a active=no
update schedule BACKUP_DEVCONFIG_1 type=a active=no
update schedule BACKUP_DEVCONFIG_2 type=a active=no
update schedule BACKUP_DEVCONFIG_3 type=a active=no
update schedule BACKUP_DEVCONFIG_4 type=a active=no
update schedule BACKUP_VOLHIST_1 type=a active=no

and output redirect...then execute...

FYI Thanks Tim
"


-Original Message-
From: Taylor, David [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 11:09 AM
To: [EMAIL PROTECTED]
Subject: Deactivate ALL admin schedules? (how-to)


Hi all,

Is there anyway that I can globally set all of my admin schedules to
"ACTIVE=NO"?

I was looking for something like a standard SQL UPDATE-SET type statement,
but couldn't find anything.

I want to include this in a disaster recovery script (Korn).  The problem
that I've run into is that some of my schedule-names are longer than 16
characters (and therefor wrap).   I could probably write something (ugly and
bulky) that would work around this issue, but would prefer something
cleaner.

Additional info:

TSM server 4.2.1.15
AIX 4.3.3 ML6

TIA

David


**
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
the system manager.

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

www.mimesweeper.com
**

Re: syntax for using "like" in select statement?

[Williams, Tim P {PBSG}]

Here's a couple of examples:

select drive_name from drives where online not like 'YES'

select current date as tmpdt, count(*) volume_name, stgpool_name from
volumes -
group by stgpool_name having stgpool_name like '%TAPE%'



-Original Message-
From: Michelle DeVault [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 13, 2002 12:26 PM
To: [EMAIL PROTECTED]
Subject: syntax for using "like" in select statement?


I'm sure this has been answered before, I just can't
find it in the archived on adsm.org.

How can I use a "like" in a select statement?  I don't
know the value exactly, just know a portion of it.

ex.
select * from sometable where somecolumn like somevalue

__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com

Re: 3494 i?O error on 3590 drives

[Williams, Tim P {PBSG}]

I like the mtlib -l/dev/lmcp0 -A
shows adapters and connectivity...
If you are HA on your 3494...it will show you both sides, both adapters...
FYI

-Original Message-
From: Seay, Paul [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 3:47 AM
To: [EMAIL PROTECTED]
Subject: Re: 3494 i?O error on 3590 drives


Did you install the ibmatl code for a 3494 library?  If so, can you issue
this command:

mtlib -l 3494lib -qL

This will verify that you can talk to the library.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-
From: Koen Willems [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 6:45 PM
To: [EMAIL PROTECTED]
Subject: 3494 i?O error on 3590 drives


Dear Listers,

When I want to define a 3590 in 3494 library i get an I/O error.

define libr 3494lib type=349X device=3494lib

define drive 3494lib drive0 device=mt2.0.0.1

Server option enable3590libr yes.

My scsi adresses on the drives are oke.

RMS is disabled.

Termination is oke.

I can see my 3590 on my adaptec 2944 scsi bus.

I use tsm device drivers fot 3590.

I am runnin W2K TSM 4.2.2.

Does anybody ever connected an 3494 to NT or W2k ?

Thnx 4 your Time,

Koen Willems

_
Join the world s largest e-mail service with MSN Hotmail.
http://www.hotmail.com

Re: select statement using filespaces and tapes

[Williams, Tim P {PBSG}]

1st question...you have colocation on or off for the node/PD/storage of
interest?

-Original Message-
From: Marc Lowers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 11:00 AM
To: [EMAIL PROTECTED]
Subject: select statement using filespaces and tapes


I'm looking for a select statement which will provide me with a list of
tapes associated with a given node, filespace name and backup date.  I've
been looking into linking the backups table with another to provide the
result  but this has been unsuccessful so far.

Am I close or miles off with this method?


Marc.

Re: move drmedia

[Williams, Tim P {PBSG}]

Hi. Someone said that had found their answer.
try help  SET DRMCHECKLABEL
(Specify Label Checking)

-Original Message-
From: Burak Demircan [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 12:26 AM
To: [EMAIL PROTECTED]
Subject: move drmedia


Hi,
How can I prevent my 3583 library to check barcode labels when using "move
drmedia" command.
I could not find checklabel option in the command help.
Regards,
Burak

Re: Can't unload the DB

[Williams, Tim P {PBSG}]

doesn't this process only support manual tape drives/libraries...
I think the sm failing to initialize is an automatic tape library, is it?
we only have/had a 3494 library...and pull the drive out from the back...
define that drive as manual...load the tape by hand from the back side
of the library (again, manual)...
this works..
FYI

-Original Message-
From: Max Kwong [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 22, 2002 1:36 AM
To: [EMAIL PROTECTED]
Subject: Can't unload the DB


Hi all,

I need to optimize the TSM db so i unload the db but it failed. I've tried
to audit the db and then unload it again but it also can fix the problem.
Does anyone have a idea to solve this problem. The following is the error
statement of "dsmserv unloaddb devclass=dltclass4 vol=adsm02".



ANR4013I UNLOADDB: Dumped 0 database entries (cumulative).
ANR8337I DLT volume ADSM02 mounted in drive MT1.0.0.1 (MT1.0.0.1).
ANR1360I Output volume ADSM02 opened (sequence number 1).
ANR4400I UNLOADDB: Quiescing database update activity.
ANR4401I UNLOADDB: Database update activity is now quiesced.
ANR4029I UNLOADDB: Database checkpoint started.
ANR4030I UNLOADDB: Database checkpoint completed.
ANR4013I UNLOADDB: Dumped 8620 database entries (cumulative).
ANR4013I UNLOADDB: Dumped 268068 database entries (cumulative).
ANR4013I UNLOADDB: Dumped 311917 database entries (cumulative).
ANR4013I UNLOADDB: Dumped 714030 database entries (cumulative).
ANR4013I UNLOADDB: Dumped 757577 database entries (cumulative).
ANR4013I UNLOADDB: Dumped 1342882 database entries (cumulative).
ANR4013I UNLOADDB: Dumped 1408850 database entries (cumulative).
ANR4013I UNLOADDB: Dumped 2029139 database entries (cumulative).
ANR4013I UNLOADDB: Dumped 2066637 database entries (cumulative).
ANR4013I UNLOADDB: Dumped 2549219 database entries (cumulative).
ANR4013I UNLOADDB: Dumped 2592331 database entries (cumulative).
ANR4013I UNLOADDB: Dumped 3071551 database entries (cumulative).
ANR4013I UNLOADDB: Dumped 3115932 database entries (cumulative).
ANRD sminit.c(488): SM Failed to Initialize - Time Out.
ANRD mmsshr.c(307): Timed out waiting for session manager
initialization.
ANR1361I Output volume ADSM02 closed.
ANR8336I Verifying label of DLT volume ADSM02 in drive MT1.0.0.1
(MT1.0.0.1).

==

Best Regards,
Max Kwong

Re: UNLOADDB/LOADDB Performance Note

[Williams, Tim P {PBSG}]

Note your number difference on
Copied 1823964 database pages  (unload)
1823962 database records.  (load)
pages and records...I've already called support on this...
and I've seen pages and record numbers not match
you should call supportopinion.
FYI
Thanks Tim Williams
(972) 376-7774

-Original Message-
From: William White [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 4:39 AM
To: [EMAIL PROTECTED]
Subject: UNLOADDB/LOADDB Performance Note


Dear  TSM'ers,

I recently saw several postings regarding TSM performance for UNLOADDB and
LOADDB.
Last weekend I did it and here are the results.

Environment:   OS/390 V2.8;   IBM 9672-RC4;   STK 9840 tape

UNLOADDB:

Command: UNLOADDB DEVCLASS=RTAPE SCRATCH=YES CONSISTENT=YES

TSM server V4.1.2, recovery log 1488 MB, database 8376 MB (from ANR0200I
and ANR0201I messages)
Job issued ANR4013I messages at about 15 second intervals up to 82385957
database entries,
then no more messages for 2 hours and 16 min.
Finally:
Copied 1823964 database pages, 280 bit vectors, 0 bad database pages,
50668494 database entries,
4369 MB copied.
The job ran for 144.36 minutes on a lightly loaded system.

REFORMAT:

I had some difficulty with the documentation, because it referred to member
ASAMPLIB(ANRINST).
As far as I can see, the syntax of the parameter field is not documented
anywhere.  When I
used '/FORMAT n LOGNAME1 LOGNAME2 ... LOGNAMEn m DBNAME1 DBNAME2 ...
DBNAMEm' the LOADDB
failed with a message "database not initialized."  Then I tried
"/LOADFORMAT ..." with the
same operand syntax as /FORMAT and it worked.  With /LOADFORMAT you get a
message:

ANR1004I Server formatting complete, database ready for loading.

LOADDB:
The job ran for 619.02 minutes and produced these messages at the end:
ANR4032I LOADDB: Copied 1823962 database records.
ANR4033I LOADDB: Copied 273 bit vectors.
ANR4035I LOADDB: Encountered 0 bad database records.
ANR4036I LOADDB: Copied 50668494 database entries.
ANR4037I LOADDB: 4369 Megabytes   copied.
ANR4004I LOADDB: Database load process completed.
ANR4404I LOADDB: Loaded a consistent dump image - a database audit
(AUDITDB)
ANR4404I is NOT required.

There was one other problem:  A bit vector error prevented one of the DASD
storage pool
volumes from coming online.  The support center pointed me to APAR PQ49053.
I applied
PTF's for TSM V4.1.6 and followed the recovery instructions in the APAR
text.  One bit
vector was recreated and now the server is running normally.

The database went from over 90% to 63% utilized.

Expiration processing went from 7-8 hours to 3 hours and database backup
went from 2-3
hours to slightly more than one hour.

I was surprised that the LOADDB operation took four times as long as the
unload, but
that's what you get when you do something for the first time.

Regards,
www.


-
William White
Mainframe Services Group
International Computing Centre (ICC)
e-mail: [EMAIL PROTECTED]

Re: Missing Messages from ACTLOG for Drive Offlines

[Williams, Tim P {PBSG}]

I have seen this problem and have an apar open with Tivoli.
We can't TEC alert, if there's no specific message that a drive went
offline...
other than perhaps a anrd (we're not going to rightly tec alert on
THAT message):
IC34067
Item IC34067


  APAR Identifier .. IC34067   Last Changed..02/07/10
  TSM SERVER TAKES TAPE DRIVE OFFLINE (MAKES IT UNAVAILABLE) BUT
  NO MESSAGE IS OUTPUT INDICATING THIS ACTION HAS OCCURED.

  Symptom .. IN INCORROUT Status ... CLOSED  PER
  Severity ... 2  Date Closed . 02/07/10
  Component .. 5698TSMAX  Duplicate of 
  Reported Release . 420  Fixed Release  999
  Component Name TSM AIX SERVER   Special Notice
  Current Target Date ..  Flags
  SCP ... AIXRSC
  Platform  AIX

  Status Detail: Not Available

  PE PTF List:

  PTF List:
  Release 420   : PTF not available yet
  Release 410   : No PTF planned


  Parent APAR:
  Child APAR list: IC34101 IC34102 IC34103 IC34107


  ERROR DESCRIPTION:
  Customer is attempting to pass all critical messages to the TEC.
  One message of importance to them are those that indicate a tape
  drive had been taken offline (made unavailable). Customer has
  found certain circumstances under which no message appears to
  be issued when a drive is taken offline. For example the
  following shows activity log messages about a drive followed
  by query drive message that show it was taken offline during
  this time even though no message indicating this action was
  issue:
  TSM drive messages:
  06/24/02   14:22:27  ANR8469E Dismount of LTO volume 100309
  from drive EF2D1 (/dev/rmt18) in library LTOPLANO01 failed.

  06/24/02   14:22:27  ANRD mmsscsi.c(1723): ThreadId<66>
  may still be  in the drive EF2D1 (/dev/rmt18).
  Library Name: LTOPLANO01

  Query Drive f=d output at 17:00:08:
   Drive Name: EF2D1
   Device Type: LTO
   On-Line: Unavailable Since 06/24/02 14:22:27
   Device: /dev/rmt18
   Element: 269
   Allocated to:
   Last Update (administrator): TWILL1
   Last Update Date/Time: 06/18/02 12:55:56

  The TSM server needs to issue an ANR message each time it takes
  a drive offline.


  LOCAL FIX:


  PROBLEM SUMMARY:
  
  * USERS AFFECTED: Anyone affected by inconsistent messaging*
  * when drives are taken offline.   *
  
  * PROBLEM DESCRIPTION: Inconsistent messaging when a drive is  *
  *  taken offline.  *
  
  * RECOMMENDATION:  *
  
  We display a couple of different messages whenever a drive is
  taken offline.  Moreover, there was a couple of situations
  when no message was displayed at all and the drive was taken
  offline.


  PROBLEM CONCLUSION:
  Therefore, we added a message anywhere that the drive was
  taken offline to prompt the user of such action.


  TEMPORARY FIX:


  COMMENTS:


  MODULES/MACROS:   NONE


  SRLS:  NONE


  RTN CODES:


  CIRCUMVENTION:


  MESSAGE TO SUBMITTER:







-Original Message-
From: Seay, Paul [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 11:52 PM
To: [EMAIL PROTECTED]
Subject: Missing Messages from ACTLOG for Drive Offlines


NO, you probably have your messages setup so these do not come out.

Check your eventrules for ACTLOG

Do the following command:

Q EVENTRULES ACTLOG

Ours always works.  It even sends them to our TEC console because we have
the TIVOLI stuff turned on.  Works great.

Paul D. Seay, Jr.
Technical Specialist
Naptheon, INC
757-688-8180


-Original Message-
From: Zbyszek Borgosz [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 5:50 PM
To: [EMAIL PROTECTED]
Subject: Re: TSM 4.2, Private won't go into scratch


Guess what folks!
I've got 2 drives. One of them mysteriously went offline
I haven't noticed it for a week :)
q acctlog did not show it.
TSM lacks of proper event logging.

Thanks for your help!
Best Regards!
---
zee

Re: 3584 firmware

[Williams, Tim P {PBSG}]

?
support may not...supportan upgraded library firmware...w/o an upgraded
drive firmware...
fyi

-Original Message-
From: Peter Pijpelink - P.L.C.S. BV Storage Consultants
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 5:02 PM
To: [EMAIL PROTECTED]
Subject: Re: 3584 firmware


Read below before you speak :)

At 14:52 02-07-2002 -0500, Williams, Tim P {PBSG} wrote:
>You should be upgrading the 3584 firmware and upgrade to the 25d4 level at
>the same time!
>FYI
>
>-Original Message-
>From: Peter Pijpelink - P.L.C.S. BV Storage Consultants
>[mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, July 02, 2002 1:21 PM
>To: [EMAIL PROTECTED]
>Subject: Re: 3584 firmware
>
>
>I heared from the CE engineer. What has been fixed in 25D4 I do not know
>yet, I'll have a look and let you know.
>
>Peter
>
>At 14:40 02-07-2002 +0200, Loon, E.J. van - SPLXM wrote:
> >Hi Peter!
> >Where can one get this information? What has been fixed in the drive
> >microcode level 25D4?
> >Kindest regards,
> >Eric van Loon
> >KLM Royal Dutch Airlines
> >
> >
> >-Original Message-
> >From: Peter Pijpelink - P.L.C.S. BV Storage Consultants
> >[mailto:[EMAIL PROTECTED]]
> >Sent: Friday, June 28, 2002 18:31
> >To: [EMAIL PROTECTED]
> >Subject: Re: 3584 firmware
> >
> >
> >Eric, (hi)
> >
> >There is support for SNMP version 1 and 2 in code 2460 and some other
> >bugfixes in the internal webserver.
> >
> >But First! upgrade drives (25D4) and then the lib code.
> >
> >And reboot everything is my advise so far! I upgraded 3 3584 so far and
no
> >problems.
> >
> >Peter
> >
> >At 12:45 28-06-2002 +0200, Loon, E.J. van - SPLXM wrote:
> > >Hi *SM-ers!
> > >I found new drive and library microcode for the 3584 library at
> > >ftp://service.boulder.ibm.com/storage/358x/. I cannot find any
>information
> > >about this microcode. What has been fixed? Should I apply this code?
> > >Does anybody know where to find this information?
> > >Thanks in advance for any reply!
> > >Kindest regards,
> > >Eric van Loon
> > >KLM Royal Dutch Airlines
> > >
> > >
> > >**
> > >For information, services and offers, please visit our web site:
> > >http://www.klm.com. This e-mail and any attachment may contain
> > >confidential and privileged material intended for the addressee only.
If
> > >you are not the addressee, you are notified that no part of the e-mail
or
> > >any attachment may be disclosed, copied or distributed, and that any
>other
> > >action related to this e-mail or attachment is strictly prohibited, and
> > >may be unlawful. If you have received this e-mail by error, please
notify
> > >the sender immediately by return e-mail, and delete this message.
> > >Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or
its
> > >employees shall not be liable for the incorrect or incomplete
>transmission
> > >of this e-mail or any attachments, nor responsible for any delay in
> >receipt.
> > >**
> >
> >
> >**
> >For information, services and offers, please visit our web site:
> >http://www.klm.com. This e-mail and any attachment may contain
> >confidential and privileged material intended for the addressee only. If
> >you are not the addressee, you are notified that no part of the e-mail or
> >any attachment may be disclosed, copied or distributed, and that any
other
> >action related to this e-mail or attachment is strictly prohibited, and
> >may be unlawful. If you have received this e-mail by error, please notify
> >the sender immediately by return e-mail, and delete this message.
> >Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its
> >employees shall not be liable for the incorrect or incomplete
transmission
> >of this e-mail or any attachments, nor responsible for any delay in
>receipt.
> >**

Re: 3584 firmware

[Williams, Tim P {PBSG}]

You should be upgrading the 3584 firmware and upgrade to the 25d4 level at
the same time!
FYI

-Original Message-
From: Peter Pijpelink - P.L.C.S. BV Storage Consultants
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 1:21 PM
To: [EMAIL PROTECTED]
Subject: Re: 3584 firmware


I heared from the CE engineer. What has been fixed in 25D4 I do not know
yet, I'll have a look and let you know.

Peter

At 14:40 02-07-2002 +0200, Loon, E.J. van - SPLXM wrote:
>Hi Peter!
>Where can one get this information? What has been fixed in the drive
>microcode level 25D4?
>Kindest regards,
>Eric van Loon
>KLM Royal Dutch Airlines
>
>
>-Original Message-
>From: Peter Pijpelink - P.L.C.S. BV Storage Consultants
>[mailto:[EMAIL PROTECTED]]
>Sent: Friday, June 28, 2002 18:31
>To: [EMAIL PROTECTED]
>Subject: Re: 3584 firmware
>
>
>Eric, (hi)
>
>There is support for SNMP version 1 and 2 in code 2460 and some other
>bugfixes in the internal webserver.
>
>But First! upgrade drives (25D4) and then the lib code.
>
>And reboot everything is my advise so far! I upgraded 3 3584 so far and no
>problems.
>
>Peter
>
>At 12:45 28-06-2002 +0200, Loon, E.J. van - SPLXM wrote:
> >Hi *SM-ers!
> >I found new drive and library microcode for the 3584 library at
> >ftp://service.boulder.ibm.com/storage/358x/. I cannot find any
information
> >about this microcode. What has been fixed? Should I apply this code?
> >Does anybody know where to find this information?
> >Thanks in advance for any reply!
> >Kindest regards,
> >Eric van Loon
> >KLM Royal Dutch Airlines
> >
> >
> >**
> >For information, services and offers, please visit our web site:
> >http://www.klm.com. This e-mail and any attachment may contain
> >confidential and privileged material intended for the addressee only. If
> >you are not the addressee, you are notified that no part of the e-mail or
> >any attachment may be disclosed, copied or distributed, and that any
other
> >action related to this e-mail or attachment is strictly prohibited, and
> >may be unlawful. If you have received this e-mail by error, please notify
> >the sender immediately by return e-mail, and delete this message.
> >Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its
> >employees shall not be liable for the incorrect or incomplete
transmission
> >of this e-mail or any attachments, nor responsible for any delay in
>receipt.
> >**
>
>
>**
>For information, services and offers, please visit our web site:
>http://www.klm.com. This e-mail and any attachment may contain
>confidential and privileged material intended for the addressee only. If
>you are not the addressee, you are notified that no part of the e-mail or
>any attachment may be disclosed, copied or distributed, and that any other
>action related to this e-mail or attachment is strictly prohibited, and
>may be unlawful. If you have received this e-mail by error, please notify
>the sender immediately by return e-mail, and delete this message.
>Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its
>employees shall not be liable for the incorrect or incomplete transmission
>of this e-mail or any attachments, nor responsible for any delay in
receipt.
>**

Re: Experiences with (unsupported) OS/2 V3.2.7 clients

[Williams, Tim P {PBSG}]

Hi. We have about 30 os/2 servers (TSM clients), but we are AIX TSM 4.2.2.0.
I have seen no problem, and have none to report to support.
FYI

-Original Message-
From: Jan Vanbrabant [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 12:55 PM
To: [EMAIL PROTECTED]
Subject: Experiences with (unsupported) OS/2 V3.2.7 clients


Hi,

We are running unsupported on mainframe with TSM V3 = 5697-TSO S/390 MVS
edition.
With still OS/2 (remember :-) ???) clients in our shop (phasing out OS/2
being much more
than an overnight project ),
We run  V3.7.2 OS/2 clients.
.
TSM 4.1 for OS/390 will be out of support 30 September 2002.
TSM 4.2 will be out of support 15 April 2003.
So we go TSM S/390 V5.1 (obvously)...
.
But we get in trouble of course with the client support:
only TSM Client 5.1 and 4.2 are compatible with TSM Server 5.1
So from the OS/2 client perspective, we are/stay out-of-support anyway.
.
My questions to you, ADSM/TSM community:
Have you experiences with V3.7.2 OS/2 clients running with a TSM S/390 V4.2
or 5.1 server?
Have you been faced with problems?
Were you able to live with it? To overcome them?
If you got problems, did you open a PMR with IBM? How did the support
center and the C/T (change team) react?
Officially, they don't have to support you? But did they lock you out
really and did they leave you in the cold?

Anxious to know your experiences ...

Rgds.
Jan

Re: Licensing problems on TSM for Windows 5.1.1.0

[Williams, Tim P {PBSG}]

Did you fully path the file name(s)?


-Original Message-
From: Joerg Pohlmann/CanWest/IBM [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 11, 2002 1:55 PM
To: [EMAIL PROTECTED]
Subject: Licensing problems on TSM for Windows 5.1.1.0


I have just upgraded my TSM server to 5.1.1.0 and am unable to register
client licenses beyond 1 mgsyslan client or 1oracle client etc. I have not
been able to test this on other platforms. Sounds like a bug, even
reinstalled the licenses off the 5.1.0.0 CD and no success. Any help is
appreciated.

Joerg Pohlmann
604-535-0452

Re: LTO Cleaning Cartridge

[Williams, Tim P {PBSG}]

Its 50 cleaningsit can be found on the product description (web)...you
really have to look...
FYI

-Original Message-
From: Sascha Askani [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 03, 2002 3:15 AM
To: [EMAIL PROTECTED]
Subject: LTO Cleaning Cartridge


Hi *SM'er ;)

Just a question: How often can an LTO Cleaning Cartridge (IBM) be used. I
wonder why this is not mentioned on the product.


Thanks in advance

Sascha Askani

Re: TSM Tech support not responding as quickly!

[Williams, Tim P {PBSG}]

I have noticed some change, too. I don't know why.

-Original Message-
From: Sias Dealy [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 8:20 PM
To: [EMAIL PROTECTED]
Subject: TSM Tech support not responding as quickly!


I was wondering why TSM tech support was taking a long
time to respond.

Someone gave the following URL:
http://www.ibmemployee.com/

Sias

__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

Re: Automating Scheduling service in OS/2

[Williams, Tim P {PBSG}]

We have the following in a dir   d:\autoapp  (all the *.cmd files get run on
reboot) and in
tsmc.cmd  is the following
d:
cd d:\tsmdir
start /min /c "TSM Client - Scheduler" d:\tsmdir\dsmc schedule
-password=whatever

FYI
Tim Williams


-Original Message-
From: Paul Ward [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 7:47 PM
To: [EMAIL PROTECTED]
Subject: Automating Scheduling service in OS/2


Hey All,

I have a question relating to automating the scheduler on a os/2 client
running TSM 3.7.2 client.  What happens is upon boot up the os/2 machine
calls a script which runs the following command "dsmc schedule -password
=". The problem is that this command fails unless I have logged
in  with the dsm command. So what I do currently is when the machine boots
up I issue the dsm command, I then specify the password manually and
finally I run the dsmc command with the scheduler option. I been looking
through the manuals to find a command or some configuration settings to
solve this problem but I haven't been able to find anything yet. I am
fairly new to TSM and I would appreciate any help anyone could give.

Oh by the way the Server is a NT machine running TSM 4.2.1

thanks in advance

Paul

Re: Select Stmt? or Query

[Williams, Tim P {PBSG}]

How long does this take. For us, it takes forever (we have LOTS of logs in
24 hours...
Anyway we just do a q actlog begintime=now-24 (actlogscan.mac), then I use
awk...
dsmadmc -id=xxx -pa= -itemcommit
-outfile=/var/tsm/report_data/actlogtmp1 macro /flapps
/adsm/macros/actlogscan.mac
awk '$3 ~ /D/|| $3 ~ /W/|| $3 ~ /[0-9,0-9,0-9]E/'
/var/tsm/report_data/actlogtmp1 > /var/tsm/re
port_data/actlogtmp2
awk 'substr($1,1,1) ~ /[0-9]/' /var/tsm/report_data/actlogtmp2 >
/var/tsm/report_data/actlogtmp
3
#
# this is the message elimination step
#ANR2457E BACKUP STGPOOL: Backup of primary storage pool  NOTETAPE to copy
storage pool NOTETAP
E_CP
# already in progress.
# ANR2209W Volume /dev/radsmstglv06 contains no data.
# ANR0944E QUERY PROCESS: No active processes found.
# ANR2034E QUERY SESSION: No match found using this criteria.
#  ANE4987E (Session: 14832, Node: US504S16)  Error processing
'\\us504s16\c$\WINNT\system32\co
nfig
# \SAM.LOG': the object is in use by another process
# ANE4007E (Session: 14475, Node: PLANXI04)  Error  processing
'\\planxi04\c$\WINNT\Profiles\
#   corpxchgsvc\NTUSER.DAT': access to the object is denied
# ANR1423W Scratch volume 001223 is empty but will not be
#   deleted - volume access mode is "offsite". you get a slew of
these after
# a tsm recycle pretty much for every volume in courierretrieve atleast.
#  ANR2841W Server is NOT IN COMPLIANCE with license terms.
awk '$3 !~ /ANR2457E/&&$3 !~/ANR2209W/&&$3 !~/ANR0944E/&&$3 !~/ANR2034E/&&$3
!~/ANE4987E/&&$3!~
/ANE4007E/&&$3 !~/ANR1423W/&&$3 !~/ANR2841W/'
/var/tsm/report_data/actlogtmp3 > /var/tsm/report
_data/actlog_to_email
mail -s "TSM - SCANLOG report" xxxt < /var/tsm/report_data/actlog_to_email
mail -s "TSM - SCANLOG report" xxx < /var/tsm/report_data/actlog_to_email
mail -s "TSM - SCANLOG report" xxx < /var/tsm/report_data/actlog_to_email
#
dsmadmc -id= -pa=xxx macro /flapps/adsm/macros/showtime.mac
[pbsxsz4][/flapps/aix/prod.script]>

-Original Message-
From: tsm [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 1:59 PM
To: [EMAIL PROTECTED]
Subject: Re: Select Stmt? or Query


hi, maybe you will have something usefull on this script:

select severity,count(*) as "TOTAAL" from actlog where severity in
('E','W') AND cast((current_timestamp-date_time)hours as decimal (8,0)) <24
group by severity select date(date_time) as "DATUM" , time(date_time) as
"TIJD" , message as "MESSAGE" FROM actlog WHERE severity = 'E' AND msgno
NOT in
(0944,1455,1463,1464,1469,2000,2020,2022,2034,2165,2166,2305,2904,2905,2906,
2908,2909,2911,2916,2938,2940)
AND cast((current_timestamp-date_time)hours as decimal (8,0)) <24

or

select nodename,message from actlog where (msgno=4961 or msgno=4964)AND
nodename='$1' AND cast((current_timestamp-date_time)hours as decimal (8,0))
<24 order by nodename

Look in the messages guide 5.1 Messages GC32-0767-00.pdf for other
messagenumbers you would like to see.


At 10:13 21-05-2002 -0700, you wrote:
>Also, there *may* be other messages of interest (if b/a-client, 4961, 4959,
>and others in close numeric proximity are the session statistics messages).
>
>
>Don France
>Technical Architect - Tivoli Certified Consultant
>Professional Association of Contract Employees (P.A.C.E.)
>San Jose, CA
>(408) 257-3037
>[EMAIL PROTECTED]
>
>
>- Original Message -
>From: "Steve Harris" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Tuesday, May 07, 2002 7:26 PM
>Subject: Re: Select Stmt? or Query
>
>
>Try something like
>
>select date_time, message
>from actlog
>where nodename='MYNODE'
>and date_time > current timestamp - 12 hours
>and msgno in (1234, 5678, 9876)
>
>Just tune the where clause to select the messages that you want.  Run this
>in commadelimited mode and pipe the output through your scripting tool of
>choice to give you a pretty report.
>
>Steve Harris
>AIX and TSM Admin
>Queensland Health, Brisbane Australia
>
> >>> [EMAIL PROTECTED] 08/05/2002 3:35:57 >>>
>Hello All:
>
>I have a unix client that kicks off an incremental backups thru tivoli
>using an internal dump process for a sql database.  I want to provide a
>report to the group that monitors its backup.  The only information they
>care about is whether a filespace backed up successfully, what files
>failed, and how much data was transferred.  For the time being I am
>running 'q actlog begind=-1 begint=18:00:00 sea='nodename', because we
>try to schedule our backups between 6 p.m. and 6 a.m.  This is too much
>information to run thru on a daily basis for them and they were hoping I
>could trim down a report.  Does anybody have a select statement or query
>that comes close to the needs I have?
>
>Thanks,
>
>Bud Brown
>Information Services
>Systems Administrator
>
>
>
>**
>This e-mail, including any attachments sent with it, is confidential
>and for the sole use of the intended recipient(s). This confidentiality
>is not waived or lost if you receive it an

Re: help dosn't work

[Williams, Tim P {PBSG}]

to verify:
lslpp -l (or -h) tivoli.tsm.msg.en_US.server
you probably didnt update the "msg"

per the "install" readme
USING: To "install", as root user, follow these steps:

0. Uncompress and untar the file TSMSRVAIX04_02_02.tar.gz

1. Halt your server

2. Start SMIT and select the following options to APPLY this service.
   o Software Install and Maintenance
 o Install and Update Software
   o Install and Update from ALL Available Software
 o Specify INPUT device/directory
 o List SOFTWARE to Install - Select all the filesets
 o set "COMMIT software updates?" to no
 o set  "SAVE replaced files?" to yes
3. restart the server.



-Original Message-
From: Stephen Pole [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 5:56 AM
To: [EMAIL PROTECTED]
Subject: Re: help dosn't work


Hello,

Did you do this via smitty - upgrade all? - I never believe it!! Maybe I
should! It is easy to unhighlight a package, or miss it all together.

Can you check that you have the correct version of help? Or that the help
was in fact installed? And that it exists in the right place.
Make sure you reinstall the help files.

I've struck this a few times, and  as far as I can remember that is all I
did.

I'm sure others will be able to assist if this doesn't

Good luck

Stephen.


-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Salvatore
Sent: Wednesday, 15 May 2002 3:11 PM
To: [EMAIL PROTECTED]
Subject: help dosn't work

Hi ,
I'm having a problem after an upgrade of TSM 4222 server, from a prevously
version 4210, on AIX 433.
The help on line dosn't work, when i try to use a simple help command, for
example HELP REG LIC,
i receive an output that is on a 1 line whithout carriage return.
Can anybody help me to fix this?
Many thanks in advance.

Re: Linux - down-level

[Williams, Tim P {PBSG}]

are they using virtual node? and the node that they are doing virtualnode
from is at a lower level
of client code??


-Original Message-
From: Paul Zarnowski [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 2:03 PM
To: [EMAIL PROTECTED]
Subject: Linux - down-level


We have a couple of users here who have tried the Linux 5.1 code, and are
getting an error message, "The client code is down-level".  Our server is
at 4.2.1, but the README says this should work.  Has anyone else seen
this?  Anyone have any suggestions?  Thanks.  ..Paul


--
Paul Zarnowski Ph: 607-255-4757
747 Rhodes Hall, Cornell UniversityFx: 607-255-8521
Ithaca, NY 14853-3801  Em: [EMAIL PROTECTED]

Re: filesystems and directories under the same name

[Williams, Tim P {PBSG}]

For aix, I don't believe that TSM works that way...removing a filesystem
(all activity stops...)
is different in TSM's eyes than removing a file (file(s) change
to inactive...delete policies take effect, etc)(from what I've seen).
*
reminder...if you archive from that filesystem, then you may not
be able to remove it (retention of archive files...), but
keep in mind the rename option...
*
Thanks Tim

-Original Message-
From: Martin, Jon R. [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 8:21 AM
To: [EMAIL PROTECTED]
Subject: Re: filesystems and directories under the same name


George,

Did a backup run between the time that the filesystem was removed
and the new file system created?  I believe that when /inbound/site was
removed the data was lost.  If a backup was run TSM would mark the data as
inactive.  Now when your are try to restore to the new filesystem you should
be looking at inactive file not only inactive.  Just a thought.

Thanks,
Jon Martin

-Original Message-
From: Hagopian, George [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 9:22 AM
To: [EMAIL PROTECTED]
Subject: filesystems and directories under the same name


Good morning everyone

I can across an problem with no idea of a resolution.
AIX TSM server 4.2

I had a filesystem called say /inbound/site
now they removed the filesystem but still needed the pathso
they have a filesystem called /inbound and created a sub directory called
site

When you try to do a restore via the command line it only finds the
filesystem data not the directory data
If I try to restore via X window or web I have to go through the filesystem
/inbound and to the subdirectory site

How can I get the data off the filesystem /inbound/site and in the directory
/inbound/site
I can'd restore the data and then back it up again...too much data and not
enough space on the server

Sorry to hit everyone in the morning with this...but I was trying to figure
this out all last night w/ no success

Thanks
George Hagopian
AIX/TSM Administator
ICT Group

Re: filesystems and directories under the same name

[Williams, Tim P {PBSG}]

I had the same experience.
I ended up removing the original filespace (/inbound/site), but you could
rename it...as you
have another (/inbound)look/check via the q filespace command.
GUI doesn't work, but command line should (check)...q back or q arch...
good luck.
hope this helps.
TW

-Original Message-
From: Hagopian, George [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 8:22 AM
To: [EMAIL PROTECTED]
Subject: filesystems and directories under the same name


Good morning everyone

I can across an problem with no idea of a resolution.
AIX TSM server 4.2

I had a filesystem called say /inbound/site
now they removed the filesystem but still needed the pathso
they have a filesystem called /inbound and created a sub directory called
site

When you try to do a restore via the command line it only finds the
filesystem data not the directory data
If I try to restore via X window or web I have to go through the filesystem
/inbound and to the subdirectory site

How can I get the data off the filesystem /inbound/site and in the directory
/inbound/site
I can'd restore the data and then back it up again...too much data and not
enough space on the server

Sorry to hit everyone in the morning with this...but I was trying to figure
this out all last night w/ no success

Thanks
George Hagopian
AIX/TSM Administator
ICT Group

Re: TSM Crashing

[Williams, Tim P {PBSG}]

Also, look at dsmserv.err  in your /usr/tivoli/tsm/server/bin dir.
(the bottom..)

-Original Message-
From: PINNI, BALANAND (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 8:04 AM
To: [EMAIL PROTECTED]
Subject: Re: TSM Crashing


Paul
There is dbx utility in AIX to check what exactly happened .U need to
preserve core file.
Another thing I would look into bos.rte file maintenance level and see if
this as some APAR with Tivoli file sets.
Look in TSM website.Add be sure ur both OS and TSM are at latest Patch
levels.
Balanand

-Original Message-
From: Coviello, Paul [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 7:35 AM
To: [EMAIL PROTECTED]
Subject: Re: TSM Crashing


is there an error before it?  anything to the effect of the file
system is full?

Paul

> -Original Message-
> From: Ray Baughman [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, May 03, 2002 8:15 AM
> To:   [EMAIL PROTECTED]
> Subject:  TSM Crashing
>
> Hello All,
>
> We are experiencing TSM crashes on a daily basis.  We are running TSM
> 4.2.1.7 on AIX 4.3.3 Every time it happens there is nothing in the
> activity
> log, however it does place a record into the AIX error log.  The following
> is the record.  Any help would be greatly appreciated.
>
> --
> -
> LABEL:  CORE_DUMP
> IDENTIFIER: C60BB505
>
> Date/Time:   Thu May  2 18:35:50
> Sequence Number: 15496
> Machine Id:  59574C00
> Node Id: edpserv
> Class:   S
> Type:PERM
> Resource Name:   SYSPROC
>
> Description
> SOFTWARE PROGRAM ABNORMALLY TERMINATED
>
> Probable Causes
> SOFTWARE PROGRAM
>
> User Causes
> USER GENERATED SIGNAL
>
> Recommended Actions
> CORRECT THEN RETRY
>
> Failure Causes
> SOFTWARE PROGRAM
>
> Recommended Actions
> RERUN THE APPLICATION PROGRAM
> IF PROBLEM PERSISTS THEN DO THE FOLLOWING
> CONTACT APPROPRIATE SERVICE REPRESENTATIVE
>
> Detail Data
> SIGNAL NUMBER
>6
> USER'S PROCESS ID:
>44206
> FILE SYSTEM SERIAL NUMBER
>6
> INODE NUMBER
>   458790
> PROGRAM NAME
> dsmserv
> ADDITIONAL INFORMATION
> pthread_k 80
> ??
> _p_raise 64
> raise 34
> abort B8
> AbortServ 80
> TrapHandl 13C
> ??
> ??
>
> Symptom Data
> REPORTABLE
> 1
> INTERNAL ERROR
> 0
> SYMPTOM CODE
> PCSS/SPI2 FLDS/dsmserv SIG/6 FLDS/AbortServ VALU/80
>
>
>
> Ray Baughman
> Engineering Systems Administrator
> TSM Administrator
> National Machinery LLC
> Phone 419-443-2257
> Fax 419-443-2376
> Email [EMAIL PROTECTED]

Re: 4.2 silent install

[Williams, Tim P {PBSG}]

You run the executable...(the thing that you download from ibm's website,
etc).
it will prompt/allow you to place the tsmimageswhereever...
when you get to the point where it asks you what demo language, you can
cancel there
(at that point you have created the images, but stopped short of an
install).
FYI

-Original Message-
From: Jim Healy [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 26, 2002 12:42 PM
To: [EMAIL PROTECTED]
Subject: Re: 4.2 silent install


how do you execute the extract?




"Williams, Tim P {PBSG}" <[EMAIL PROTECTED]>@VM.MARIST.EDU> on
04/26/2002 01:06:55 PM

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

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


To:   [EMAIL PROTECTED]
cc:

Subject:  Re: 4.2 silent install


You need to do the extract first...and this will make the images
file(s)...what I don't like...is you
get all the languages too

we put this to a samba drive...I do have a cleanup that I constructed that
you can use as a model to trim down to just english (1033mst):
[pbsxsz4][/flhome/twill1]>more clientclean42120.ksh
rm
/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/baclie

nt/1028.mst
rm
/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/baclie

nt/1031.mst
rm
/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/baclie

nt/1034.mst
rm
/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/baclie

nt/1036.mst
rm
/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/baclie

nt/1040.mst
rm
/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/baclie

nt/1041.mst
rm
/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/baclie

nt/1042.mst
rm
/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/baclie

nt/1046.mst
rm
/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/baclie

nt/2052.mst
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dsc30chs.dll"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dsc30cht.dll"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dsc30deu.dll"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dsc30esp.dll"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dsc30fra.dll"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dsc30ita.dll"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dsc30jpn.dll"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dsc30kor.dll"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dsc30ptb.dll"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dsccht.txt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dscdeu.txt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dscesp.txt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dscfra.txt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dschchs.cnt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dschchs.hlp"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dschcht.cnt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dschcht.hlp"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dschdeu.cnt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dschdeu.hlp"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/TSM/baclient/dschesp.cnt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli

ent/program file
s/Tivoli/

Re: 4.2 silent install

[Williams, Tim P {PBSG}]

You need to do the extract first...and this will make the images
file(s)...what I don't like...is you
get all the languages too

we put this to a samba drive...I do have a cleanup that I constructed that
you can use as a model to trim down to just english (1033mst):
[pbsxsz4][/flhome/twill1]>more clientclean42120.ksh
rm
/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/baclie
nt/1028.mst
rm
/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/baclie
nt/1031.mst
rm
/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/baclie
nt/1034.mst
rm
/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/baclie
nt/1036.mst
rm
/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/baclie
nt/1040.mst
rm
/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/baclie
nt/1041.mst
rm
/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/baclie
nt/1042.mst
rm
/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/baclie
nt/1046.mst
rm
/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/baclie
nt/2052.mst
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dsc30chs.dll"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dsc30cht.dll"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dsc30deu.dll"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dsc30esp.dll"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dsc30fra.dll"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dsc30ita.dll"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dsc30jpn.dll"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dsc30kor.dll"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dsc30ptb.dll"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dsccht.txt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dscdeu.txt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dscesp.txt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dscfra.txt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dschchs.cnt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dschchs.hlp"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dschcht.cnt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dschcht.hlp"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dschdeu.cnt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dschdeu.hlp"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dschesp.cnt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dschesp.hlp"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dschfra.cnt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dschfra.hlp"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dschita.cnt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dschita.hlp"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dschjpn.cnt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dschjpn.hlp"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dscjapan.txt"
rm
"/flapps/aix/tsm_images/tsm_images/image_subdir_4.2.1.20/TSM_BA_Client/bacli
ent/program file
s/Tivoli/TSM/baclient/dschkor.cnt"
rm
"/flap

Re: TSM Client for Linux

[Williams, Tim P {PBSG}]

you probably have something in your dsmerror.log when you try to do a
incrementalhere's my etr:
Abstract:LANS1149E No domain available for incremental
backup
 User keyword:
 Status:  Closed
 Responsible:
 Type:Software Problem
 Severity:3
 CPU device type: 3745
 CPU serial number:   2301526
 Component ID:5697TSMCL
 APAR:
 Release: 210
 Created: 02/04/25
 Updated: 02/04/25
 Contact name:Tim Williams
 Company name:FRITO LAY INC
 Customer ID: 3562300
 Owner IGN user ID:   FRTO13
 Owner IGN account ID:FRTO
 Contact method:  Electronic
 Primary telephone:   (972) 376-7774
 Alternate telephone:
 Electronic delivery ID:  FRTO13
 Electronic account code: FRTO

 -FRTO13FRTO-5697TSMCL  - 02/04/25-15:38-
** For IBM Use Only 
*  In RETAIN use CR CA to complete the call.   *
* The use of CC will not notify the originator of a response!  *

RESPOND ELECTRONICALLY.
Route = 5697TSMCL.
Abstract: LANS1149E No domain available for incremental backup

We went from Linux Redhat 7.0 to 7.2
when we went to 7.2 we starting using ext3/jfs
The default of domain all-local does not seem to be invoking...
so we got:
ANS1149E No domain available for incremental backup
we only have 2 local file systems:
/   and /boot
so I added domain / and /boot in the dsm.sys (or options file) and
then incremental backups started to work ok...
what's going on here?
Thanks Tim
x
Hello Tim,
   We don't officially support the ext3 filesystem until V5.1. However
the V4.2 client will operate against this filesystem in "toleration"
mode. To make this work you have to do explicit things as you have
found. To get full support for this fs as "nornal" you will need to
run the V5.1 client on this machine.
  Thanks, x.


 -FRTO13FRTO-5697TSMCL  - 02/04/25-16:07-
Reason For Closure:
Thanks. This to close/complete.
upgrade works

-Original Message-
From: Jesse Sanaseros [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 4:24 PM
To: [EMAIL PROTECTED]
Subject: TSM Client for Linux


Please help.  I've just installed the TSM Client 4.2.1 on Linux 7.2.  I used
the Setup Wizard to created the dsm.opt file and manually edited the dsm.sys
file.  I registered the node with the Server.  TSM Server 4.1 is running on
AIX 4.3.3.  When I run the GUI to start the initial backup there are no
directories listed under Local.  Please help, I don't know what I'm doing
wrong.

Thanks.

Jesse Sanaseros
Information Services
Network Administrator
[EMAIL PROTECTED]

Re: Tape Library errors

[Williams, Tim P {PBSG}]

do you really have a space between /devand   /smc0?
there shouldn't be one...

-Original Message-
From: Eduardo Martinez [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 10:41 AM
To: [EMAIL PROTECTED]
Subject: Tape Library errors


Hello everyone.

I have problems installing an IBM 7334 Tape Library on a RS/6000 44P
server.
When I try to define the library I get the following error code:

TSM1>def library lib7334 libtype=scsi device=/dev /smc0

ANR8418E DEFINE LIBRARY  An I/O error  ocurred while accessing library
Lib7334.
ANS8001I  Return Code 3.

When I test the library with the tapeutil tool, it works fine, but
always send this error when I try to define it to TSM.

Anyone of you have any advice?

Thanks in advance.

=
"Do or Do Not, there is no try"
-Yoda. The Empire Strikes Back

___
Do You Yahoo!?
Yahoo! Messenger
Comunicacisn instantanea gratis con tu gente.
http://messenger.yahoo.es

Re: extra licences must be registered

[Williams, Tim P {PBSG}]

is the name for your machines
"register node"
for the tdp and the nodes that they run onthe same name?


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 19, 2002 7:02 AM
To: [EMAIL PROTECTED]
Subject: extra licences must be registered


Dear gurus,
Tivoli needs an extra number of "Managed System for LAN" licences.

I have lots of scheduled backups of database via TDP for SQL (v2.2) and TDP
for Oracle (v2.2.0.2).

The TSM server (v4.2.1.9) runs on AIX 4.3.3.

My environment is:
2 AIX client
1 AIX client + 1 TDP for Oracle for AIX (on the same machine)
2 Linux86 client
7 Solaris client
2 Solaris client + 2 TDP for Oracle for SUN (on the same machine)
9 WinNT client
2 WinNT client + 2 TDP for SQL (on the same machine)

I think, I have to buy:
Licences for Managed System for LAN: 25 (3 AIX, 1 Linux86, 9 Solaris, 11
WinNT)
Licences TDP for Oracle: 3
Licences TDP for MS SQL Server: 2


This is an extract of the "q system" output:
**
*** ---> select platform_name,count(*) from nodes group by platform_name
**
PLATFORM_NAME Unnamed[2]
 ---
AIX3
Linux862
SUN SOLARIS9
TDP Oracle AIX 1
TDP Oracle SUN 2
WinNT 13

The problem is:
1) I have 11 WinNT clients, not 13!!!
2) Where are the 2 TDP MSSQLV2 NT clients?


This is an extract of the "q licence"

Number of Managed System for LAN in use: 30
!!! I have only 25 clients !!!

Number of TDP for Oracle in use: 3
The number it's right.

Number of TDP for MS SQL Server in use: 2
The number is't right.

Regards
Nasca Paolo
Cleis Technology srl
Via E. Raggio, 4
16124 Genova - Italy
+39 010 24858.11
[EMAIL PROTECTED]
[EMAIL PROTECTED]

Re: Daily Backup Report

[Williams, Tim P {PBSG}]

we generally run a q event command   ex=yes
you can use begindate begintime parms, etc
help q event
fYI

-Original Message-
From: Orin Rehorst [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 8:48 AM
To: [EMAIL PROTECTED]
Subject: Daily Backup Report


What are some good ways to get an automated daily report on which clients
were or were no backed up successfully?

TIA,

Regards,
Orin

Orin Rehorst
Port of Houston Authority
(Largest U.S. port in foreign tonnage)
e-mail:  [EMAIL PROTECTED] 
Phone:  (713)670-2443
Fax:  (713)670-2457
TOPAS web site: http://www.homestead.com/topas/topas.html> >

Re: Database backup trigger spits out tape over and over again.

[Williams, Tim P {PBSG}]

is the reason it wants an existing tape...because when you set
dbbackuptrigger
you specified numincremental (indicating incrementals instead of fulls
6 is the default for this
0 (full) would have to be specified...
FYI

-Original Message-
From: Frank Kruse [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 9:13 AM
To: [EMAIL PROTECTED]
Subject: Database backup trigger spits out tape over and over again.


Let me try this problem again.  I have my dbbackuptrigger defined to
backup to devclass "8mmdb".  When I enable the logmode to rollforward,
the db wants to do a full backup.  When the process kicks off, the tape
drive (manual) reads the tape and immediately spits it out.  If I query
the processes, I see the process for the db backup.  If I query the
requests, I see that TSM is requesting me to mount volume "DBBK.1"  I do
not have this volume anymore, I can't re-label a volume dbbk.1 because
it is already in the volhist.  Is there any way I can keep this from
happening?  My dbbackuptrigger is pretty much useless at this time.  I
can't get a tape to stay in the drive.  I was finally able to label a
tape (with logmode normal only), then do a manual db backup to  the new
volume.   Do I need to delete the dbbackuptrigger and recreate?

--
**
*  Frank Kruse  [EMAIL PROTECTED]*
*  IBM Austin   512-823-7475 *
**

Re: Database backup trigger spits out tape over and over again.

[Williams, Tim P {PBSG}]

tsm: ADSM>q dbbackuptrigger

Full Devi- Incremental   Log Full Incrementals
ce Class   Device  Percentage  Between
   Class Fulls
-- --- -- 
3590CART   3590CART550


what's your number on the far right?

-Original Message-
From: Frank Kruse [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 9:13 AM
To: [EMAIL PROTECTED]
Subject: Database backup trigger spits out tape over and over again.


Let me try this problem again.  I have my dbbackuptrigger defined to
backup to devclass "8mmdb".  When I enable the logmode to rollforward,
the db wants to do a full backup.  When the process kicks off, the tape
drive (manual) reads the tape and immediately spits it out.  If I query
the processes, I see the process for the db backup.  If I query the
requests, I see that TSM is requesting me to mount volume "DBBK.1"  I do
not have this volume anymore, I can't re-label a volume dbbk.1 because
it is already in the volhist.  Is there any way I can keep this from
happening?  My dbbackuptrigger is pretty much useless at this time.  I
can't get a tape to stay in the drive.  I was finally able to label a
tape (with logmode normal only), then do a manual db backup to  the new
volume.   Do I need to delete the dbbackuptrigger and recreate?

--
**
*  Frank Kruse  [EMAIL PROTECTED]*
*  IBM Austin   512-823-7475 *
**

Re: Redirecting Commands in Scripts

[Williams, Tim P {PBSG}]

I put in a marketing requirement a couple of years agoFYI

req00072775  redirection is not supported for commands in a script file
(just as redirection is not supported for
 commands run from the server console).

-Original Message-
From: Gerhard Wolkerstorfer [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 5:26 AM
To: [EMAIL PROTECTED]
Subject: Redirecting Commands in Scripts


Hello all,
I found questions like this in the archives, but no answers..

One more try =>
I want to run a script, where one line should look like this:
QUERY SYSTEM > DSM.OUTPUT.QSYSTEM
where DSM.OUTPUT.QSYSTEM is a S390 Filename I want to take to the OFFSITE
Location.
(This Command works great on the command line, but I want to have it in a
script!)

However - I tried to do it like this:
def script test desc='Test'
upd script test "QUERY SYSTEM > DSM.OUTPUT"

Result:
ANR1454I DEFINE SCRIPT: Command script TEST defined.
ANR2002E Missing closing quote character.
ANS8001I Return code 3.

Any hints how to route an output to a file in a script  ?
I guess, the problem is, that TSM wants to direct the Output of the Update
Stmt
to a file - and when doing this, one quote is missing, of course

We are running TSM 3.7.5 on S390 (I know, not supported, but I guess this
should
work on all versions)

Regards
Gerhard Wolkerstorfer

Re: TSM db backup.

[Williams, Tim P {PBSG}]

Look at your devclass on your dbbackuptrigger.
do a help on define dbbackuptrigger.
FYI

tsm: ADSM>q dbbackuptrigger f=d

Full Devi- Incremental   Log Full Incrementals Last Update
by (administrator)  Last Update Date/Time
ce Class   Device  Percentage  Between

   Class Fulls

-- --- -- 
-- --
3590CART   3590CART550
TWILL104/06/01   11:04:34


tsm: ADSM>help define dbbackuptrigger
DEFINE DBBACKUPTRIGGER

DEFINE DBBACKUPTRIGGER (Define the Database Backup Trigger)

Use this command to specify when TSM backs up the database. A backup occurs
when the specified percentage of the assigned capacity of the recovery log
is reached. TSM uses the database trigger only if the log mode is set to
ROLLFORWARD.

Note:
 If the backup fails, TSM waits 60 seconds and then tries again. It
 continues to retry the backup until it is successful.

Privilege Class

To perform this task, you must have one of the following privilege classes:

   * System privilege
   * Unrestricted storage

Syntax

>>-DEFine DBBackuptrigger--DEVclass--=--device_class_name--->

   .-LOGFullpct--=--50--.
>--++--->
   '-LOGFullpct--=--percent-'

>--++--->
   '-INCRDEVclass--=--device_class_name-'

   .-NUMINCremental--=--6--.
>--+---+---><
   '-NUMINCremental--=--number-'

-Original Message-
From: Frank Kruse [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 11, 2002 10:26 AM
To: [EMAIL PROTECTED]
Subject: TSM db backup.


Hello all,

Let me start out by saying that I am a new subscriber to this list, so
sorry if these question have been posted before.   I have recently set
up a TSM server.  The server and client code is at 4.2.1.  I have the
clients backing up to the server and files going only to disk storage
pool only for the time being, until I get my tape drives.  The problem
I am having is with my database backups.  I set up the dbbackuptrigger
to backup the database at 75%.  Now my problem, whenever I set logmode
to rollforward, TSM automatically wants to do the first dbBackup which I
assume would be a full backup.  After the process gets kicked off, the
20 gig tape just gets spit out.  Even when I set the logmode to normal
and try a manual "backup db devclass=8mmdb type=full scratch=yes".  When
I run the command the tape reads, rewinds, and ejects without the
backup.  This is very frustrating and is probably something very
obvious, but I can't figure it out.  Can anyone tell me what I may be
doing wrong?






--
**
*  Frank Kruse  [EMAIL PROTECTED]*
*  IBM Austin   512-823-7475 *
**

Re: sql/copygroup dilemma/question

[Williams, Tim P {PBSG}]

select * from archives where node_name='casesensitive' > /output

-Original Message-
From: Wholey, Joseph (TGA\MLOL) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 1:00 PM
To: [EMAIL PROTECTED]
Subject: sql/copygroup dilemma/question


I'm in the process of moving data from one instance of TSM to a new
instance.  Before I make the move and scrap the old server I'd like to
identify Nodes with files bound to management classes.  This
effort is being undertaken so we don't migrate extraneous data.  Of course,
the active management classes won't be a problem... easily identifiable.
But we have some archive managemnet classes that
have been out there for a long time, not active for a long time and also
have long retention periods.  Any suggestions on a command I can issue to
start IDing some of this stuff.  Any help would be
greatly appreciated.

Regards,
Joe Wholey
TGA Distributed Data Services
Merrill Lynch
Phone: 212-647-3018
Page:  888-637-7450
E-mail: [EMAIL PROTECTED]

not done...: downlevel client code - has anybody found... "solved "

[Williams, Tim P {PBSG}]

I don't think this will be solved for you.
>From what I understand there are client upgrades that may have some coding
changes
that will  update the TSM server database in such a way that downleveling
your client will
make "functions" unusable and that's why for some upgrades you will get a
message about
having downleveled code and it will prevent you from logging in.
*
or secondly, it could be a server change, coupled with a client code level
change...
*
The recent change was unicode, yes.
*
Support/TSM/Tivoli like to say that you can never regress, but I like to
ask, because
you always want to understand backout plans
*
my understanding.
FYI Thanks Tim


-Original Message-
From: Gretchen L. Thiele [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 3:26 PM
To: [EMAIL PROTECTED]
Subject: Re: downlevel client code - has anybody found... "solved"


At Andy's suggestion, I called this problem into support. Not for
the faint of heart, but the critical restore that I needed to get
done today has now completed.

This only affects WinNT and Win2K clients and the problem is the
server, not the client. Support says that it will be fixed in the
next release, whether or not that is v4.2.2.x or v.5.1.x.x, he
didn't know. A unicode 'thing'.

Thanks for everyone's responses.

Gretchen Thiele
Princeton University

FYI on tape volume usage select statement (use of DISTINCT)

[Williams, Tim P {PBSG}]

IF your tape stgpool is collocated (you have to consider if a node has
offsite tape volumes and if that
stgpool has colocation on or off as well)
AND you want to know how many tapes a node spans...
try this:
tsm: ADSM>select node_name, count(distinct volume_name) from volumeusage
where node_name='PBSXDR2' and stgpool_name like '%TAPE' group by
node_name

I gave the select statement the node name, I also provided the a partial
stgpoolname (that will just get my local, non-vaulted, tapes that ARE
collocated(stgpool_name like '%TAPE')).

FYI...this will take a couple of minutes depending on your db, etc.

tsm: ADSM>select node_name, count(distinct volume_name) from volumeusage
where node_name='PBSXDR2' and stgpool_name like '%TAPE' group by
node_name
ANR2963W This SQL query may produce a very large result table, or may
require a significant
amount of time to compute.

Do you wish to proceed? (Yes (Y)/No (N)) y

NODE_NAME   Unnamed[2]
-- ---
PBSXDR2218

Re: Accounting Log

[Williams, Tim P {PBSG}]

I kinda like the summary table and it may have less issues than the
dsmaccnt.log
**
we have nodes that do hundreds of archives not to mention that
multithreading
incremental backups (resourceutilization in the dsm.opt) will create
multiple dsmaccnt.log records...
**
the select (2nd one below) will sum inbound data by...you can choose backup
or archivefor a day's activity
by node...
FYI Thanks Tim

tsm: ADSM>select activity from summary group by activity order by activity

ACTIVITY
--
ARCHIVE
BACKUP
EXPIRATION
FULL_DBBACKUP
MIGRATION
MOVE DATA
RECLAMATION
RESTORE
RETRIEVE
STGPOOL BACKUP
TAPE MOUNT




tsm: ADSM>macro thebest
ANS8000I Server command: 'select date(days(current_date)-1) as "DATA date",
summary.entity, nodes.domain_name, nodes.platform_name, sum(summary.bytes)
as sum_bytes from summary, nodes where summary.entity=nodes.node_name and
summary.activity='BACKUP' and days(current_date)-days(start_time)=1 group by
summary.entity, nodes.domain_name, nodes.platform_name' order by sum_bytes
desc

DATA date: 2002-01-08
   ENTITY: US504S3E
  DOMAIN_NAME: NOTES_PD
PLATFORM_NAME: WinNT
SUM_BYTES: 98826545113

-Original Message-
From: Marc David [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 10:46 AM
To: [EMAIL PROTECTED]
Subject: Accounting Log


Hi All,

We turn on the Account Log on our TSM server (H50 running AIX 4.3.3).

This way we can charge back clients for disk space usage.

My question is, does anyone use this ?

Plus how do you get the output from the file DSMACCNT.LOG  into a readable
report for management.


Marc David
Storage Manager
PFPC Global Fund Services
(508) 871-9961

Re: Query about QUERY in TSM

[Williams, Tim P {PBSG}]

Can you clarify?
are you asking about what different type of queries there are...
on an admin command line:
help query
?


-Original Message-
From: Coats, Jack [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 4:53 PM
To: [EMAIL PROTECTED]
Subject: Query about QUERY in TSM


Is there a table in TSM where I can look to see the SQL query run
for the various QUERY commands?

Re: Question about tape drive utilization and the summary file

[Williams, Tim P {PBSG}]

lsdev -Cc tape
can you see the drive?
Ted has a good idea...
q mount shows nothing?
q sess f=d shows no mount for that drive?
mtlib -l/dev/lmcp0 -qM  (query mount from aix if you have aix...) to look
for a mount on the operating
system level...
is the drive available at the 3494?
some ideas.


-Original Message-
From: Qualls, Ted W {PBSG} [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 3:30 PM
To: [EMAIL PROTECTED]
Subject: Re: Question about tape drive utilization and the summary file


Have you tried taking drives 0,1 and 3 offline to see if drive 2 gets a
mount?

-Original Message-
From: David Jelinek [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 12:53 PM
To: [EMAIL PROTECTED]
Subject: Question about tape drive utilization and the summary file


Is the summary file supposed to list all tape mounts for drives online to
TSM? I thought that I would use the summary log to determine tape
utilization. When I pulled the data, I discovered that we have been using
drives 0,1, and 3 but not using drive 2 (not a single mount in a month and a
half according to the summary table). And yes, the drive has been online to
TSM the whole time with no errors reported that I can find. Am I missing
something obvious? We have a 3494 library with 3590 drives.
Thanks in advance.

--
David Jelinek
Systems Programmer
Central Michigan University

Re: Mount point reserved

[Williams, Tim P {PBSG}]

If you are using a gui or command line...archive...and go back to the gui or
command line...you
will HOLD that mount.
In our dsmserv.opt we now have:
IDLETIMEOUT 15
so when a user does not get all the way out of tsm after an archive,
retrieve, or whatever
we will terminate the session (idletimeout 15 minutes).
Of course, holding a tape and tape drive is very expensive
dsmc archive file archmc=whatever
as opposed to
dsmc
archive whatever
DOES make a difference...
dsmc archive...blah blah...will return you back to your operating system
prompt after the archive
dsmc (then enter or return)
then...archive will hold the drive...


-Original Message-
From: David Longo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 10:13 AM
To: [EMAIL PROTECTED]
Subject: Mount point reserved


I have fairly new TSM server 4.2.1.9 on AIX 4.3.3. with 3584 library.
I just did first ARCHIVE from a client.  Doing a  q mount now shows:

ANR8376I Mount point reserved in device class LTO, status: RESERVED.

at end of display.  Archive is finished over an hour now and this message
still shows up.  I only have a ONE minute mount retention set up for tape.

How do I get rid of the RESERVED mount point?  I didn't have this
with old 3.7.4.0 server.




David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH  321.434.5536
Pager  321.634.8230
Fax:321.434.5525
[EMAIL PROTECTED]



"MMS " made the following
 annotations on 03/27/02 11:26:40

--
This message is for the named person's use only.  It may contain
confidential, proprietary, or legally privileged information.  No
confidentiality or privilege is waived or lost by any mistransmission.  If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it, and notify the
sender.  You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient.  Health First reserves the right to monitor all e-mail
communications through its networks.  Any views or opinions expressed in
this message are solely those of the individual sender, except (1) where the
message states such views or opinions are on behalf of a particular entity;
and (2) the sender is authorized by the entity to give such views or
opinions.


==

Re: Unload/load DB question

[Williams, Tim P {PBSG}]

Who taught the TSM advanced course...do you have a contact person...the
instructor?
Thanks

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 10:35 AM
To: [EMAIL PROTECTED]
Subject: Re: Unload/load DB question


>From the manual "Student's Trainig Guide, Tivoli Storage Managmer 4.1
Enhancements, Tuning and Trableshooting" (March 2001), Unit 1, pag. 1-11:
---
The new dsmserv loadformat command replases the dsmserv format command when
used in conjunction with dsmserv loaddb or dsmserv restore db.

dsmserv loadformat creates and formats the database. It also initializes
default values and dsmserv upgradedb might under some circumstances not
create the new values that may come with the new code versions,
--

The teacher of the "TSM advanced course" advise me to not unload/load db.
Do it only under the supervision of the tivoli laboratory staff. The DB
could become 3 times bigger!!

Regards
Paolo Nasca
Cleis Technology
I-16124 Genova (ITALY)
[EMAIL PROTECTED]
[EMAIL PROTECTED]

-


If I want to do a unload/load DB for maintenance reasons, do I still
need to do the DSMSERV Format part, or is this
just for when you lose the database. These are the steps I found in
the manual:

1) DSMSERV Dumpdb

2) DSMSERV Format (init database & recovery logs)

3) DSMSERV Loaddb

4) DSMSERV Auditdb (if necessary)

Is there anything else I need to do, or should be aware of

Thanks

Mike Anderson
[EMAIL PROTECTED]

batch-command line interface changed with 4.2.1.0 (scroll prompt )

[Williams, Tim P {PBSG}]

Sum - we run an external scheduler to do our daily TSM admin cycle:
move bkup data from disk to tape, then ba stg, then ba db, then ejects to
the vault, etc.
We use an external scheduler for this. When we upgraded our ba client (that
includes
dsmadmc), and it seems because the scroll prompt changed, we could no longer
respond correctly to the scroll prompt, causing a loop, causing us to have
to copy overlay the dsmadmc executable.
**
you may be predisposed to this condition, FYI.
Are any others at 4.2.1.0 or higher, have an external scheduler (what, if
so), and
don't see the problem?
**
apar that changed our production world yesterday:
IC31087 - ADMIN COMMAND LINE OF TSM 4.2.0.0 RUN IN GERMAN
  SHOWS 'A'=ABBRECHEN (CANCEL) ON SCROLLPROMPT BUT
  ONLY 'C' WORKS.

Thanks in advance.

more detail:

Abstract: batch-command line interface changed

We have an external scheduler.
We upgraded our TSM client from
Tivoli Storage Manager
Command Line Administrative Interface - Version 4, Release 1, Level 2.0
to
Tivoli Storage Manager
Command Line Administrative Interface - Version 4, Release 2, Level 1.23
(C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved.
**
and the output of a multipage...command line output acts differently and
fills our scheduler log bringing our scheduler to its knees.
**
old batch output worked great:
ANR4554I Backed up 1819664 of 6579134 database pages.
ANR4554I Backed up 1934368 of 6579134 database pages.
ANR4554I Backed up 2049408 of 6579134 database pages.
more...   ( to continue, 'C' to cancel)
ANR4554I Backed up 2166208 of 6579134 database pages.
ANR4554I Backed up 2284400 of 6579134 database pages.
ANR4554I Backed up 2396256 of 6579134 database pages.
***
new one, more or less loops on us:

ANR4554I Backed up 2056576 of 6530195 database pages.
ANR4554I Backed up 2178560 of 6530195 database pages.
ANR4554I Backed up 2300896 of 6530195 database pages.
more...   ( to continue, 'C' to cancel) The only valid responses
are characters from this set: [Enter, C]
The character '#' stands for any decimal integer.The only valid
responses are characters from this set: [Enter, C]
The character '#' stands for any decimal integer.The only valid
responses are characters from this set: [Enter, C]
The character '#' stands for any decimal integer.The only valid
responses are characters from this set: [Enter, C]




Per the above...there is a notable difference:
"old" level (scrollprompt):
more...   ( to continue, 'C' to cancel)
"new" level (scrollprompt):
 more...   ( to continue, 'C' to cancel)
the scroll prompt now has 

Re: TSM server automation.

[Williams, Tim P {PBSG}]

Do you have an external scheduler that you can do job a before job b, before
job c, etc?

-Original Message-
From: Jason Liang [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 22, 2002 8:07 AM
To: [EMAIL PROTECTED]
Subject: TSM server automation.


Hi *SMers,

My environment:  TSM 4.2.1.11  IBM LTO 3584 with 8 drives and 10 I/O
stations.

I want to implement such TSM server automation:

1. If there is no migration running, then "backup stg tapepool copypool";
2. When backup stg finishes, "backup db dev=lto type=full"
3. When backup db finished, change the volumes of copypool to offsite, and
then checkout these volumes and the DB volumes; Notify tape operators;
If the numbers of volumes  exceed 10, then checkout the first 10
volumes, wait for the I/O stations becomes empty and then
   checkout the others;

Any help will be appreciated.

Jason Liang

Re: TSM 4.2.1 Client Error

[Williams, Tim P {PBSG}]

Hi. Per the 4.2.1.20 readme IE v 3.02.
I just did a deinstall and reinstall and ONLY had the option for online
doc...to select
install only if required. I have not rebooted yet, but still have the same
problem
(w/o IE installed).

/4.2.1.20]>more IP22373_20_READ1STC.TXT

Software Requirements
-

  - The Windows Unicode client is supported on the following Windows
versions:

- Windows NT 4.0 SP3, SP4, SP5, SP6, SP6a
- Windows 2000 Professional SP2
- Windows 2000 Server SP2
- Windows 2000 Advanced Server SP2
- Windows 2000 Datacenter Server SP2
- Windows XP - 32 bit

  
  HTML Help System Requirements
  

  - Prerequisites:

This release includes integrated HTMLHELP Online Information
including books, readmes, questions and answers and TSM related
web links.

The HTMLHELP Help Viewer requires that Microsoft Internet
Explorer version 3.02 or later be set up on a user's
computer. It is not required that Internet Explorer be used as
the system's default browser, or that the Internet Explorer icon
be visible on the user's desktop. To obtain the latest version
of Internet Explorer visit:

- http://www.microsoft.com/windows/ie

Note that TSM will not set up an old version of the Help Viewer
over a newer one.  If you want to update the help viewer at any
time visit:

-
http://msdn.microsoft.com/library/tools/htmlhelp/wkshp/download_main.htm

Windows 2000 users should not run the HTML Help Installation and
Update Package. Help component updates are provided via Windows
service packs. For more information, visit the Windows 2000 Home
Page at http://www.microsoft.com/windows2000/default.asp.




-Original Message-
From: Rainer Tammer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 1:00 AM
To: [EMAIL PROTECTED]
Subject: Re: TSM 4.2.1 Client Error


Hello,
we have had a similar problem.
On the failing machine I have had installed IE 3.x.
After an upgrade to IE 5.5SP2 the error message was gone.

Bye
   Rainer Tammer

On Wed, 20 Mar 2002 09:22:44 -0600, Williams, Tim P {PBSG} wrote:

>I have seen this too. I have brought this to support, but haven't gotten
too
>far on
>problem resolution or acceptance.
>**
>Can you remember, if during your install, that you didn't have some
>component of html...
>and you selected yes...to go ahead and install it...(during the
>install/upgrade of your
>tsm client).
>Thanks
>
>-Original Message-
>From: Sutch, Ian (London) [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, March 20, 2002 8:11 AM
>To: [EMAIL PROTECTED]
>Subject: TSM 4.2.1 Client Error
>
>
>Hi,
>
>We have recently installed Version 4.2.1.22 to a Windows NT client.
>The scheduled backups run ok, however when you run dsm.exe locally we get
>the following error:
>
>Error
>Error Initializing the cache, Shutdown all programs and run scandisk or
>chkdsk. Delete the cache, cookies and history directories in your windows
>directory and then restart IE. If the problem persists reinstall IE
>
>Has anyone seen this?
>
>Thanks
>

Re: TSM Accounting Records

[Williams, Tim P {PBSG}]

When you put the accounting records in a spread sheet...the columns are
listed in column 1 below.
The numeric column is col 2 below, col 3 is the description...
This is AIX...
for MVS ?
  Contents
a 1   Product version
 b 2 Product sublevel
 c 3 Product name, 'ADSM',
 d 4 Date of accounting (mm/dd/)
 e 5 Time of accounting (hh:mm:ss)
 f 6   Node name of TSM client
 g7  Client owner name (UNIX)
 h8  Client Platform
 i9  Authentication method used
j 10  Communication method used for the session
k 11  Normal server termination indicator (Normal=X'01',
Abnormal=X'00')
l 12  Number of archive database objects inserted during the
session
m 13  Amount of archived files, in kilobytes, sent by the client
to the server
 n14   Number of archived database objects retrieved during the
session
 o15  Amount of space, in kilobytes, retrieved by archived
objects
 p16  Number of backup database objects inserted during the
session
 q17  Amount of backup files, in kilobytes, sent by the client
to the server
 r18  Number of backup database objects retrieved during the
session
s 19  Amount of space, in kilobytes, retrieved by backed up
objects
t 20  Amount of data, in kilobytes, communicated between the
client node and the server during the
  session
 u 21  Duration of the session, in seconds
 v 22  Amount of idle wait time during the session, in seconds
 w 23  Amount of communications wait time during the session, in
seconds
 x 24  Amount of media wait time during the session, in seconds
 y 25  Client session type. A value of 1 or 4 indicates a
general client session. A value of 5 indicates a
  client session that is running a schedule.
 z 26   Number of space-managed database objects inserted during
the session
 aa 27  Amount of space-managed data, in kilobytes, sent by the
client to the server
 ab 28  Number of space-managed database objects retrieved
during the session
ac 29   Amount of space, in kilobytes, retrieved by
space-managed objects
ad 30   Product release
ae 31   Product level

-Original Message-
From: David E Ehresman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 7:14 AM
To: [EMAIL PROTECTED]
Subject: TSM Accounting Records


Do the TSM accounting records that are written in an Aix environment
have the same layout (minus the header info) that the TSM SMF accounting
records have in MVS?

David

Re: Upgrade from 3590B to 3590E

[Williams, Tim P {PBSG}]

Not getting into the Atape drivers...lslpp -l | grep Atape  to see what
you're curreently running...
and you'll probably have to upgrade (if you have a 3494), your atldd  lslpp
-l | grep atldd
download
read the readme(s)
etc...
make reado all the filling tapes...
verify that your drive format is drives
rename stgpools is fun...
move data from old tapes to new tapesto force a conversion...
high level stuff..

-Original Message-
From: brian welsh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 2:00 PM
To: [EMAIL PROTECTED]
Subject: Upgrade from 3590B to 3590E


Hello,

AIX 4.3.3, TSM 4.1.0.0

Within two weeks we are upgrading from 3590B to 3590E, and from two to three
drives. Before we have to upgrade our Atape drivers on AIX. We never done
this before.

Is there anyone who was in this proces lately and can tell me the sequence
of the proces. Besides any good tips and trics are very welcome?

Thanks,

Brian.


_
MSN Foto's is de eenvoudigste manier om je foto's te delen en af te drukken:
http://photos.msn.nl/Support/WorldWide.aspx

Re: TSM 4.2.1 Client Error

[Williams, Tim P {PBSG}]

I have seen this too. I have brought this to support, but haven't gotten too
far on
problem resolution or acceptance.
**
Can you remember, if during your install, that you didn't have some
component of html...
and you selected yes...to go ahead and install it...(during the
install/upgrade of your
tsm client).
Thanks

-Original Message-
From: Sutch, Ian (London) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 8:11 AM
To: [EMAIL PROTECTED]
Subject: TSM 4.2.1 Client Error


Hi,

We have recently installed Version 4.2.1.22 to a Windows NT client.
The scheduled backups run ok, however when you run dsm.exe locally we get
the following error:

Error
Error Initializing the cache, Shutdown all programs and run scandisk or
chkdsk. Delete the cache, cookies and history directories in your windows
directory and then restart IE. If the problem persists reinstall IE

Has anyone seen this?

Thanks

NT registry

[Williams, Tim P {PBSG}]

We don't backup everything on boxes. Traditionally we backup data only...d
drives and the like.
So, our include/excludes in the dsm.opt are like:
exclude *
include d:\...\*
>From the manual, backupregistry is a default of yes.
Also, it backs up the registry to another locationadsm.sys??
I thought it would have backed it up, regardless of the includes/excludes,
but I believe I'm finding
otherwise.
We will be moving to backup entire machines for bare metal recovery (using
TSM only), so this may become
a moot point for us.
I do have a problem ticket open just to understand if this is a bug or not,
so I can share ibm/tivoli's response.
**
Anyone have additional info to share on this topic?
Thanks in advance.

Select statement I'm using in my testing:
tsm: ADSM>select * from backups where node_name='US504S0J' and
hl_name='\ADSM.SYS\REGISTRY\US504S0J\MACHINE\'

ANR2963W This SQL query may produce a very large result table, or may
require a
significant amount of time to compute.

Do you wish to proceed? (Yes (Y)/No (N)) y

  NODE_NAME: US504S0J
 FILESPACE_NAME: \\us504s0j\c$
   FILESPACE_ID: 1
  STATE: ACTIVE_VERSION
   TYPE: FILE
HL_NAME: \ADSM.SYS\REGISTRY\US504S0J\MACHINE\
LL_NAME: SAM
  OBJECT_ID: 296815135
BACKUP_DATE: 2002-03-18 17:18:02.00
DEACTIVATE_DATE:
  OWNER:
 CLASS_NAME: DEFAULT


-

Re: Experience with XP dsm.opt entries

[Williams, Tim P {PBSG}]

We put in our first and are having an issue with the includebut
haven't researched further.
the include isn't picking up what we expectwe have to include everything
(exclude nothing) to get what we want backed up currently.

-Original Message-
From: Adams, Matt (US - Hermitage) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 9:22 AM
To: [EMAIL PROTECTED]
Subject: Experience with XP dsm.opt entries


Anyone have any experience or suggestions for XP workstations dsm.opt file
entries??

Thanks,

Matt
- This message (including any attachments) contains confidential information
intended for a specific individual and purpose, and is protected by law.  -
If you are not the intended recipient, you should delete this message and
are hereby notified that any disclosure, copying, or distribution of this
message, or the taking of any action based on it, is strictly prohibited.

Re: How do we change which nic on a client adsm contacts?

[Williams, Tim P {PBSG}]

If you have multiple NIC cards and your networks are such that it can get to
TSM via
both routes, then you can't guarentee which nic will be used...probably the
first
nic on the bus.
If due to routing...there's only one "path" for a client to reach the tsm
server, then
there you have it...

-Original Message-
From: Malbrough, Demetrius [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 4:14 PM
To: [EMAIL PROTECTED]
Subject: Re: How do we change which nic on a client adsm contacts?


-Brief Thought

Did you try adding/changing ip address using the options in the dsm.sys
file:

TCPCLIENTAddress 19.1.12.134
TCPCLIENTPort1502

-Regards,

Demetrius Malbrough
UNIX/TSM Administrator

-Original Message-
From: TSM Group [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 4:04 PM
To: [EMAIL PROTECTED]
Subject: How do we change which nic on a client adsm contacts?


Hello all,
We recently thought we would try to change which NIC one of our nodes' uses
to do backups.
>From what I'd been able to find on the adsm message boards out there, it
looked as if ADSM, when initially contacted by a node, traps the IP address
that the node uses and stores that information untill contacted by that node
on a different IP address.
So when we were finally able to we downed the primary NIC and restarted the
dsmc sched process . ( Thinking was that the client would contact adsm with
the desired IP address and that would then be trapped and everything would
be fine. )
But it did not work.
Does anyone have any ideas?!


_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

Re: Multiple TSM Servers on Same Machine

[Williams, Tim P {PBSG}]

We share 1 3494 between 2 tsm environments (on different aix boxes...).
We use different scratch categories and private categories, yes...
although we aren't library sharing as far as TSM is concerned.


-Original Message-
From: Jim Sporer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 4:16 PM
To: [EMAIL PROTECTED]
Subject: Multiple TSM Servers on Same Machine


I am in the process of setting up a second TSM server on the same
machine.  I was curious if there are others doing that with a 3494
ATL.  From what I can tell you can share the 3494 atl  resources between
the two servers, meaning the tapes and the drives by specifying a
primarylibrarymanager.   Do you use the same scratch and private categories
for the tapes used by both servers?
Jim Sporer

Re: Delete filespace issue with Server v4.2.1.6?

[Williams, Tim P {PBSG}]

The one delete I don't think I saw tried
delete filespace winnode \\winnode\e$
try

-Original Message-
From: David Longo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 9:54 AM
To: [EMAIL PROTECTED]
Subject: Re: Delete filespace issue with Server v4.2.1.6?


If you are trying to delete an entire filespace, then I have a suggestion.
With apologies to Andy Raibeck, sometimes "The Web Admin is
your friend."

On the Web Admin select from the left side "Objects", then "Clients",
then "Filespaces".  A list of all filespaces is then displayed in main
window.

Scroll down to the one you want, and select the filespace name.
>From that window pull down "operations" and select "Delete file space".

This is simpler than remebering the exact syntax for filespace names
escpecially if you have many different platforms etc.

David Longo

>>> [EMAIL PROTECTED] 03/14/02 10:40AM >>>
Dale, yes, I have seen this.  The problem is with unicode support.  Do
'help q fi' and 'help del fi' to see the new parameters that may be
required.
For instance, here is a 'q fi' of my own machine (winxp, client 4.2.1.26,
server at 4.2.1.9).
Note the namet parameter and see what happens without it.

tsm: NEW_ADSM_SERVER_ON_PORT_1600>q fi wfc1450 "\\wfc1450\c$" namet=uni f=d

  Node Name: WFC1450
 Filespace Name: \\wfc1450\c$
 Hexadecimal Filespace Name: 5c5c776663313435305c6324
   FSID: 17
   Platform: WinNT
 Filespace Type: NTFS
  Is Filespace Unicode?: Yes
  Capacity (MB): 28,058.8
   Pct Util: 33.9
Last Backup Start Date/Time: 03/13/2002 21:01:44
 Days Since Last Backup Started: 1
   Last Backup Completion Date/Time: 03/13/2002 21:03:10
   Days Since Last Backup Completed: 1
Last Full NAS Image Backup Completion Date/Time:
Days Since Last Full NAS Image Backup Completed:


tsm: NEW_ADSM_SERVER_ON_PORT_1600>q fi wfc1450 "\\wfc1450\c$" f=d
ANR2034E QUERY FILESPACE: No match found using this criteria.
ANS8001I Return code 11.

You can delete by fsid now, this may be what you want.


Hope this helps,

Bill Colwell

At 08:24 AM 3/14/2002 -0500, you wrote:
>Has anyone seen this on 4.2.1.6, or am I just sleep-deprived?
>Server is on AIX 4.3 ...
>Neither query nor delete will match a file system name
>
>
>
>tsm:ADSM>q filespace WINNODE
>
>Node Name   Filespace   FSID Platform Filespace Is Files- Capacity
Pct
>Name  Typepace(MB)
Util
>Unicode?
>--- ---   - - 
-
>WINNODE  \\WINNODE\c$1 WinNTNTFS Yes17,233.8
19.6
>WINNODE  \\WINNODE\d$2 WinNTNTFS Yes184,260.
22.2
> 9
>WINNODE  \\WINNODE\e$3 WinNTNTFS Yes17,273.0
62.6
>WINNODE  \\WINNODE\f$4 WinNTNTFS Yes17,273.0
17.1
>WINNODE  SYSTEM 5 WinNTSYSTEM   Yes 0.0
0.0
> OBJECT
>
>tsm: ADSM>dele filespace WINNODE \\WINNODE\e*
>ANR0852E DELETE FILESPACE: No matching file spaces found for node WINNODE.
>ANS8001I Return code 11.
>
>tsm: ADSM>dele filespace WINNODE \\WINNODE\e$*
>ANR0852E DELETE FILESPACE: No matching file spaces found for node WINNODE.
>ANS8001I Return code 11.
>
>tsm: ADSM>dele filespace WINNODE \\WINNODE\e
>ANR0852E DELETE FILESPACE: No matching file spaces found for node WINNODE.
>ANS8001I Return code 11.
>
>tsm: ADSM>dele filespace WINNODE WINNODE\e*
>ANR0852E DELETE FILESPACE: No matching file spaces found for node WINNODE.
>ANS8001I Return code 11.
>
>tsm: ADSM>dele filespace WINNODE WINNODE\e$*
>ANR0852E DELETE FILESPACE: No matching file spaces found for node WINNODE.
>ANS8001I Return code 11.
>
>tsm: ADSM>dele filespace WINNODE WINNODE\e
>ANR0852E DELETE FILESPACE: No matching file spaces found for node WINNODE.
>ANS8001I Return code 11.
>
>tsm: ADSM>dele filespace WINNODE e*
>ANR0852E DELETE FILESPACE: No matching file spaces found for node WINNODE.
>ANS8001I Return code 11.
>
>tsm: ADSM>dele filespace WINNODE e$*
>ANR0852E DELETE FILESPACE: No matching file spaces found for node WINNODE.
>ANS8001I Return code 11.
>
>tsm: ADSM>dele filespace WINNODE e
>ANR0852E DELETE FILESPACE: No matching file spaces found for node WINNODE.
>ANS8001I Return code 11.

--
Bill Colwell
C. S. Draper Lab
Cambridge Ma.


"MMS " made the following
 annotations on 03/14/02 11:07:45

--
This message is for the named person's use only.  It may contain
confidential, propriet

Re: Problems with latest Windows client

[Williams, Tim P {PBSG}]

Have you taken your problems to Tivoli, so they'll have a chance to be
addressed...?

-Original Message-
From: Steven Bridge [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 7:02 AM
To: [EMAIL PROTECTED]
Subject: Problems with latest Windows client


We have just started installing the latest Windows client 4.2.1.20
on 'new' Windows 2000 machines and and have come across a number of
problems and peculiarities.

I saw just recently on the list that there is a new patch level 4.2.1.26
but looking at the 'IP22373 26 READ1STC.TXT' it doesn't include any
additional APARS than the README for 4.2.1.20.
Can anyone tell me what fixes are included in this other than
IC32797 which addresses memory problems ?

4.2.1.20 has been running OK on a couple of machines - but another
is having trouble backing up the system object. The client scheduler
initiated by the Client Acceptor service was being started at the
appropriate time but was dying and being restarted every 10 minutes
only to die again. 'q files' on the server indicated that the system
object was being backed up every 10 mins. I removed 'domain systemobject'
from the opt file and this worked fine.
So I tried backing it up via the GUI and went through each system object
in turn ( COM+DB and Event Log had backed up OK via the scheduler
according to restore info ) Registry and RSM were OK but 'System Files'
caused the GUI to die. I couldn't find any error messages either in the
Event Viewer or in dsmerror.log.

Previously we had assumed that the registry was always backed up with
the incremental command - and the documentation implies the option
'backupregistry=yes' is the default when the system disk is being backed up.
Even when supplied it appears to have no effect.
We've found that this is no longer the case in the 4.2 client - hence the
'domain systemobject' line now being in our revised basic opt file.

Playing around with the GUI preference editor, I noticed that changing
the drives that you wish to backup also had the unfortunate consequence
of removing 'systemobject' from an existing domain line even though
the registry backup box was ticked ( Presumably this just affects the
backupregistry setting which as I've said above appears to be ignored ).

So moving to this new version has not been the easy ride I had hoped.
I'm reluctant to stay with 4.1 but so far not so good.

+--+
 Steven Bridge Systems Group, Information Systems, EISD
  University College London
 email: [EMAIL PROTECTED]   tel: +44 (0)20 7679 2794

Re: SQL command

[Williams, Tim P {PBSG}]

whoops I didn't read the whole request.
Mind you, this select command is going to give you what mgmtclases are
available to each of the nodes...

so:
tsm: ADSM>select nodes.node_name, mgmtclasses.class_name from nodes,
mgmtclasses where nodes.do  main_name=mgmtclasses.domain_name

NODE_NAME  CLASS_NAME
-- --
BFLOYD 10_DAY_RETENTION
BFLOYD 30_DAY_RETENTION
BFLOYD 5_DAY_RETENTION
BFLOYD 60_DAY_RETENTION
BFLOYD 90_DAY_RETENTION

-Original Message-
From: Prather, Wanda [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 2:44 PM
To: [EMAIL PROTECTED]
Subject: Re: SQL command


Do you mean by domain? Nodes don't have management classes, files do

-Original Message-
From: Wholey, Joseph (TGA\MLOL) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 3:40 PM
To: [EMAIL PROTECTED]
Subject: SQL command


Looking for an SQL command that will show me nodes by management class.  Can
anyone help?

Regards,
Joe Wholey
TGA Distributed Data Services
Merrill Lynch
Phone: 212-647-3018
Page:  888-637-7450
E-mail: [EMAIL PROTECTED]

Re: SQL command

[Williams, Tim P {PBSG}]

from the command
select * from syscat.tables
you can find a table called:
TABSCHEMA: ADSM
   TABNAME: MGMTCLASSES
   CREATE_TIME: 1996-04-25 14:31:19.025065
  COLCOUNT: 12
INDEX_COLCOUNT: 3
  UNIQUE_INDEX: TRUE
   REMARKS: Management classes

then you can do:
tsm: ADSM>select * from syscat.columns where tabname='MGMTCLASSES'

and from that you can see/find a column name called:
   TABSCHEMA: ADSM
 TABNAME: MGMTCLASSES
 COLNAME: CLASS_NAME

then you can do (your answer):
tsm: ADSM>select class_name from mgmtclasses

CLASS_NAME
--
10_DAY_RETENTION
30_DAY_RETENTION
5_DAY_RETENTION
60_DAY_RETENTION
90_DAY_RETENTION

etc...




-Original Message-
From: Wholey, Joseph (TGA\MLOL) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 2:40 PM
To: [EMAIL PROTECTED]
Subject: SQL command


Looking for an SQL command that will show me nodes by management class.  Can
anyone help?

Regards,
Joe Wholey
TGA Distributed Data Services
Merrill Lynch
Phone: 212-647-3018
Page:  888-637-7450
E-mail: [EMAIL PROTECTED]

Re: Licencing. (and pricing)(and support)

[Williams, Tim P {PBSG}]

A note on ibmlink vs tivoli for problem input.
It goes to the same database...just different front ends.
I found and spoke with the internet strategist for tivoli support
and showed him ibmlink. IBMLINK if far superior. I believe the reason
for the tivoli front end is that there's no ibmlink administrator, per se.
my nickel's worth.

-Original Message-
From: Del Hoobler [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 1:25 PM
To: [EMAIL PROTECTED]
Subject: Re: Licencing. (and pricing)(and support)


>>And WHY do I have to call a DIFFERENT sales person for Tivoli software
than
>>IBM software?
>>
>> It's a different company.

Actually, that is not true.  Tivoli is NOT a different company.
We are all IBM.  "Tivoli software" is a part of IBM Software Group.
As far as the issues with service... I am trying to get
a more definitive answer from the service team (I am development)
but I think it's just a different way to route the incoming calls
and do proper product entitlement. If I get more details, I will
certainly pass them on.

Thanks,

Del



Del Hoobler
IBM Corporation
[EMAIL PROTECTED]

"Celebrate we will. Life is short but sweet for certain..."  -- Dave

Re: what happen !

[Williams, Tim P {PBSG}]

check your dsmserv.opt for any hints of trace being invoked

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 7:05 PM
To: [EMAIL PROTECTED]
Subject: what happen !


What error is " Trace/BPT trap " error !

# dsmserv
ANR7800I DSMSERV generated at 12:27:22 on Aug 29 2001.

Tivoli Storage Manager for AIX-RS/6000
Version 4, Release 2, Level 1.0

Licensed Materials - Property of IBM

5698-TSM (C) Copyright IBM Corporation 1999,2001. All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.

ANR0900I Processing options file dsmserv.opt.
ANR0990I Server restart-recovery in progress.
ANR0200I Recovery log assigned capacity is 128 megabytes.
ANR0201I Database assigned capacity is 1016 megabytes.
ANR0306I Recovery log volume mount in progress.
ANR0353I Recovery log analysis pass in progress.
ANR0354I Recovery log redo pass in progress.
ANR0355I Recovery log undo pass in progress.
ANR0352I Transaction recovery complete.
ANR2100I Activity log process has started.
Trace/BPT trap(coredump)

Re: DB reorg & Audit

[Williams, Tim P {PBSG}]

   Total run time probably 4 to 10 hours. Depends on number of database
entries, entries per table, processor horsepower and some other
things.


[spdo11][/usr/tivoli/tsm/server/bin]>date
Thu Jul  5 13:15:06 CDT 2001
[spdo11][/usr/tivoli/tsm/server/bin]>

[spdo11][/flhome/tquall]>more timtmp
ANR4039I LOADDB: Loaded 137,887,687 database entries (cumulative).
ANR1365I Volume 95 closed (end reached).
ANR4032I LOADDB: Copied 3990518 database records.
ANR4033I LOADDB: Copied 2276 bit vectors.
ANR4035I LOADDB: Encountered 0 bad database records.
ANR4036I LOADDB: Copied 137,927,180 database entries.
ANR4037I LOADDB: 9269 Megabytes   copied.
ANR4004I LOADDB: Database load process completed.
ANR4404I LOADDB: Loaded a consistent dump image - a database audit (AUDITDB)

is NOT required.
ANR2106I : Quiescing database update activity.
ANR2107I : Database update activity is now quiesced.
ANR8468I 3590 volume 95 dismounted from drive DSN0C4602 (/dev/rmt3) in
library MANUALLIB.
started about 13:50.Thu Jul  5 17:31:27 CDT 2001


-Original Message-
From: Luscombe John (HS) [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 8:04 AM
To: [EMAIL PROTECTED]
Subject: DB reorg & Audit


Hi TSM folks,

We are running TSM V4 R2 L1.9 on an RS6K with AIX 4.2.1.9, the DB is 17,900
MB and is about 76% full. The machine is a 2 processor WinterHawk (I think).

I'm new to TSM, but I'm wondering if someone can give me an estimate on how
long a DB reorg would run for.

The follow on question to this is that the documentation implies an Audit of
the DB would also be required. Does anyone have experience that this is
definite? Also, how long would an Audit take? My colleague who is the lead
for TSM says that IBM have not been able to give any indication, and we've
heard figures ranging from hours to weeks.

TIA

John.

Re: occupancy by date

[Williams, Tim P {PBSG}]

Select * from backups where node_name='your TDP servername'
check the output...


-Original Message-
From: Coviello, Paul [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 8:52 AM
To: [EMAIL PROTECTED]
Subject: occupancy by date


Hi

We are backing up exchange and as previously mentioned keeping at
least a years worth! :-(
well back in December we put the delete command in at 365, anyways I
don't believe it is working.
It was at 9.3 TB then and is currently at 10.8 TB.  is there a way
to see if it is in fact deletinganything, by issuing a by date
command.

we are running TSM 4.1.3 and TDP 1.1  even though we have the 2.2.

thanks
Paul

Paul J Coviello
Sr Systems Analyst
Catholic Medical Center
2456 Brown Ave
Manchester, NH 03103
603 663-5326

Re: How to use string operators in select statement - TSM.

[Williams, Tim P {PBSG}]

The server numbers should be unique (for the most part).
you can also try
select * from actlog where msgno=2565

-Original Message-
From: Allen Barth [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 4:44 PM
To: [EMAIL PROTECTED]
Subject: Re: How to use string operators in select statement - TSM.


I think this is what you want:

Select * from actlog where left(message,10)='ANR2565I'

Regards,
Al




mobeenm <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
02/28/02 03:21 AM
Please respond to "ADSM: Dist Stor Manager"


To: [EMAIL PROTECTED]
cc:
Subject:Re: How to use string operators in select statement
- TSM.


Sree Kumar,
Its absolutely possiblem to do that. Try the following

select * from actlog where message like 'ANR2565I%'

I think this should do the trick. Hope the climate in Bangalore is good
:-)

Regards
Mobeen

Mobeen Mahamood C.M
Systems Manager Lead
Micron Semiconductor Asia
Singapore





> -Original Message-
> From: Pothula S Paparao [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 28, 2002 5:15 PM
> To: [EMAIL PROTECTED]
> Subject: How to use string operators in select statement - TSM.
>
>
> Hi TSM'ers
> The below is the message from select output (select * from actlog)
> All I want to know is whether or not possible to caputue only
> the message
> no (ex. ANR2565I) using select query. I tried using string
> operations in
> select command. didnt help much. If any select expert tried
> this pls let me
> know. Im very much intrested to know about it.
>
> Thanks in advance.
>
>
> DATE_TIME: 2001-12-30 00:00:02.00
> MSGNO: 2565
>  SEVERITY: I
>   MESSAGE: ANR2565I 0 schedules for immediate client actions have been
> deleted.
>
>
> Regards
>
> Sreekumar.
> SO
> IBM Singapore.
> Phone : 65-8402634
>






*** PLEASE NOTE ***
This message, along with any attachments, may be confidential or legally
privileged.  It is intended only for the named person(s), who is/are the
only authorized recipients. If this message has reached you in error,
kindly destroy it without review and notify the sender immediately. Thank
you for your help.
**

Re: TSM 4.2.1.9 on Win NT, insufficient number of mount points

[Williams, Tim P {PBSG}]

I believe that there's a mount point processing issue at 4.2.1.9.
There is, but I haven't checked, a fix for this in 4.2.1.11
We were having processes preempted due to some mount point issues
We will be going to 4.2.1.11 this Sunday. 
FYI

-Original Message-
From: Þórður Aðalsteinsson [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 02, 2002 6:27 PM
To: [EMAIL PROTECTED]
Subject: TSM 4.2.1.9 on Win NT, insufficient number of mount points


Hi y´all

I am installing TSM 4.2.1.9 on Win NT, I have a Dell PowerVault 128T
library.

My problem is that when migrating from disk to tape I get this right away,
ANR0984I Process 28 for MIGRATION started in the BACKGROUND at 23:20:49.
ANR1000I Migration process 28 started for storage pool DISKPOOL.
ANR1134W Migration terminated for storage pool DISKPOOL - insufficient
number
of mount points available for removable media.
ANR0985I Process 28 for MIGRATION running in the BACKGROUND completed with
completion state FAILURE at 23:20:49.
ANR1002I Migration for storage pool DISKPOOL will be retried in 60 seconds.
ANR1003I Migration retry delay ended; checking migration status for storage
pool DISKPOOL.

However im able to label and checkin volumes without any problems

I have changed the mount limit from drives to 2 (update dev ltoclass1
libr=lb0.0.0.2 devtype=lto mountlimit=2). That changed nothing

My feeling is that im overlooking somthing in the config of the library or
drives

I also have a newer version of firmware then the one tested with TSM. 

Would changing OS´s do anything, go to W2K?

Best regards



 

Þórður Aðalsteinsson

MCSE, MCP+I

Margmiðlun Internet, Fyrirtækjaþjónusta

Suðurlandsbraut 4

105, Reykjavík

Sími 575 7000

e-mail: [EMAIL PROTECTED]

www.mi.is

 

 

Re: Server-side scripting: not supported?

[Williams, Tim P {PBSG}]

OK, a little deeper...
we have 5 groups of stg areas, basically...
Since TSM doesn't give you a good way to "control" (wait=yes is good with
move data, but there's
nothing for, say, migration) the movement from disk to tape we HAVE to use
move data commands...
We have over 100 disk vols.
We simultaneously run move datas.
If one area completes then, it goes onto the ba stg.
ALL move datas and ba stgs have to complete (5 general areas) prior to the
db backup, etc
A good scheduler, will get this done with ease. Scripting...that would be
complex.

-Original Message-
From: ARhoads [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 10:17 AM
To: [EMAIL PROTECTED]
Subject: Re: Server-side scripting: not supported?


But, of course, that is the purpose of the script.

- Original Message -----
From: "Williams, Tim P {PBSG}" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 6:18 AM
Subject: Re: Server-side scripting: not supported?


> Even if TSM did support scripting
> it would have to be a much more robust scheduler
> best daily practices (high level)?
> move all backup data that came in to tape and clear disk for the next
> night...
> next but not before...make the vault copy   ba stg
> next after that but not before a db backup (full)
> move drmedia after that...
> etc...
> the scheduler would have to have dependancy ability...
> We use an external scheduler for the administrative functions...
> We use TSMs internal scheduler for scheduling of backup and archives.
>
>
> -Original Message-
> From: ARhoads [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 01, 2002 7:41 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Server-side scripting: not supported?
>
>
> This has been bugging me for a long time as well since it means I have to
> use cron to automate the TSM daily processing rather than TSM's own
> scheduler for administrative commands.  I'd rather schedule TSM daily
> processing inside TSM to make it easier for customers to see everything
TSM
> related from inside the TSM administrative client.
>
> The security issue is bunk.  Other IBM products can access the O.S. just
> fine (like DB2).
>
> Steffan
> - Original Message -
> From: "Seay, Paul" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, February 28, 2002 9:20 PM
> Subject: Re: Server-side scripting: not supported?
>
>
> > This is more of a security issue than anything.  If you allow TSM to
spawn
> > scripts, the child process inherits the same security.  Which is
typically
> > root.  In their glory, they simply said no rather than opening up the OS
I
> > guess.  They definitely are not explaining themselves well.
> >
> > -Original Message-
> > From: Joseph Seigh [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, February 28, 2002 7:31 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Server-side scripting: not supported?
> >
> >
> > Quoting Ted Byrne <[EMAIL PROTECTED]>:
> > > Has anyone received a similar response from TSM support in the past?
> > > We are working on an issue with a process running for a very long
> > > time, and received the following as part of the response from TSM
> > > support:
> > >
> > >  [W]as that the
> > >  run-time of a specific backup process, or was
> > >  that the run-time of the entire script.
> > >
> > >  Since we do not support scripts, I need to verify
> > >  that this problem is not your script. Try running
> > >  each command in your script manually.
> > >
> > > The specific instance was a storagepool backup that was still running
> > > a day later, parked on a 16+ GB file.  The storagepool  backup was
> > > tape to tape; the drives are on separate, dedicated SCSI adapters.
> > >
> > > TSM Server is Win2k,
> > > TSM version 4.2.1.0,
> > > IBM 3583 Library
> > >
> >
> > TSM does not support scripting. I assumed at one point that meant the
> > scripts per se, but no it's scripting.  I tried to pin down the precise
> > definition of scripting since in unix everything runs from a shell more
or
> > less, with an
> > exec() system call, and with some tty and enviroment restrictions
applied.
> > No, just sh, ksh, and csh  (the standard shells) from the command line.
> >
> > It doesn't say much for TSM that they cannot even state what their
command
> > runtime environment should be, and that they impose arbitrary
restrictions
> > on their command usage instead.
> >
> > Joe Seigh

Re: Undocumented messages - Convert archive?

[Williams, Tim P {PBSG}]

I'm one level back, but try on a server, admin command line
help anrmsg#   like help anr4392i

tsm: ADSM>help anr4389i

---

ANR4389I Expiration process cancelled.

Explanation: The CANCEL EXPIRATION command was issued and successfully
cancelled the current process.

System Action: Server operation continues.

User Response: None.

-Original Message-
From: Stumpf, Joachim [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 5:42 AM
To: [EMAIL PROTECTED]
Subject: Re: Undocumented messages - Convert archive?


we got the same messages in our environment (TSM Server on OS/390)...
it would be nice if someone can shed some light into this ...

-- 
regards / Mit freundlichen Gruessen
Joachim Stumpf
Datev eG
Nuremberg - Germany
  

Alexander Verkooyen <[EMAIL PROTECTED]> (Freitag,  1. März 2002, 12:16:01,
CET):

> Hello,
> 
> Yesterday we got some undocumented messages in
> our server (4.2.1.11, AIX 4.3.3) activity log.
> One of clients (4.2.1.20, Windows NT) finished
> it's backup and then these messages appeared:
> 
> 02/28/02   10:42:34  ANR0984I Process 282 for CONVERT ARCHIVE started in
> the
>   BACKGROUND at
> 10:42:34.
> 02/28/02   10:42:35  ANR4392I Audit of the Arch.Description.Objects
> table for
>   NODEBLAH completed (0):  found 0 directories and
> files
>   (0 inserted prior to Version 3), 0 object sets.
> Deleted:
>   0 directories and files, and 0 object
> sets.
> 02/28/02   10:42:35  ANR4393I Audit of the Description table for
> NODEBLAH
>   completed (0):  found 0 descriptions, 0
> directories and
>   files (0 inserted prior to Version 3), 0 object
> sets.
>   Deleted: 0 descriptions, 0 directories and files,
> and 0
>   object
> sets.
> 02/28/02   10:42:35  ANR4394I Audit with the archive table for
> NODEBLAH
>   completed (0).  The description tables have 0
> directories
>   and files, 0 object sets. Inserted: 0 directories
> and
>   files, and 0 object
> sets.
> 02/28/02   10:42:35  ANR0911I Conversion for NODEBLAH completed
> (successful).
>The description tables have 0 directories and
> files, 0
>   object sets.  Conversion inserted 0 directories
> and
>   files, and 0 object
> sets.
> 02/28/02   10:42:35  ANR0985I Process 282 for CONVERT ARCHIVE running in
> the
>   BACKGROUND completed with completion state SUCCESS
> at
> 
> 10:42:35.
> 
> ANR4392I, ANR4393I and ANR4394I are listed in the messages manual
> as "Messages not appearing in this publication"
> ANR09841I and ANR0985I are documented, but they just tell
> that a process has been started and has been completed.
> 
> Does anybody if we should be worried or can
> we just ignore these undocumented messages?
> 
> TIA,
> 
> Alexander
> --
> ---
> Alexander Verkooijen([EMAIL PROTECTED])
> Senior Systems Programmer
> SARA High Performance Computing
> 

Re: Server-side scripting: not supported?

[Williams, Tim P {PBSG}]

Even if TSM did support scripting
it would have to be a much more robust scheduler
best daily practices (high level)?
move all backup data that came in to tape and clear disk for the next
night...
next but not before...make the vault copy   ba stg
next after that but not before a db backup (full)
move drmedia after that...
etc...
the scheduler would have to have dependancy ability...
We use an external scheduler for the administrative functions...
We use TSMs internal scheduler for scheduling of backup and archives.


-Original Message-
From: ARhoads [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 7:41 AM
To: [EMAIL PROTECTED]
Subject: Re: Server-side scripting: not supported?


This has been bugging me for a long time as well since it means I have to
use cron to automate the TSM daily processing rather than TSM's own
scheduler for administrative commands.  I'd rather schedule TSM daily
processing inside TSM to make it easier for customers to see everything TSM
related from inside the TSM administrative client.

The security issue is bunk.  Other IBM products can access the O.S. just
fine (like DB2).

Steffan
- Original Message -
From: "Seay, Paul" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 28, 2002 9:20 PM
Subject: Re: Server-side scripting: not supported?


> This is more of a security issue than anything.  If you allow TSM to spawn
> scripts, the child process inherits the same security.  Which is typically
> root.  In their glory, they simply said no rather than opening up the OS I
> guess.  They definitely are not explaining themselves well.
>
> -Original Message-
> From: Joseph Seigh [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 28, 2002 7:31 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Server-side scripting: not supported?
>
>
> Quoting Ted Byrne <[EMAIL PROTECTED]>:
> > Has anyone received a similar response from TSM support in the past?
> > We are working on an issue with a process running for a very long
> > time, and received the following as part of the response from TSM
> > support:
> >
> >  [W]as that the
> >  run-time of a specific backup process, or was
> >  that the run-time of the entire script.
> >
> >  Since we do not support scripts, I need to verify
> >  that this problem is not your script. Try running
> >  each command in your script manually.
> >
> > The specific instance was a storagepool backup that was still running
> > a day later, parked on a 16+ GB file.  The storagepool  backup was
> > tape to tape; the drives are on separate, dedicated SCSI adapters.
> >
> > TSM Server is Win2k,
> > TSM version 4.2.1.0,
> > IBM 3583 Library
> >
>
> TSM does not support scripting. I assumed at one point that meant the
> scripts per se, but no it's scripting.  I tried to pin down the precise
> definition of scripting since in unix everything runs from a shell more or
> less, with an
> exec() system call, and with some tty and enviroment restrictions applied.
> No, just sh, ksh, and csh  (the standard shells) from the command line.
>
> It doesn't say much for TSM that they cannot even state what their command
> runtime environment should be, and that they impose arbitrary restrictions
> on their command usage instead.
>
> Joe Seigh

Re: 3583 LTO problems

[Williams, Tim P {PBSG}]

Yes, it seems like a nightmare story. What drives were those...984x?

-Original Message-
From: Mark Bertrand [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 11:25 AM
To: [EMAIL PROTECTED]
Subject: FW: 3583 LTO problems


If you are using the 3583 with Windows 2000 do not let the hardware guys
upgrade your tape drive firmware to 18N2, there is a know issue that is not
communicated between the Hardware and Software folks.

Our nightmare started with a physical bad tape drive. A new drive was
ordered and installed by the CE. Since the new drive came with the latest
firmware it caused I/O errors and kept going offline. The problem was
thought to be another bad drive from factory so it was replaced again, again
the new drive came in with the new (bad) firmware. The CE called IBM
support, their answer "it must be the out of date firmware on the other
remaining three drives, upgrade all firmware" things went downhill from
there.
My story now goes into week two,.. after all firmware upgraded, SCSi cables
changed, drives swapped, all drives now giving I/O errors all the time
marking tapes as unavailable causing I/O errors making a real mess that we
are still working through. Enter the "TopGun" 3583 guy who gets on the phone
with Tivoli level 2 support who tells him that firmware 18N2 and windows
2000 have "known" issues. Downgrade firmware to 16E0 on all drives, problem
fixed..., cleanup starts.

This is a true store, no names have been changed to protect the innocent.

BTW, we have had the problems you are mentioning. Thanks Kelly for your
suggestion, we will implement it as soon as we get everything straightened
out.

Mark Bertrand



-Original Message-
From: Sam Schrage [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 9:23 AM
To: [EMAIL PROTECTED]
Subject: 3583 LTO problems


Any one have a problem with TSM auditing a LTO 3583 library.   Some of my
tapes
are missing but when I open the door of the library I see all the tape slots
full.   I use the I/O door to input tapes only as SCRATCH so all tapes in
the
library should be known to TSM as SCRATCH or PRIVATE.

When the 3583  reinitializes after the door is open sometime it sees the
magazines in the door...sometimes not.   I think it's more a hardware
problem
than TSM...until the hardware sees the tapes correctly TSM won't.

Any ideas.   Call has been logged to hardware support.


Sam Schrage
TRW Systems
615-360-4716

Re: Restore Database with a 3494 library

[Williams, Tim P {PBSG}]

It is a software bug that you have to be required to use libtype=manual...
tivoli will be fixing this.

-Original Message-
From: Fred Johanson [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 24, 2002 10:47 PM
To: [EMAIL PROTECTED]
Subject: Fwd: Re: Restore Database with a 3494 library


This has come up a number of times recently.  To repeat what the Tivoli
support
person told me when I ran into in real life, I should keep another version
of
my devconfig file handy in which the 3494 definition is replaced by
   DEF LIBrary tsmlib libtaype=manual.
When a DB restore is necessary in either V3R7 or V4R1, use the special
devconfig file, mount the backup tape(s) manually with mtlib etc, and run
the
restore.  After the restore, whcih seems to be completed when the system
actually does the commit (I guess that tells it when it's done), switch back
to
the reguylar devconfig file and bring up the system.


Quoting Farren Minns <[EMAIL PROTECTED]>:

> Hi TSMers
>
> Running TSM 3.7.3.8 on Solaris 2.7 attached to two 3590 drives housed in a
> 3494 automated library.
>
> This is not something I am having to do at the moment, but something that
I
> want to get clear in case the need arrises. Let's assume the database is
> corrupt and I cannot sign on to the TSM server. I need to issue the dsmc
> restore db from the command line.
>
> Baring in mind the device configuration below, what is the correct syntax
I
> should use? Also, what does the commit=yes/no option mean? The reason I
> ask, is that I'm not sure If I need to manually change the state of the
> drive to manual or something before issuing the command.
>
> This may be a bit vague, and if so please let me know any other
information
> you require.
>
> Thanks ever so much in advance.
>
> Kind Regards
>
> Farren Minns
> Trainne Solaris System and TSM admin - John Wiley & Sons
>
> /* Device Configuration */
> DEFINE DEVCLASS 3590CLASS1 DEVTYPE=3590 FORMAT=DRIVE MOUNTLIMIT=DRIVES
> MOUNTWAIT=60 MOUNTRETENTION=2 PREFIX=ADSM LIBRARY=3494A
> SET SERVERNAME SERVER1
> DEFINE LIBRARY 3494A LIBTYPE=349X DEVICE=3494a PRIVATECATEGORY=300
> SCRATCHCATEGORY=301
> DEFINE DRIVE 3494A DRIVE1 DEVICE=/dev/rmt/3stc ONLINE=Yes
> DEFINE DRIVE 3494A DRIVE2 DEVICE=/dev/rmt/5stc ONLINE=Yes
>



- End forwarded message -


Fred Johanson

Re: select staetment

[Williams, Tim P {PBSG}]

the
events table
 TABSCHEMA:
ADSM   TABNAME: EVENTS  
CREATE_TIME: 1996-04-25 14:31:19.025065 
COLCOUNT: 8INDEX_COLCOUNT: 1  UNIQUE_INDEX:
FALSE   REMARKS: Scheduled Event
Results

  -Original Message-From: Jane Bamberger
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 21,
  2002 8:17 AMTo: [EMAIL PROTECTED]Subject: Re: select
  staetment
  I keep 7 days in the actlog - the event
  log must have the data - as you can do a query past one day using begind and
  begint.
  Does anyone know the tables used in the q
  events command?
   
  Jane 
   
  
  Jane Bamberger
  IS Department
  Bassett Healthcare
  607-547-4784
  
-Original Message-From: ADSM: Dist Stor
Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Seay,
PaulSent: Wednesday, February 20, 2002 8:34 PMTo:
[EMAIL PROTECTED]Subject: Re: select
staetment
select * from events where date(actual_start) = '2002-02-19'
 
But, it depends on how long you keep
them.

  
  -Original Message-From: Jane Bamberger
  [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February
  20, 2002 4:26 PMTo: [EMAIL PROTECTED]Subject:
  select staetment
  Hi,
   
  Hopefully someone can help me. I want
  to do a select statement on the events table, but for some reason when I
  do a select - it will only give me todays events. If I do a query with a
  begind of yesterday - I get yesterday's events. 
   
  for example:
  tsm: BASSETT>select * from events
  where date(actual_start)='02/19/2002'ANR2034E SELECT: No match found
  using this criteria
   
  Whereas I can do a q event * *
  begind='02/19/2002'
   
  as see this:
   
  tsm: BASSETT>q event * *
  begind='02/19/2002' Scheduled
  Start  Actual
  Start Schedule Name Node
  Name Status
   - -
  -02/19/02   00:00:00  02/19/02  
  00:02:57  GW1-INCR 
  GW1  
  Completed02/19/02   01:00:00  02/19/02  
  01:15:15  TSI-INCR 
  TSI  
  Completed02/19/02   01:00:00  02/19/02  
  01:01:01  BASSETT01_IN- BASSETT01
  Completed  
  CR02/19/02   01:00:00  02/19/02  
  01:00:10  TESTAPP-INCR 
  TESTAPP  
  Completed02/19/02   01:00:00  02/19/02  
  01:15:17  TRANSDB-INCR 
  TRANSDB  
  Completed02/19/02   01:46:50  02/19/02  
  01:56:46  GISERVER_INCR GISERVER 
  Completed02/19/02   02:00:00  02/19/02  
  02:08:17  TRANSIF_INCR 
  TRANSIF  
  Completed02/19/02   02:00:00  02/19/02  
  02:06:27  STATGW-INCR  
  STATGW   
  Completed02/19/02   03:00:00  02/19/02  
  03:07:11  UTILSRVR-INCR UTILSRVR 
  Completed02/19/02   03:00:00  02/19/02  
  03:01:25  TSTTRANSDB-I- TSTTRANSDB   
  Completed  
  NCR02/19/02   03:20:00  02/19/02  
  03:21:58  MAILHUB-INCR 
  MAILHUB  
  Completed02/19/02   04:00:00  02/19/02  
  04:03:11  ORSRVR-INCR  
  ORSRVR   
  Completed02/19/02   04:00:00  02/19/02  
  04:13:54  BH1-INCR 
  BH1  
  Completed02/19/02   04:00:00  02/19/02  
  04:12:21  TSTTRANSIF-I- TSTTRANSIF   
  Completed  
  NCR02/19/02   05:00:08  02/19/02  
  05:05:15  CWS01-INCR   
  CWS01
  Completed02/19/02   09:20:00  02/19/02  
  09:21:30  MAILHUB-INCR 
  MAILHUB   Failed
   
  Any suggestions? I want to use select
  to do more processing - else I have to parse files.. not a problem - but a
  select would be easier.
   
  Jane
  
  Jane Bamberger
  IS Department
  Bassett Healthcare
  607-547-4784
  
  
  

Re: Help on changing node name

[Williams, Tim P {PBSG}]

If you rename the node...rename node (command)..you should
visit the q filespace...and probably do a rename filespace if your node
that you're renaming is NT...
FYI

-Original Message-
From: Chan, Kien [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 4:19 PM
To: [EMAIL PROTECTED]
Subject: Help on changing node name
Sensitivity: Private


Hi all TSMers. Here is the situation I'm running into. I have to nodes, A
and B with totally different hardware and software configurations (OS). And,
B was already on backup. A will need to be on backup as well. BUT, A will
replace B soon with the node name and IP address change from A to B. In
other words, A will have the node name and IP address information of B and B
will have the node name and IP address of B when changing over. The reason
for the change is for better hardware performance. After the switchover,
node A (initially was B) will keep around for about a month or so. So, my
question is can this be done? If so, how would I accomplish this task? A
step-by-step guide will be great if possible. Worst case scenario, I can
stop the backup on B and delete all filespaces for B of off the server
before the switchover.  A is running on Win2000 and B is running on NT4.0. B
is running 4.2.1.20 B/A client. TSM Server is 4.2.1.0 (NT4 SP6). Any help
will be greatly appreciated. Thank you in advance.

Kien

Re: How do you Shred a document from TSM?

[Williams, Tim P {PBSG}]

some thoughts...
delete archive
delete backup
perhaps delete filesystem
expire inventory
it will not be removed from any of your db backups...
and, I think, scratch tape reuse(how quick are tapes returned to scratch
status...this IS a parm...and
settable...if you reuse tapes quicker than 7 days, then your 7 day old db
backup is not very useful...if
the data is moved around...(migration? reclaimation?).

FYI

-Original Message-
From: Scott Foley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 4:49 PM
To: [EMAIL PROTECTED]
Subject: How do you Shred a document from TSM?


We have the need to be able to completely delete (shred) a document.  Once
shredded, it can't be restored.  I need to be able to remove it from all the
tape pools, disk pools, off site tapes, off site databases, archive tapes
etc.

Is this possible?  If I delete the document from the database (how is this
done), how do I then delete it from the seven backup databases that are
stored off site?  I do not want to wait a week until they are replaced with
new database backup tapes.  Is deleting it from the database enough?  Is
there anyway to get the document off of a tape (or disk pool) once removed
from the database?  Once a tape is assigned to a scratch pool, but not used,
can it be returned to its previous status or is it effectively erased?

Thanks for any help,

Scott Foley
Part time TSM admin

Re: Default Mgment Classes

[Williams, Tim P {PBSG}]

One default mgmt class, per policy domaindoes that answer it?

-Original Message-
From: Marc Lowers [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 10:40 AM
To: [EMAIL PROTECTED]
Subject: Default Mgment Classes


Could someone explain to me why when I mark a new mgment class as default
and I query the other mgement classes they are also marked as default.  I
would of thought you can only have one default mgment class but I guess
not.

Is the latest class I have marked the one that is used?

Marc.

Re: Consolidate TSM servers to one

[Williams, Tim P {PBSG}]

Look at export...import...
on your server...
help export server
help import server
Thanks
Tim

-Original Message-
From: Hagopian, George [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 3:22 PM
To: [EMAIL PROTECTED]
Subject: Consolidate TSM servers to one


Greetings all...

I have a TSM server running 4.1.4 server and I would like to move the whole
database to another running TSM server running 4.2.1. How can I add the
4.1.4 database to the 4.2.1 database and be able to use all the existing
tapes from the 4.1.4 server...I have no problems upgrading the 4.1.4 server
to 4.2.1.
Is there any written documentation on how to do this?

Thanks...
George Hagopian
ICT Group

Re: TSM Backup Script, bytes sent over last session.

[Williams, Tim P {PBSG}]

I like this one that I cooked up:
ANS8000I Server command: 'select date(days(current_date)-1) as "DATA date",
summary.entity, nodes.domain_name, nodes.platform_name, sum(summary.bytes)
as sum_bytes from summary, nodes where summary.entity=nodes.node_name and
summary.activity='BACKUP' and days(current_date)-days(start_time)=1 group by
summary.entity, nodes.domain_name, nodes.platform_name' order by sum_bytes
desc

you can play with backup vs archive data
it will pull all nodes infoprior day...24 hour period...

FYI Thanks Tim


-Original Message-
From: Pétur Eyþórsson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 11:17 AM
To: [EMAIL PROTECTED]
Subject: TSM Backup Script, bytes sent over last session.


I know this has been posted here a hundred times but i would like it wery
mutch if somone nice would send me
a admin script, that displays the amount of data sent thourh the last 24hrs
for nodes?



Kvedja/Regards
Petur Eythorsson
Taeknimadur/Technician
IBM Certified Specialist - AIX
Tivoli Storage Manager Certified Professional
Microsoft Certified System Engineer

[EMAIL PROTECTED]

 Nyherji Hf  Simi TEL: +354-569-7700
 Borgartun 37105 Iceland
 URL:http://www.nyherji.is

Re: PC Magazine Enterprise Backup Article - NO MENTION OF TSM!! W here's the Air Support?

[Williams, Tim P {PBSG}]

I echo Kelly!
Another marketing slip?:
Tivoli used to provide Tivoli Data protection for workgroups (good for bare
metal recovery for NT, windows, from
what I heard).  This product went unsupportedTHEN the pitch for bare
metal recovery was to use/buy...
a pgm/product from The Kernel Group. From what I understand TKG was bought
out by Veritas.
SO, you have a Tivoli web site pitching a product that a competitor owns?
marketing slip
there's a void here that Tivoli should fill, and fast! BARE METAL RECOVERY
I sure would like to here what the marketing folks would have to say about
this one as well!!!

Thanks Tim Williams


-Original Message-
From: Kelly Lipp [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 10:59 AM
To: [EMAIL PROTECTED]
Subject: PC Magazine Enterprise Backup Article - NO MENTION OF TSM!!
Where's the Air Support?


http://www.pcmag.com/article/0,2997,s=1470&a=22041,00.asp

Why in the world would an article like this appear and not have a single
mention of TSM?  Where is the crack marketing team?  We need desperately to
have air support on an issue like this.  The IBM TSM folks who listen hear
should send this up the pipe to the marketing folks.  It is very hard to
sell TSM when the only thing potential customers have heard about is full
backups!

This kept me up all night.  Actually, it wasn't this it was some damn
library/TSM interaction that I was trying to invent.  I eat, sleep and
breath TSM.  Can I have some help please?

Thanks,

Kelly J. Lipp
Storage Solutions Specialists, Inc.
PO Box 51313
Colorado Springs, CO 80949
[EMAIL PROTECTED] or [EMAIL PROTECTED]
www.storsol.com or www.storserver.com
(719)531-5926
Fax: (240)539-7175