The document you reference is about the ODBC Connector stage however, we are using the ODBC Enterprise stage. But I did take your advice and for now I modified the job to eliminate the use of as many parms as possible. I also ensured the bind had been done .
But since I have not solved it myself yet I am following your other suggestions. Here are what I think are the pertinent pieces:
From the OSH script for this stage:
Code: Select all
#### STAGE: DB2_PROCESSCONTROL
## Operator
odbcupsert
## Operator options
-db_cs [&DSProjectMapName]
-data_source 'DB2DSNQ'
-user '[&"$MDM_DB2USER"]'
-password '[&"$MDM_DB2PASSWD"]'
-insert 'INSERT INTO M80QA1.PROCESSCONTROL (PROCESSCON_ID,PROCESSCON_INST_PK,PRODENTITY_ID,NEXT_PROCESS_DT,LAST_UPDATE_DT,LAST_UPDATE_USER) VALUES (?,?,?,?,?,?);'
## General options
.
.
.
From the uvodbc.config file in the project directory:
From the .odbc.ini file (I changed the IP address for this post):
Code: Select all
[DB2DSNQ]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMdb222.so
Description=DB2DSNQ DataDirect DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Collection=
Database=DB2DSNQ
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=172.999.999.999
IsolationLevel=CURSOR_STABILITY
Location=
LogonID=
Password=
Package=
PackageOwner=
TcpPort=6200
WithHold=1
I'm still hoping to learn what "parameter 1" in the error message is referring to. Is it [&DSProjectMapName] ?