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

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
    ACCEPTED ANSWER

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

    ‏2013-03-20T15:02:45Z  in response to Nissad
    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
    ACCEPTED ANSWER

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

    ‏2013-03-21T13:26:58Z  in response to Nissad
    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
      ACCEPTED ANSWER

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

      ‏2013-03-26T03:29:39Z  in response to SystemAdmin
      Thanks KevinHampson for detailed info, will try your suggestion later