I am using Optim 8.1(and 9.1) when I try to create /update DBAlias for DB2 8.1 database I am getting below error.
An unknown internal error occurred in function RDB_GethConn. RC=-1.
pn0rdbcp.exe has stopped working
Problem Event Name: APPCRASH
Application Name: pn0rdbcp.exe
Application Version: 0.0.0.0
Application Timestamp: 504278db
Fault Module Name: pn0rdbcp.exe
Fault Module Version: 0.0.0.0
Fault Module Timestamp: 504278db
Exception Code: c0000005
Exception Offset: 00001f03
OS Version: 6.1.7601.2.1.0.272.7
Locale ID: 1033
Additional Information 1: 0a9e
Additional Information 2: 0a9e372d3b4ad19135b953a78882e789
Additional Information 3: 0a9e
notes:installed Optim9.1 and I am getting the same error.
DBALIAS for other databases(SQL Server and Oracle are working fine)
Do I need to install any fixpack for this.
This topic has been locked.
3 replies Latest Post - 2013-03-26T03:29:39Z by sbjerry
Pinned topic pn0rdbcp.exe has not working at the time of DB Alias creation-Optim8.1/9.1
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-03-26T03:29:39Z at 2013-03-26T03:29:39Z by sbjerry
sbjerry 060001XVVM19 PostsACCEPTED ANSWER
Re: pn0rdbcp.exe has not working at the time of DB Alias creation-Optim8.1/9.12013-03-20T15:02:45Z in response to NissadI've also met with this problem, I installed the optim 8.1 with FP4 on 64bit Win7.
This problem happened when I try to create /update DBAlias for DB2 9.7,
pn0rdbcp.exe has stopped working with notification "An unknown internal error occurred in function RDB_GethConn. RC=-1."
SystemAdmin 110000D4XK304 PostsACCEPTED ANSWER
Re: pn0rdbcp.exe has not working at the time of DB Alias creation-Optim8.1/9.12013-03-21T13:26:58Z in response to NissadNis, sbjerry,
Hope things are well. The pn0rdbcp.exe is a program that was developed for Optim to determine the DB2 code page we were working with. At the time it
was written there was a DB2 client shortcoming where Optim could not query the directly to get this information. DB2 has since fixed this problem and
I believe at the Db2 9.7.5 client version (+ fixpacks), Optim uses a different method to get the code page.
With all that said, it still does not help your immediate problem. However I do have a work around that you can use to bypass the execution
of the PN0RDBCP.exe for now. There is a registry entry called, AssumeUDBDBCodepage. This can be set to either UTF-8 or NON-UTF-8, depending on the
database. With this set, Optim will bypass the execution of the PN0RDBCP program.
Hope this helsp for now,