IBM Books

Administrative API Reference

sqledrpn - Drop Node Verify

Verifies whether a node is being used by a database. A message is returned, indicating whether the node can be dropped.

Scope

This API only affects the node on which it is issued.

Authorization

One of the following:

Version

sqlenv.h

C API Syntax 



/* File: sqlenv.h */
/* API: Drop Node Verify */
/* ... */
SQL_API_RC SQL_API_FN
  sqledrpn (
    unsigned short Action,
    void * pReserved,
    struct sqlca * pSqlca);
/* ... */

Generic API Syntax 



/* File: sqlenv.h */
/* API: Drop Node Verify */
/* ... */
SQL_API_RC SQL_API_FN
  sqlgdrpn (
    unsigned short Reserved1,
    struct sqlca * pSqlca,
    void * pReserved2,
    unsigned short Action);
/* ... */

API Parameters

Reserved1
Reserved for the length of pReserved2.

pSqlca
Output. A pointer to the sqlca structure. For more information about this structure, see SQLCA.

pReserved2
A spare pointer that is set to NULL or points to 0. Reserved for future use.

Action
The action requested. The valid value is:

SQL_DROPNODE_VERIFY

REXX API Syntax

This API can be called from REXX through the SQLDB2 interface. See How the API Descriptions are Organized, or the Application Development Guide. For a description of the syntax, see the Command Reference.

Usage Notes

If a message is returned, indicating that the node is not in use, use the db2stop command with DROP NODENUM to remove the entry for the node from the db2nodes.cfg file, which removes the node from the database system.

If a message is returned, indicating that the node is in use, the following actions should be taken:

  1. If the node contains data, redistribute the data to remove it from the node using sqludrdt - Redistribute Nodegroup. Use either the drop node option on the sqludrdt API, or the ALTER NODEGROUP statement to remove the node from any nodegroups for the database. This must be done for each database that contains the node in a nodegroup. For more information, see the SQL Reference.

  2. Drop any event monitors that are defined on the node.

  3. Rerun sqledrpn to ensure that the database is no longer in use.

See Also

sqleaddn - Add Node

sqlepstp - Stop Database Manager.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]