db2 api sqlesetc() not connecting to catalog node

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Sandeep S. Mutalik

    db2 api sqlesetc() not connecting to catalog node

    Hi,

    I am working with db2 8.1 ese instance with two physical nodes on AIX
    5.1 boxes. I want to get history of the dropped tables from any of the
    nodes. I tried to use db2 api function sqlesetc(). My code is as
    below:


    struct sqle_conn_setti ng connSetting[3] ;
    connSetting[0].type = SQL_ATTACH_NODE ;
    connSetting[0].value = SQL_CONN_CATALO G_NODE;
    connSetting[1].type = SQL_CONNECT_NOD E ;
    connSetting[1].value = SQL_CONN_CATALO G_NODE;
    // disconnect from node on commit (implicit when connect reset)
    connSetting[2].type = SQL_DISCONNECT ;
    connSetting[2].value = SQL_DISCONNECT_ AUTO ;
    sqlesetc(&connS etting[0], 2,&sqlca);

    API documentation for 'SQLE-CONN-SETTING' says that, if you pass const
    value 'SQL_CONN_CATAL OG_NODE' (= 65535), sqlesetc() api function
    should connect to catalog node. But it is giving me following error
    message:
    "SQL4917N Element "SQL_ATTACH_NOD E value" in the option array is not
    valid."

    Please let me know the solution if anyone of you have faced similar
    problem.

    Thanks and Regards,

    Sandeep.
Working...