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