See the Flash at http://www-01.ibm.com/support/docview.wss?uid=swg21428557

David

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Huebner,Andy,FORT WORTH,IT
Sent: Friday, September 07, 2012 11:31 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] ANR0162W resource limit was reached

WARNING: TSM03: ANR0162W Supplemental database diagnostic information: 
-1:54067:-1589 ([IBM][CLI Driver] SQL1589N The database connection failed 
because an operating system resource limit was reached. SQLSTATE=54067 ).~ 
Source:TSM-TSM_SERVER

I am receiving this message from one of my TSM servers and I think it is a 
connection limit to the DB. IBM says the limit is 1024 connections.
The errors happen around the same time each night when there are not any 
scripts or queries running, only backups.


The question is what generates a connection?
Is each session 1 connection?
The server is limited to 900 sessions.

Is there a command to see the number of connections to the DB?

TSM 6.2.3.100
AIX 6.1


Andy Huebner



This e-mail (including any attachments) is confidential and may be legally 
privileged. If you are not an intended recipient or an authorized 
representative of an intended recipient, you are prohibited from using, copying 
or distributing the information in this e-mail or its attachments. If you have 
received this e-mail in error, please notify the sender immediately by return 
e-mail and delete all copies of this message and any attachments.

Thank you.