Unanswered: db2 api sqlesetc() not connecting to catalog node
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:
API documentation for 'SQLE-CONN-SETTING' says that, if you pass const value 'SQL_CONN_CATALOG_NODE' (= 65535), sqlesetc() api function should connect to catalog node. But it is giving me following error message:
"SQL4917N Element "SQL_ATTACH_NODE value" in the option array is not valid."
Please let me know the solution if anyone of you have faced similar problem.