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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] ************************************************************************ ****** -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of James Choate Sent: Wednesday, 06 October, 2004 20:27 To: [EMAIL PROTECTED] 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?
