What is the db2diag.log telling you when this bind fails? If you are getting
"Operating System error" and something like "not enough system resources
available", you have run out of RAM and DB2 can't grow the PCKCACHESZ heap.

Does it help if you do a db2stop to release all resources and db2start and
then retry the db2look?

-----Original Message-----
From: Adolfo
[mailto:db2udbdba-ezmlmshield-x11978676.[Email address protected]
Sent: Wednesday, 30 January 2008 10:47 AM
To: LazyDBA Discussion
Subject: HELP!!!

Hi Gurus





I have problem



$ db2look -d pipmx -a -e -x -l > salida

-- Generate statistics for all creators

-- Creating DDL for table(s)

--An error has occured during Binding



Error Message =

SQL0973N Not enough storage is available in the "PCKCACHESZ" heap to

process the statement. SQLSTATE=57011





SQLCA

Size = 136

SQLCODE = -973

Tokens = PCKCACHESZ

RDS fn = SQLRAFPA

RC = 0x8B0F0007 = -1961951225

Reason = 0x0007 = 7

Reason2 = 0x0000 = 0

Warning flags =



My PCKCACHESZ is 128000 this is max value



Can you help me?










Adolfo Roldán Albarrán

Analista Técnico - DBA DB2

Harbinter Soluciones S.A. de C.V.

Tel. (55) 5255 2955

<mailto:[Email address protected] [Email address protected]





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page