See the Flash at http://www-01.ibm.com/support/docview.wss?uid=swg21428557
David -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Huebner,Andy,FORT WORTH,IT Sent: Friday, September 07, 2012 11:31 AM To: [email protected] 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.
