Error connecting to DB2 on iSeries

Tags:
AS/400
DB2
iSeries
Hello All, I'm getting below error while connecting db2 database on Linux which is cataloged to db2 on iSeries. Kindly help me out on this.
db2 -r -u -p
                                                                          
 **** CLI ERROR *****                                                     
         SQLSTATE: 58017                                                  
NATIVE ERROR CODE: -30073                                                 
Distributed Data Management (DDM) parameter value X'119C' not supported.
Thanks in Advance. Regards, Shankar
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Are you trying to connect to a DDM file? As far as I know that is not possible. You can only connect to PF or LF data files. Can you post your full code?
    132,520 pointsBadges:
    report
  • AjitK29
    What are the DB2 fix levels?
    If you attempt to do a CONNECT in interactive SQL, does it connect?
    2,545 pointsBadges:
    report
  • TheRealRaven
    The connection is almost certainly via DRDA/DDM, so the "DDM" reference seems perfectly valid. However, your "db2" command options don't seem to make any sense.

    Refer to Command line processor options in the IBM Knowledge Center for DB2 on Linux. There isn't a "-u" option listed, and the "-r" option needs to have a filename supplied with it.

    Is there a different DB2 CLP reference that you're using?
    34,990 pointsBadges:
    report
  • ToddN2000
    I have a .net app that connects to DB2 databases for running SQL scripts. If I try to connect to a DDM type file, I get this error.
    SQL7011 MYDDM in MYLIB not table, view, or physical file. 
    132,520 pointsBadges:
    report
  • TheRealRaven
    @ToddN2000, it's not a DDM file (i.e., attribute DDMF). It's a connection through the DRDA/DDM server. The server handles both. You are right, though, that a "DDM file" wouldn't be a valid object to query. The OP simply shows a connection attempt being made. No query has been submitted yet.

    DDM code X'119C' most likely is because the requested CCSID for the connection isn't supported. I'd first check if the remote is running as 65535.
    34,990 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: