Was this helpful?
How You Create Data Types in UNIX
The general procedure for defining and installing user-defined data types and functions in a UNIX environment is as follows:
1. Design and code the routines necessary to perform the functions necessary to manipulate the new or existing data types.
2. Establish a test installation in which to test the new data types and functions.
3. Create the IIudadt_register( ) routine.
4. Relink the images by running the iilink script.
5. Build module tests which call all routines in the prescribed manner to test the basic functionality outside of the complexity of the Ingres system. It is advisable to verify that all sections of code are reached.
6. Start a new DBMS server or Star server and test the new functionality. Testing must involve a large variety of query types to ensure full coverage of the code.
7. Once you are confident that the server works, shut down and restart your entire test installation to verify that the support processes (the Recovery, Archiver, and cluster server) operate correctly. You can verify this by checking the following error logs:
$II_SYSTEM/ingres/files/errlog.log
$II_SYSTEM/ingres/files/ii_rcp.log,
$II_SYSTEM/ingres/files/ii_acp.log
Note:  If your system is configured for Ingres Cluster Solution, each node in the Ingres cluster maintains a separate Archiver and Recovery error log. Each log is distinguished by having _nodename appended to the base log name, where nodename is the Ingres node name for the host machine as returned by iipmhost.
8. When the code has been fully tested, make sure that the add_risk_consistency field of the IIADD_DEFINITION data structure is set to IIADD_CONSISTENT. For more information about this field, see Structure IIADD_DEFINITION Fields on page 1.
9. Install the new code in the target system.
Move all of your code to the desired location for your target system. Once your code is in place, you must shutdown and restart your installation so that the support processes recognize the new code.
Last modified date: 11/28/2023