Re: TSM v7.1.1 install - bypassing validation checks

2014-10-02 Thread Rhodes, Richard L. 
I got OC up and running, and hooked in as spokes our three TSM's that are at 
v6.3.  Those 3 instances have +1600 nodes.  Other than that I haven't done 
anything with it yet, so I don't know yet if it's really slow or OK.  

This AIX lpar has 4GB mem, and also runs our mostly unused AdminCenter.

It's interesting that my db2archivelog dir is full!  I've got to get a backup 
defined and run!

Here is the disk space the TSM instance is using at this time:

  Filesystem MB blocks  Free %UsedIused %Iused Mounted on
  /dev/db2activelog1   2240.00 68.92   97%   12 1% 
/tsmdata/tsmoc/db2activelog1
  /dev/db2activelog2   2240.00 68.92   97%   12 1% 
/tsmdata/tsmoc/db2activelog2
  /dev/db2archivelog   6400.00 87.85   99%   26 1% 
/tsmdata/tsmoc/db2archivelog
  /dev/db2data14096.00   3310.78   20%   75 1% 
/tsmdata/tsmoc/db2data1
  /dev/db2data24096.00   3310.77   20%   75 1% 
/tsmdata/tsmoc/db2data2


tsm: TSMOCq db f=d
Database Name: TSMDB1
   Total Size of File System (MB): 8,192
Space Used on File System(MB): 1,570
   Space Used by Database(MB): 1,568
Free Space Available (MB): 6,622
  Total Pages: 122,888
 Usable Pages: 121,976
   Used Pages: 91,408
   Free Pages: 30,568
Buffer Pool Hit Ratio: 96.5
Total Buffer Requests: 12,748,928
   Sort Overflows: 0
  Package Cache Hit Ratio: 69.0
 Last Database Reorganization: 10/01/14   14:42:17
   Full Device Class Name:
Number of Database Backup Streams: 1
 Incrementals Since Last Full: 0
   Last Complete Backup Date/Time:
Compress Database Backups: No


tsm: TSMOCq log f=d
  Active Log Directory: /tsmdata/tsmoc/db2activelog1
   Total Space(MB): 2,048
Used Space(MB): 309
Free Space(MB): 1,739
 Archive Log Directory: /tsmdata/tsmoc/db2archivelog
Total Size of File System (MB): 6,400.00
Space Used on File System (MB): 6,312.15
Free Space(MB): 87.85
Archive Log Compressed: No
  Mirror Log Directory: /tsmdata/tsmoc/db2activelog2
Total Size of File System (MB): 2,240.00
Space Used on File System (MB): 2,171.08
Free Space(MB): 68.92
Archive Failover Log Directory: /DD/tsmoc/db2failoverlog
Total Size of File System (MB): 9,375,202.74
Space Used on File System (MB): 14,685,161.20
Free Space(MB): 37,639,714.50





-Original Message-
From: Rhodes, Richard L. 
Sent: Tuesday, September 30, 2014 3:25 PM
To: 'ADSM: Dist Stor Manager'
Subject: RE: TSM v7.1.1 install - bypassing validation checks

Not that far yet!

I've got the install.sh run, that's all.  Now need to create the v7.1.1 TSM 
instance, then install/config Op center.

The system I'm using is a AIX lpar with 4GB memory.  It's running some other 
things, but nothing big/heavy (interfaces to some of our storage arrays).  Will 
be interesting to see what a completely empty db size is after creating it.

Rick





-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David 
Ehresman
Sent: Tuesday, September 30, 2014 3:17 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TSM v7.1.1 install - bypassing validation checks

So how small of a linux machine did you use and is it big enough to run 
OpCenter reasonably well?

David

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Rhodes, Richard L.
Sent: Tuesday, September 30, 2014 2:35 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] FW: TSM v7.1.1 install - bypassing validation checks

It worked.  I the install completed.

My, this install.sh runs MUCH faster than the v6.2 version!

Thanks for the help!

Rick



-Original Message-
From: Rhodes, Richard L. 
Sent: Tuesday, September 30, 2014 2:22 PM
To: adsm-l mailing list (ADSM-L@VM.MARIST.EDU)
Subject: RE: TSM v7.1.1 install - bypassing validation checks

I take that back!! (user error)

I now have a N (Next) option after the validateion errors.

Proceeding with install . . . .


Rick




-Original Message-
From: Rhodes, Richard L. 
Sent: Tuesday, September 30, 2014 2:20 PM
To: 'ADSM: Dist Stor Manager'
Subject: RE: TSM v7.1.1 install - bypassing validation checks

Thanks for the help, but, didn't help.

I added the parm to the ini file:

 cat IBMIM.ini
 -toolId
 ibmim
 -accessRights
 admin
 -vm
 /opt/IBM/InstallationManager/eclipse/jre_6.0.0.sr9_20110208_03/jre/bin/java
 -startup
 
/opt/IBM/InstallationManager/eclipse/plugins/org.eclipse.equinox.launcher_1.3.0.v20120522-1813.jar
 -vmargs
 -Xms40m
 -Xmx512m
 -Xquickstart
 -Xgcpolicy:gencon
 -DBYPASS_TSM_REQ_CHECKS=true 

Still got the exact same response from the install.sh process.

Thanks

Rick



-Original Message-
From: ADSM: Dist Stor Manager

another sql question

2014-10-02 Thread Lee, Gary 
Looked in the db2 manuals, didn't see what I wanted.

Tsm 6.2.5 under RHEL 6.1

Is there a way to trim trailing whitespace from string fields within a select 
statement?

Looked at the trim function, but it didn't appear to be what I needed.

Thanks for the help.

Re: another sql question

2014-10-02 Thread Hanover, Cameron 
Have you looked at rtrim?

-
Cameron Hanover
chano...@umich.edu

Our integrity sells for so little, but it is all we really have. It is the 
very last inch of us, but within that inch, we are free.
--Valerie (V for Vendetta)

On Oct 2, 2014, at 10:29 AM, Lee, Gary g...@bsu.edu wrote:

 Looked in the db2 manuals, didn't see what I wanted.
 
 Tsm 6.2.5 under RHEL 6.1
 
 Is there a way to trim trailing whitespace from string fields within a select 
 statement?
 
 Looked at the trim function, but it didn't appear to be what I needed.
 
 Thanks for the help.

sql question

2014-10-02 Thread Lee, Gary 
Rtrim did it.

Was looking in the wrong volume of the sql reference.
Thanks.