Administrative API Reference

sqlfrsys - Reset Database Manager Configuration

Resets the parameters in the database manager configuration file to the system defaults.

Authorization

sysadm

Required Connection

None or instance. An instance attachment is not required to perform database manager configuration operations at the current instance (as defined by the value of the DB2INSTANCE environment variable), but is required to perform database manager configuration operations at other instances. To reset the database manager configuration for another instance, it is necessary to first attach to that instance.

Version

sqlutil.h

C API Syntax

/* File: sqlutil.h */ /* API: Reset Database Manager Configuration */ /* ... */ SQL_API_RC SQL_API_FN sqlfrsys ( struct sqlca * pSqlca); /* ... */

Generic API Syntax

/* File: sqlutil.h */ /* API: Reset Database Manager Configuration */ /* ... */ SQL_API_RC SQL_API_FN sqlgrsys ( struct sqlca * pSqlca); /* ... */

API Parameters

pSqlca

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

REXX API Syntax

RESET DATABASE MANAGER CONFIGURATION

Sample Programs

C

\sqllib\samples\c\dbmconf.c

COBOL

\sqllib\samples\cobol\dbmconf.cbl

REXX

\sqllib\samples\rexx\dbmconf.cmd

Usage Notes

If an attachment to a remote instance (or a different local instance) exists, the database manager configuration parameters for the attached server are reset; otherwise, the local database manager configuration parameters are reset.

This API resets the entire configuration (except for non-updatable parameters).

To view or print a list of the current database manager configuration parameters, use sqlfxsys - Get Database Manager Configuration.

To view the default values for database manager configuration parameters, use sqlfdsys - Get Database Manager Configuration Defaults.

To change the value of a configurable parameter, use sqlfusys - Update Database Manager Configuration.

Most changes to the database manager configuration file become effective only after they are loaded into memory. For a server configuration parameter, this occurs during execution of db2start. For a client configuration parameter, this occurs when the application is restarted.

If an error occurs, the database manager configuration file does not change.

The database manager configuration file cannot be reset if the checksum is invalid. This may occur if the database manager configuration file is changed without using the appropriate API. If this happens, the database manager must be installed again to reset the database manager configuration file.

For a brief description of the database manager configuration parameters, see the Command Reference. For more information about these parameters, see the Administration Guide.

See Also

sqlfdsys - Get Database Manager Configuration Defaults

sqlfusys - Update Database Manager Configuration

sqlfxsys - Get Database Manager Configuration.