Topic
  • 3 replies
  • Latest Post - ‏2013-03-26T03:29:39Z by sbjerry
Nissad
Nissad
10 Posts

Pinned topic pn0rdbcp.exe has not working at the time of DB Alias creation-Optim8.1/9.1

‏2013-01-28T16:37:35Z |
Hi,

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 signature:
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.

Thanks,
Nis
Updated on 2013-03-26T03:29:39Z at 2013-03-26T03:29:39Z by sbjerry
  • sbjerry
    sbjerry
    23 Posts

    Re: pn0rdbcp.exe has not working at the time of DB Alias creation-Optim8.1/9.1

    ‏2013-03-20T15:02:45Z  
    I'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
    SystemAdmin
    304 Posts

    Re: pn0rdbcp.exe has not working at the time of DB Alias creation-Optim8.1/9.1

    ‏2013-03-21T13:26:58Z  
    Nis, 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,
    Kevin
  • sbjerry
    sbjerry
    23 Posts

    Re: pn0rdbcp.exe has not working at the time of DB Alias creation-Optim8.1/9.1

    ‏2013-03-26T03:29:39Z  
    Nis, 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,
    Kevin
    Thanks KevinHampson for detailed info, will try your suggestion later