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
- 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).
- Create a directory in which to store the C library file.
- Specify the directory created in step 2 in the pd_c_library_directory operand.
- 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.
- 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.
- 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.
- 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.
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.