ADM7519W DB2 could not allocate an agent. The SQLCODE is "-1225".

Question: We’re running an application which connects to a DB2 9.7 on Red Hat Linux 6. On the last batch job the following error message was reported. --application side Connection reset. ERRORCODE=-4499, SQLSTATE=08001 -- The associated messages in the db2diag.log were ADM7009E An error was encountered in the "TCPIP" protocol support. A possible cause is that the maximum number of agents has been exceeded. ADM7519W DB2 could not allocate an agent. The SQLCODE is "-1225". Answer: Some background information. The configuration parameter MAXAGENTS is set at the instance level , therefore an aggregate of all active databases. Each database has... Read more →

Dropping all tables from a DB2 schema

Use this query to select and drop all tables of a schema. Note: this query constructs a sql statement for every table , e.g DROP TABLE MYTEST.mytable; . --example SCHEMA = MYTEST db2 -x "select 'DROP TABLE '||rtrim(tabschema)||'.'||rtrim(tabname) ||’;’ from syscat.tables where tabschema = 'MYTEST'" If you’re intention is to drop all the tables and the schema, an alternative approach is to use the ADMIN_DROP_SCHEMA procedure . Read DB2 - ADMIN_DROP_SCHEMA to drop a schema Read More DB2 Database objects overviews - DBA DB2 DB2 SET CURRENT SCHEMA - DBA DB2 Read more →