Nonstop Database, HiRDB Version 9 System Operation Guide

[Contents][Index][Back][Next]

18.1.2 Registering a new C library file

A new C library file created by a UAP developer must be registered in HiRDB. The following is the procedure for registering a new C library file.

Procedure
  1. Copy the C library file created by the client to the server machine on which the HiRDB server is running.
    For a HiRDB parallel server configuration, copy the C library file to one of the server machines comprising the HiRDB parallel server configuration (there is no need to copy the C library file to all server machines).
  2. Create a directory in which to store the C library file.
  3. Specify the directory created in step 2 in the pd_c_library_directory operand.
  4. Use the pdclibsync command to register the new C library file.
    pdclibsync -I -u USER01 -f /usr/user01/propcfile01.sl
    -I: Specified when registering a new C library file.
    -u: Specifies the owner of the C library file.
    -f: Specifies the C library file copied from the client in step 1.
    Note: The extension of the C library file varies depending on the OS.

When the pdclibsync command is executed in step 4, the C library file is copied to the directory specified in step 3 and is newly registered in HiRDB.

A new C library file can also be registered using the INSTALL CLIB SQL statement. For details about how to register a new C library file using INSTALL CLIB, see the manual HiRDB Version 9 SQL Reference.

[Figure] HiRDB parallel server configuration
  • The same new C library file must be registered on all server machines. Executing the pdclibsync command once newly registers (copies) the same C library file under each server machine's directory.
  • If the configuration of a HiRDB parallel server configuration is modified by adding a new server machine, use the pdclibsync -S command to register the C library file from another server machine.

[Figure] When the system switchover facility is used
Register the C library file in the secondary HiRDB as well. If it is not registered, an SQL error occurs when a C stored procedure or C stored function is executed after a system switchover.

[Figure] When Real Time SAN Replication is used
Register the C library file in HiRDB at the remote site as well. If it is not registered, an SQL error occurs when a C stored procedure or C stored function is executed after the control switches to the remote site.