Topic
No replies
graham40
graham40
127 Posts
ACCEPTED ANSWER

Pinned topic Why does DB2 compile hang when region is running?

‏2010-12-13T02:24:01Z |
Hello,

Sorry this is long but probably simple answers. Please.

Am Windows XP, TXSeries 7.1. Situation: CICS is running, REGION1 is up, cicsterm screen is clear, I needed to make a change to a COBOL/CICS/DB2 pgm, do a CEMT SET PROG(QKDBP04) NEWCOPY then test the change - WITHOUT stopping my region.

So in a CMD window I do ..
..
DB2 CONNECT RESET
DB2 CONNECT TO WCB3
CALL XTCLDB2 QKDBP04
---
.. where XTCLDB2 is
---
set tempmem=on
set cobopt="noseq"
set userlib="C:\Program Files\IBM\SQLLIB\lib\db2api.lib"
set CICS_IBM_FLAGS="-g"
set syslib=c:\Program Files\IBM\SQLLIB\include\cobol_a;c:\opt\cics\include;c:\Program Files\IBM\sqllib
DB2 CONNECT RESET
DB2 CONNECT TO WCB3
DB2 PREP %1.SQB BINDFILE TARGET IBMCOB OUTPUT %1.ccp
DB2 BIND %1.BND
CICSTCL -l IBMCOB -a -d -v -s %1

.. and the compile/link started and I got ..

C:\conrad\qkdb>echo off
DB20000I The SQL command completed successfully.

Database Connection Information

Database server = DB2/NT 9.1.0
SQL authorization ID = GJH
Local database alias = WCB3

DB20000I The SQL command completed successfully.

Database Connection Information

Database server = DB2/NT 9.1.0
SQL authorization ID = GJH
Local database alias = WCB3
LINE MESSAGES FOR QKDBp04.SQB


SQL0060W The "COBOL" precompiler is in progress.
70 SQL0062W Starting INCLUDE of file
"C:\conrad\qkdb\THEBOOK.cbl".
70 SQL0063W Completed INCLUDE of file "THEBOOK.cbl".
SQL0091W Precompilation or binding was ended with "0"
errors and "0" warnings.

LINE MESSAGES FOR QKDBp04.BND


SQL0061W The binder is in progress.

.. compile hung at this point, so a) I closed the cicsterm and it stayed hung, b) so I stopped the region and while the region was 'stopping' (verrry slowly) the compile resumed and completed as follows
..

SQL0091N Binding was ended with "0" errors and "0" warnings.
ERZ004047I/9005: Running the translation step: 'cicstran -lIBMCOB -d -v -s -qAPO
ST QKDBp04'
ERZ004073W/8003: Error processing copybook 'QKDBEDSC'.
ERZ004060I/5015: cicstran translation ended: 0 error(s), 1 warning(s).
ERZ004049I/0096: Running the compile and link step: 'cob2 -c -qlib -qthread -g -
qlib,xref,ssrange,nosequence,map,trunc(bin) -IC:\opt\cics\include QKDBp04.cbl'
PP 5724-T07 IBM COBOL for Windows 7.6.0 in progress ...
End of compilation 1, program QKDBP04, no statements flagged.
ERZ004049I/0096: Running the compile and link step: 'ilib /gendef /nol QKDBp04.o
bj'
ERZ004049I/0096: Running the compile and link step: 'ilib /nol /genimplib /def:Q
KDBp04.def'
ERZ004049I/0096: Running the compile and link step: 'ilink /nol /dll /de QKDBp04
.obj iwzrwin3.obj iwzrwin4.obj /o:QKDBp04.ibmcob QKDBp04.ibmcob.exp C:\opt\cics
\lib\cicsprIBMCOB.lib "C:\Program Files\IBM\SQLLIB\lib\db2api.lib"'

C:\conrad\qkdb>

Two questions if I may:

1. Should I have to stop the region to do a DB2 compile - how can I avoid this?
2. Doesn't show above but why did my region take more than five minutes to stop?

Any help appreciated,
thanks
Graham