Pin 2 not initialised error
Posted: Fri Oct 19, 2012 4:53 am
Problem description
1) We are having a sample job which will read from sequential file and
insert a row to database(using DB2 connector stage). This database is a
remote database. When we are running the job using dsjob command it is
failing with error "PIN2 not initialized". PIN2 is DB2Connector stage
in our job.
We are using AIX6.1 server and trying to deploy over VPN
log:-
Event Id: 70
Time : Sat Oct 13 05:02:39 2012
Type : WARNING
User : root
Message :
DBFILEDEPLOY..DB2_Connector_6.IDENT1: Pin 2 not initialized
Event Id: 71
Time : Sat Oct 13 05:02:39 2012
Type : WARNING
User : root
Message :
DBFILEDEPLOY..DB2_Connector_6: Pin 2 not initialized
Event Id: 72
Time : Sat Oct 13 05:02:39 2012
Type : WARNING
User : root
Message :
DBFILEDEPLOY..DB2_Connector_6.DSLink2: DSP.Close Error -100 in
$DSP.Close.
our dsenv file config is-
DB2DIR=/opt/IBM/db2/V9.7;export DB2DIR
DB2INSTANCE=db2inst1;export DB2INSTANCE
INSTHOME=/home/db2inst1;export INSTHOME
DB2PATH=/opt/IBM/db2/V9.7/bin
export DB2PATH
PATH=$PATH:$INSTHOME/sqllib/bin:$INSTHOME/sqllib/adm:$INSTHOME/sqllib/misc
export PATH
LIBPATH=`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:`dirname $DSHOME`/PXEngine/lib:$ASBHOME/apps/jre/lib/ppc64:$ASBHOME/apps/jre/lib/ppc64/j9vm:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/aix-all-ppc_64:$DB2PATH:$INSTHOME/sqllib/lib:$DB2INSTANCE:$DB2DIR:$INSTHOME:$PATH:$LIBPATH
export LIBPATH
THREADS_FLAG=native;export THREADS_FLAG
1) We are having a sample job which will read from sequential file and
insert a row to database(using DB2 connector stage). This database is a
remote database. When we are running the job using dsjob command it is
failing with error "PIN2 not initialized". PIN2 is DB2Connector stage
in our job.
We are using AIX6.1 server and trying to deploy over VPN
log:-
Event Id: 70
Time : Sat Oct 13 05:02:39 2012
Type : WARNING
User : root
Message :
DBFILEDEPLOY..DB2_Connector_6.IDENT1: Pin 2 not initialized
Event Id: 71
Time : Sat Oct 13 05:02:39 2012
Type : WARNING
User : root
Message :
DBFILEDEPLOY..DB2_Connector_6: Pin 2 not initialized
Event Id: 72
Time : Sat Oct 13 05:02:39 2012
Type : WARNING
User : root
Message :
DBFILEDEPLOY..DB2_Connector_6.DSLink2: DSP.Close Error -100 in
$DSP.Close.
our dsenv file config is-
DB2DIR=/opt/IBM/db2/V9.7;export DB2DIR
DB2INSTANCE=db2inst1;export DB2INSTANCE
INSTHOME=/home/db2inst1;export INSTHOME
DB2PATH=/opt/IBM/db2/V9.7/bin
export DB2PATH
PATH=$PATH:$INSTHOME/sqllib/bin:$INSTHOME/sqllib/adm:$INSTHOME/sqllib/misc
export PATH
LIBPATH=`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:`dirname $DSHOME`/PXEngine/lib:$ASBHOME/apps/jre/lib/ppc64:$ASBHOME/apps/jre/lib/ppc64/j9vm:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/aix-all-ppc_64:$DB2PATH:$INSTHOME/sqllib/lib:$DB2INSTANCE:$DB2DIR:$INSTHOME:$PATH:$LIBPATH
export LIBPATH
THREADS_FLAG=native;export THREADS_FLAG