'Construction Error in DB2, RC = SB37' and B37-04 on TICCIN for Gen compile 
search cancel

'Construction Error in DB2, RC = SB37' and B37-04 on TICCIN for Gen compile 

book

Article ID: 246305

calendar_today

Updated On:

Products

Gen - Host Encyclopedia Gen

Issue/Introduction

When compiling in Gen 8.6, user gets the following message:
"<module>  Construction Error in DB2, RC = SB37"

The error message is something like the following:
 B37-04,IFG0554A,MCGSD702,STEP1,TICCIN,CA33,D01896,SYS09287.T161011.RA000.MCGSD
 702.R0158383

(Error B37-04 on temporary dataset TICCIN during compile)

Environment

Release : 8.6

Cause

This error is an insufficient space/size issue during compile/precompile within the Gen temporary datasets.

Resolution

This error is an insufficient space/size issue within the Gen temporary datasets during compilation.
These temporary dataset references are located within the member PARMLIB(TIUHE) for Gen 8.x. 

Here is the information found in the PARMILB(TIUHE) member on the Host Encyclopedia as default, those in bold are specific to the DB2 precompile output and likely the cause of this specific error:

TICATRMP=75
TICATRMS=75
TICAPR2P=75
TICAPR2S=75
TICAPUNP=75
TICAPUNS=75
TICACINP=75
TICACINS=75
TICALINP=75
TICALINS=75
TICACICP=75
TICACICS=75
TICADB2P=75
TICADB2S=75
TICALKDP=75
TICALKDS=75
TICASUTP=75
TICASUTS=75

The recommendation would be to increase the values to avoid the error, possibly double the values or set them to a higher value, as it is dependent upon the module sizes being compiled.
Here is an example:

TICATRMP=500
TICATRMS=500
TICAPR2P=500
TICAPR2S=500
TICAPUNP=500
TICAPUNS=500
TICACINP=500
TICACINS=500
TICALINP=500
TICALINS=500
TICACICP=500
TICACICS=500
TICADB2P=500
TICADB2S=500
TICALKDP=500
TICALKDS=500
TICASUTP=500
TICASUTS=500

Note 1:   Prior to Gen 8.x these parameters were set/adjusted within member CLIB(TIUGLOB).

Note 2:  These parameters are not restricted to 3 digits as previously documented.  So, for example, they could be set to say 5000.

Additional Information

Gen 8.6 documentation reference related to this topic: Special Considerations for large Common Format Buffers