gerd_renz3
VIP Member
Hi List,
I´ve got a strange problem and need some expert help. Here´s our setup:
Our PD AS400 server (batch and database) is located in a datacenter, along with the deployment server. Our DV,PY AS400 server (batch and database) is located in my client's office, connected at 1Gb with the datacenter.
Our problem is that DV and PY full packages have errors in them most of the time. The errors show like this in the deployment server's jde.log:
780/1784 Mon Mar 14 16:56:39.500 ODBC_P1.C1942
ODB0000163 - wSQLGetData failure. rc=-1
780/1784 Mon Mar 14 16:56:39.500 ODBC_P1.C1942
ODB0000164 - STMT:00 [HY000][19185] [IBM][iSeries Access ODBC Driver][DB2 UDB]PWS0001 - Function did not complete successfully.
780/1784 Mon Mar 14 16:56:39.500 ODBC_P1.C2016
ODB0000096 - SQLGetData failed. Table F98741, column ESEVSPEC, ODBC DSN Central Objects - PY9.
780/1784 Mon Mar 14 16:56:39.500 jdb_drvm.c1002
JDB9900172 - Failed to execute db fetch
The result is that some NERs get build incomplete and the subsequent compilations error out. When we build update packages with the involved NERs immedeately afterwards, that update packge builds the NERS without errors. When we build PD packages on the same DS (DS and database are in the same datacenter) the build always is ok.
So we think that the problem somehow has to do with the 1GB link. But how, what is wrong? Sometimes the build goes through ok, so there should be no problem with the database (F98741?) itself. What can I do (short of changing the infrastructure) to make it work each time I build a full package? I have the feeling that there may be something wrong with some ODBC settings. Something else we noticed is that when we test full client packages they seem to go through, when we try client/server packages they error out. In other words, when the DS has to build the .pak files as well it may get overburdend. Does that make sense? When we use a WS as a build machine (NOT located in the datacenter) it always builds ok. Our DS is quite strong, W2K, 2x2.8 GHz, 2GB memory, sufficient disk space.
Can anybody help? Thanks in advance, Gerd
We are on E8.9_3, AS400, Central Objects on the AS.
I´ve got a strange problem and need some expert help. Here´s our setup:
Our PD AS400 server (batch and database) is located in a datacenter, along with the deployment server. Our DV,PY AS400 server (batch and database) is located in my client's office, connected at 1Gb with the datacenter.
Our problem is that DV and PY full packages have errors in them most of the time. The errors show like this in the deployment server's jde.log:
780/1784 Mon Mar 14 16:56:39.500 ODBC_P1.C1942
ODB0000163 - wSQLGetData failure. rc=-1
780/1784 Mon Mar 14 16:56:39.500 ODBC_P1.C1942
ODB0000164 - STMT:00 [HY000][19185] [IBM][iSeries Access ODBC Driver][DB2 UDB]PWS0001 - Function did not complete successfully.
780/1784 Mon Mar 14 16:56:39.500 ODBC_P1.C2016
ODB0000096 - SQLGetData failed. Table F98741, column ESEVSPEC, ODBC DSN Central Objects - PY9.
780/1784 Mon Mar 14 16:56:39.500 jdb_drvm.c1002
JDB9900172 - Failed to execute db fetch
The result is that some NERs get build incomplete and the subsequent compilations error out. When we build update packages with the involved NERs immedeately afterwards, that update packge builds the NERS without errors. When we build PD packages on the same DS (DS and database are in the same datacenter) the build always is ok.
So we think that the problem somehow has to do with the 1GB link. But how, what is wrong? Sometimes the build goes through ok, so there should be no problem with the database (F98741?) itself. What can I do (short of changing the infrastructure) to make it work each time I build a full package? I have the feeling that there may be something wrong with some ODBC settings. Something else we noticed is that when we test full client packages they seem to go through, when we try client/server packages they error out. In other words, when the DS has to build the .pak files as well it may get overburdend. Does that make sense? When we use a WS as a build machine (NOT located in the datacenter) it always builds ok. Our DS is quite strong, W2K, 2x2.8 GHz, 2GB memory, sufficient disk space.
Can anybody help? Thanks in advance, Gerd
We are on E8.9_3, AS400, Central Objects on the AS.