DB2 Bind parameters override

[bhimireddyvs]

Hello Everyone,

We are using UCD template for performing DB2 Binds. We have a scenario wherein some programs within the same application uses different DB2 BIND parameters than the parameters that were set up at UCD template level.

For overriding the default BIND parameters that were set up in the UCD template, I am using the "bind.properties" file an application level and these override parameters are getting build in the Build step.

In the deploy step, I am facing the error saying that "[Error] Found unresolved property in template:BIND PACKAGE(${bind_collectionID}) -"

Please see attached for more details.

Can you please suggest how to pass these Bind variables bind_collectionID, bind_packageOwner, bind_qualifier all the way from pipeline to UCD?

application.properties.txt
bind.properties.txt
Deploy log.txt
Package.txt
UCD setup.docx

Thank you so much for your help.

Best Regards,
Subba

[dennis-behm]

Hi @bhimireddyvs

A couple of pointers from a DBB perspective - we may need a hand from a UCD specialist, but it looks like it misses something on your side at the beginning in the build phase.

FYI - A few month ago, we had updated the BindUtilities, that start to accept file properties to define the bind parameters.
Please see PR #532 and issue #338

This along with the settings in defaultzAppBuildConf.properties will add the listed properties as properties in the packaging stage via a DBB properties record. However, in your package.txt attachment, I do not see any bind properties captured.

In your DBB build report, your should fine the db2BindInfo as a generic DBB PROPERTIES record which "persists" the data from bind.properties / build properties:

    {
      "id": "db2BindInfo:MortgageApplication/cobol/epscmort.cbl",
      "type": "PROPERTIES",
      "properties": {
        "bind_collectionID": "MORTGAGE",
        "file": "MortgageApplication/cobol/epscmort.cbl",
        "bind_qualifier": "MORTGAGE",
        "bind_packageOwner": "UCDAGNT"
      }
    },

After being processed by the packaging script, the shiplist should contain like something like. See the bind_ prefixed props:

 <container name='JENKINS.PIPELINE.MORTGAGE.MAIN.BLD.DBRM' type='PDS'>
    <resource name='EPSCMORT' type='PDSMember' deployType='DBRM'>
      <property name='buildcommand' value='IGYCRCTL' />
      <property name='buildoptions' value='LIB,SOURCE,CICS,SQL,TEST' />
      <property name='bind_collectionID' value='MORTGAGE' />
      <property name='file' value='MortgageApplication/cobol/epscmort.cbl' />
      <property name='bind_qualifier' value='MORTGAGE' />
      <property name='bind_packageOwner' value='UCDAGNT' />
      <property name='githash' value='8c7ed98dae32ae47fccb2c588ae0749433571424' />
      <inputs url=''>
        <input name='MortgageApplication/cobol/epscmort.cbl' compileType='Main' url='' />
        <input name='MortgageApplication/copybook/epsmtcom.cpy' compileType='COPY' url='' />
        <input name='MortgageApplication/copybook/epsmtinp.cpy' compileType='COPY' url='' />
        <input name='MortgageApplication/copybook/epsmtout.cpy' compileType='COPY' url='' />
        <input name='MortgageApplication/copybook/epsnbrpm.cpy' compileType='COPY' url='' />
        <input name='JENKINS.PIPELINE.MORTGAGE.MAIN.BLD.OBJ(EPSCMORT)' compileType='LINK' url='' />
        <input name='JENKINS.PIPELINE.MORTGAGE.MAIN.BLD.OBJ(EPSNBRVL)' compileType='LINK' url='' />
      </inputs>
    </resource>
  </container>

To me your bind.properties file looks wrong. It should be clearly be a key value pair. Are DB2SUBR,DB2PAYRL,DB2DBA values or the references of properties that you want to store? Here is the

#id:                "db2BindInfo:sandbox-cput/cobol/$DSEMAIL.cbl"
#type:              "PROPERTIES"
#properties:
#  bind_collectionid: "DB2SUBR"
#  file:              "sandbox-cput/cobol/$DSEMAIL.cbl" 
#  bind_qualifier:    "DB2DBA"
#  bind_packageOwner: "DB2PAYRL"
  



#file=           "cobol/$DSEMAIL.cbl"
generateDb2BindInfoRecordProperties=DB2SUBR,DB2PAYRL,DB2DBA
#bind_packageOwner= "DB2PAYRL"  

So, this is how our looks like:

#
# DB2 Bind Options
# Build properties used by BindUtilities.groovy to build a DB2 application package for 
# SQL programs in the application.
#
# Please provide values for the properties listed below.
# Ex:
# SUBSYS = DBB1

# Max Bind RC
bind_maxRC=4

# Flag indicating to run DB2 BIND PACKAGE.  Set to 'true' to bind SQL programs
bind_performBindPackage=false

# DBB Toolkit conf (configuration) directory location on zFS. Default value is preset
# This directory may have been relocated to a writable disk by your SYSADMIN
bind_runIspfConfDir=

# Specify the name of the DB2 subsystem
bind_db2Location=DBC1 

# Specify the DB2 collection (Package)
bind_collectionID=MORTGAGE

# Specify the owner of the package, if empty user.name will be used
bind_packageOwner=UCDAGNT

# Specify the value of the implicit qualifier. 
bind_qualifier=MORTGAGE

UCD follows the same properties, like in zAppBuild, which I also see in your UCD config. So, this should be fine. Finally, the UCD component version contains the properties:

[bhimireddyvs]

Sorry for the delayed response Dennis. Thank you so much for your inputs. I was able to resolve the issue.

Appreciate your help.

Best Regards,
Subba