When compiling in Gen: 'Construction Error in DB2, RC = SB37'
Article ID: 246305
Updated On:
Products
Issue/Introduction
When compiling in GEN, 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
Component :
Cause
This error is an insufficient space/size issue during compile within the Gen temporary datasets.
Resolution
This error is an insufficient space/size issue within the Gen temporary datasets during compile. 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
Recommendation would be to increase the values 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
Note1: Prior to Gen 8.x these parameters were set/adjusted within member CLIB(TIUGLOB).
Note2: These parameters are not restricted to 3 digits as previously documented. So, for example, they could be set to say 5000.
Additional Information
Reference the following knowledge document on this topic from an earlier releases of Gen:
https://knowledge.broadcom.com/external/article/51876/error-b3704-on-temporary-dataset-ticcin.html
Gen 8.6 documentation references related to this topic:
Feedback
