Problem:

HCO DCLGEN utility returns an SQL0954C error

Resolution:

If no other application is running and there is enough memory on the workstation then:

1. go into a DB2 command prompt and issue the following command:  

     db2 get db cfg for xxxxx > dbcfg.txt

where xxxxx is the database they are trying to connect to from dclgen tool.

2. check to see what size is given for APPLHEAPSZ, example below

Parm = Default application heap (4KB)             (APPLHEAPSZ) = 64

3. If APPLHEAPSZ is small then Update applheapsz value & issue following command:

      DB2 UPDATE DB CFG FOR xxxxxxxx  USING applheapsz 128

where xxxxxxx is the database alias

This should be done in conjunction with the DBA.

The IBM docs state:

In a partitioned database environment, the application control heap (app_ctl_heap_sz) is used to store copies of the executing sections of SQL statements for agents and subagents. SMP subagents, however, use applheapsz, as do agents in all other environments.

Recommendation: Increase the value of this parameter if your applications receive an error indicating that there is not enough storage in the application heap.  The application heap (applheapsz) is allocated out of agent private memory.