FYI for anyone thats interested.
As far as the licensing, I was trying to license the tdpi.lic. I actually
needed to run the following command:
reg lic file=informix.lic number=1
and Arnaud, your right, a q filespace won't show you anything,
but a q occupancy will actually show you what you have on the server.
q occ AIX1_IFMX ( would be the correct syntax)
________________________________
From: ADSM: Dist Stor Manager on behalf of PAC Brion Arnaud
Sent: Thu 10/7/2004 3:32 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: TDP for Informix anomaly
James,
Regarding your license problem, I have really no clue what could be
happening, except you may have old license versions which aren't
compatible with your TSM server version : did you try to reinstall
license components from original CD ? This is a problem that can happen
on AIX, but I dunno if this also applies to Windows environment ...
Concerning file space occupation (here again I refer to my environment,
which is AIX), what you're seeing is normal : Informix data is sent thru
TSM API, and it looks like this makes the server unable to calculate
occupancy properly. That said, you have a way finding out if data has
really been copied on your server : issue a "show version AIX1_IFMX 1
nametype=fsid" on your server and you'll know !
Cheers.
Arnaud
************************************************************************
******
Panalpina Management Ltd., Basle, Switzerland, CIT Department
Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: arnaud.brion AT panalpina DOT com
************************************************************************
******
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
James Choate
Sent: Wednesday, 06 October, 2004 20:27
To: ADSM-L AT VM.MARIST DOT EDU
Subject: TDP for Informix anomaly
Two questions:
1)Why won't my license file register?
2) Why is the size of my filespace 0 after the backup completes
successfully?
Here are the details.
(I have a call open with IBM, but just wondering if anyone else has seen
this.)
I am backing up informix (Informix Dynamic Server Version 7.31.FD6)
using TDP.
Informix is running on AIX 5.2 ML02.
TDP version is 5.2.1.0
TSM server version is 5.1.7.3 running on Windows.
I have created a shell script that will kick off the onbar process.
The process works fine. I see the ksh cmd run and see a session
established. When I do a q sess on the server, I see data coming
tsm: TIVOLI_SERVER1>q sess
Sess Comm. Sess Wait Bytes Bytes Sess
Platform Client Name
Number Method State Time Sent Recvd Type
------ ------ ------ ------ ------- -------
----- -------- ------------------
2 Tcp/Ip Run 0 S 837.1 K 108
Admin WinNT ADMIN
299 Tcp/Ip Run 0 S 4.2 K 273
Admin WinNT HENRY
2,767 Tcp/Ip Run 0 S 78.4 K 1.3 K
Admin WinNT FRED
2,911 Tcp/Ip Run 0 S 80.3 K 108
Admin WinNT ADMIN
3,575 Tcp/Ip RecvW 0 S 5.3 K 68.4 G Node
WinNT RCCS02
3,579 Tcp/Ip IdleW 10 S 1.7 M 861 Node
WinNT RCCS01
3,580 Tcp/Ip Run 0 S 12.3 K 108
Admin WinNT ADMIN
3,730 Tcp/Ip RecvW 0 S 5.0 K 5.7 G Node
TDPI AIX1_IFMX
AIX51
64bit
3,731 Tcp/Ip Run 0 S 3.2 K 167
Admin WinNT ADMIN
AIX1_IFMX is the node in question. You can see bytes recvd is 5.7G.
additionally the act_bar.log file shows the data is being backed up
successfully:
2004-10-06 13:08:38 1212538 1536058 /usr/informix/bin/onbar_d -b -w
2004-10-06 13:08:40 1212538 1536058 Begin level 0 backup rootdbs.
2004-10-06 13:08:40 1212538 1536058 Successfully connected to Storage
Manager.
2004-10-06 13:08:42 1212538 1536058 Completed level 0 backup rootdbs.
2004-10-06 13:08:42 1212538 1536058 Begin level 0 backup logsdbs1.
2004-10-06 13:08:42 1212538 1536058 Completed level 0 backup logsdbs1.
2004-10-06 13:08:42 1212538 1536058 Begin level 0 backup datadbs1.
2004-10-06 13:09:07 1212538 1536058 Completed level 0 backup datadbs1.
2004-10-06 13:09:07 1212538 1536058 Begin level 0 backup datadbs2.
2004-10-06 13:12:19 1212538 1536058 Completed level 0 backup datadbs2.
2004-10-06 13:12:19 1212538 1536058 Begin level 0 backup datadbs3.
2004-10-06 13:13:54 1212538 1536058 Completed level 0 backup datadbs3.
2004-10-06 13:13:54 1212538 1536058 Begin level 0 backup datadbs4.
2004-10-06 13:30:36 1212538 1536058 Completed level 0 backup datadbs4.
2004-10-06 13:30:36 1212538 1536058 Begin level 0 backup datadbs5.
2004-10-06 13:32:31 1212538 1536058 Completed level 0 backup datadbs5.
2004-10-06 13:32:31 1212538 1536058 Begin level 0 backup datadbs6.
2004-10-06 13:33:31 1212538 1536058 Completed level 0 backup datadbs6.
2004-10-06 13:33:32 1212538 1536058 Begin level 0 backup tempdbs1.
2004-10-06 13:33:32 1212538 1536058 Completed level 0 backup tempdbs1.
2004-10-06 13:33:32 1212538 1536058 Begin level 0 backup physdbs1.
2004-10-06 13:33:32 1212538 1536058 Completed level 0 backup physdbs1.
2004-10-06 13:33:33 1212538 1536058 Begin backup logical log 13793.
2004-10-06 13:33:33 1212538 1536058 Successfully connected to Storage
Manager.
2004-10-06 13:33:34 1212538 1536058 Completed backup logical log
13793.
2004-10-06 13:33:34 1212538 1536058 Begin backup logical log 13794.
2004-10-06 13:33:34 1212538 1536058 Completed backup logical log
13794.
2004-10-06 13:33:34 1212538 1536058 Begin backup logical log 13795.
2004-10-06 13:33:35 1212538 1536058 Completed backup logical log
13795.
2004-10-06 13:33:35 1212538 1536058 Begin backup logical log 13796.
2004-10-06 13:33:36 1212538 1536058 Completed backup logical log
13796.
2004-10-06 13:33:36 1212538 1536058 Begin backup logical log 13797.
2004-10-06 13:33:37 1212538 1536058 Completed backup logical log
13797.
2004-10-06 13:33:37 1212538 1536058 Begin backup logical log 13798.
2004-10-06 13:33:38 1212538 1536058 Completed backup logical log
13798.
2004-10-06 13:33:38 1212538 1536058 Begin backup logical log 13799.
2004-10-06 13:33:38 1212538 1536058 Completed backup logical log
13799.
2004-10-06 13:33:38 1212538 1536058 /usr/informix/bin/onbar_d: process
exit 0 (0x00)
But when I query the filespace on the server.
q filespace
tsm: TIVOLI_SERVER1>SELECT NODE_NAME, FILESPACE_NAME, FILESPACE_TYPE,
CAPACITY AS "FileSystem Size in MB", -
cont> PCT_UTIL, DECIMAL((CAPACITY * (PCT_UTIL / 100.0)), 10, 2) AS "MB
ofActive Files" -
cont> FROM FILESPACES where node_name='AIX1_IFMX'
Session established with server TIVOLI_SERVER1: Windows
Server Version 5, Release 1, Level 7.3
Server date/time: 10/06/2004 14:01:54 Last access: 10/06/2004
13:27:07
NODE_NAME FILESPACE_NAME FILESPACE_TYPE FileSystem
Size in MB PCT_UTIL MB ofActive Files
------------------ ------------------
------------------ ---------------------
-------------- -----------------
AIX1_IFMX /prod01 API:R
0.0 0.0 0.00
>From the client:
# dsmc q file
IBM Tivoli Storage Manager
Command Line Backup/Archive Client Interface - Version 5, Release 2,
Level 0.0
(c) Copyright by IBM Corporation and other(s) 1990, 2003. All Rights
Reserved.
Node Name: AIX1_IFMX
Session established with server TIVOLI_SERVER1: Windows
Server Version 5, Release 1, Level 7.3
Server date/time: 10/06/04 14:16:05 Last access: 10/06/04
13:44:01
Num Last Incr Date Type File Space Name
--- -------------- ---- ---------------
1 00/00/00 00:00:00 API:R /prod01
tsm: TIVOLI_SERVER1>reg lic file=c:\tdpi.lic number=1 ANR2852I Current
license information:
ANR2828I Server is licensed to support Tape Library Sharing.
ANR2827I Server is licensed to support Managed System for LAN for a
quantity of 120.
ANR2853I New license information:
ANR2828I Server is licensed to support Tape Library Sharing.
ANR2827I Server is licensed to support Managed System for LAN for a
quantity of 120.
tsm: TIVOLI_SERVER1>q actlog begint=now-00:02
Date/Time Message
--------------------
----------------------------------------------------------
10/06/2004 14:21:10 ANR0407I Session 3741 started for administrator
ADMIN
(WinNT) (Tcp/Ip 10.11.95.91(3840)).
10/06/2004 14:21:11 ANR2017I Administrator ADMIN issued command:
QUERY LICENSE
10/06/2004 14:22:30 ANR2017I Administrator ADMIN issued command:
REGISTER
LICENSE file=c:\tdpi.lic number=1
10/06/2004 14:22:30 ANR2852I Current license information:
10/06/2004 14:22:30 ANR2828I Server is licensed to support Tape
Library
Sharing.
10/06/2004 14:22:30 ANR2827I Server is licensed to support Managed
System for
LAN for a quantity of 120.
10/06/2004 14:22:30 ANR9630E Invalid license certificate file:
C:\tdpi.lic.
10/06/2004 14:22:30 ANR2853I New license information:
10/06/2004 14:22:30 ANR2828I Server is licensed to support Tape
Library
Sharing.
10/06/2004 14:22:30 ANR2827I Server is licensed to support Managed
System for
LAN for a quantity of 120.
10/06/2004 14:22:50 ANR2017I Administrator ADMIN issued command:
QUERY ACTLOG
begint=now-00:02
tsm: TIVOLI_SERVER1>q lic
Session established with server TIVOLI_SERVER1: Windows
Server Version 5, Release 1, Level 5.0
Server date/time: 10/06/2004 14:21:10 Last access: 10/06/2004
14:01:54
Last License Audit: 09/08/2004 14:14:34
Number of space management clients in use: 0
Number of space management clients licensed: 0
Is Tivoli Disaster Recovery Manager in use ?: No
Is Tivoli Disaster Recovery Manager licensed ?: No
Number of TDP for Oracle in use: 0
Number of TDP for Oracle licensed: 0
Number of TDP for Oracle in try buy mode: 0
Number of TDP for MS SQL Server in use: 0
Number of TDP for MS SQL Server licensed: 0
Number of TDP for MS SQL Server in try buy mode: 0
Number of TDP for MS Exchange in use: 0
Number of TDP for MS Exchange licensed: 0
Number of TDP for MS Exchange in try buy mode: 0
Number of TDP for Lotus Notes in use: 0
Number of TDP for Lotus Notes licensed: 0
Number of TDP for Lotus Notes in try buy mode: 0
Number of TDP for Lotus Domino in use: 0
Number of TDP for Lotus Domino licensed: 0
Number of TDP for Lotus Domino in try buy mode: 0
Number of TDP for Informix in use: 0
Number of TDP for Informix licensed: 0
Number of TDP for Informix in try buy mode: 0
Number of TDP for SAP R/3 in use: 0
Number of TDP for SAP R/3 licensed: 0
Number of TDP for SAP R/3 in try buy mode: 0
Number of TDP for ESS in use: 0
Number of TDP for ESS licensed: 0
Number of TDP for ESS in try buy mode: 0
Number of TDP for ESS R/3 in use: 0
Number of TDP for ESS R/3 licensed: 0
Number of TDP for ESS R/3 in try buy mode: 0
Number of TDP for EMC Symmetrix in use: 0
Number of TDP for EMC Symmetrix licensed: 0
Number of TDP for EMC Symmetrix in try buy mode: 0
Number of TDP for EMC Symmetrix R/3 in use: 0
Number of TDP for EMC Symmetrix R/3 licensed: 0 Number of TDP for
EMC Symmetrix R/3 in try buy mode: 0
Is Library Sharing in use: No
Is Library Sharing licensed: Yes
Number of Managed System for LAN in use: 117
Number of Managed System for LAN licensed: 120
Number of Managed System for SAN in use: 0
Number of Managed System for SAN licensed: 0
Number of Managed Libraries in use: 0
Number of Managed Libraries licensed: 0
Tivoli Data Protection for NDMP in use ?: No
Tivoli Data Protection for NDMP licensed ?: No
Server License Compliance: Valid
What am I missing?
|