Before Using HCO for PostgreSQL

HCOPG mimics z/OS functions and other z/OS functionality by storing PostgreSQL stored procedures and tables in your PostgreSQL database(s). To successfully use HCOPG, it is important that you update this stored information each time you upgrade your version of Enterprise Developer, including new releases, patch updates, or hotfixes. Doing so ensures that HCOPG always executes optimally.

We provide three HCOPG scripts you can use to update your PostgreSQL database(s) after each upgrade. By default, all are located in your $COBDIR/etc/hcopg directory:

InstallSYSIBM.sql
Creates metadata tables.
InstallBindProcs.sql
Creates PostgreSQL stored procedures required for binding and managing temporary table metadata.
InstallDigitsFunction.sql
Creates PostgreSQL stored procedures required to support DB2 z/OS functions.
To execute these scripts against any PostgreSQL database, you must have the following permissions to the database:
  • CREATE SCHEMA
  • CREATE PROCEDURE
  • EXECUTE PROCEDURE in the SYSIBM schema

We suggest that you choose from the following methods of script execution:

pgAdmin tool (Amazon RDS)
Execute all three HCOPG scripts against each PostgreSQL database.
PostgreSQL psql utility (Amazon Aurora)
This option enables you to automate the process, running the three scripts consecutively. Use the following syntax at a command prompt:
>psql -h DBInstanceEndpoint –p=Port –u=UserId -d Dbname -a -f ScriptDir/HCOPGScript.sql

Where:

DBInstanceEndpoint Endpoint of Amazon Aurora or RDS PostgreSQL instance
Port Port number of Amazon Aurora or RDS PostgreSQL instance
Userid User executing the HCOPG script
Dbnam Name of the database
ScriptDir Full path to the directory that contains the scripts
HCOPGScript Name of an HCOPG script