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
[pbsxsz00004][/flapps/adsm/adsmlogs]>tail -5 dsmaccnt.log
4,0,ADSM,06/13/2001,09:45:59,PBSXDR00002,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,PBSXAP00001,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,PBSXAP00001,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/yyyy) (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 session....should be
alphabetic...let's make it a length of 10
examples: HTTP IPXSPX NETBIOS NONE SHAREDMEM SNALU6.2
SNMP TCPIP
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 20000 (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 20000 (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
20000 (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 20000 (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 20000 (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 20000 (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 20000 (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.................
-----Original Message-----
From: Fred Zhang [mailto:fred.zhang AT NETIQ DOT COM]
Sent: Monday, October 07, 2002 6:41 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Account log file
Hi TSMer,
Can some one tell me which field of the TSM account log file is the "Bytes
Backed up"?
Thanks
Fred
|