Quick Beginnings for DB2 Universal Database for UNIX

Updating Catalog Table Data

You only need to run the db2upd52 command if you are upgrading from Version 5 to Version 5.2 of DB2. If you upgrade from Version 2 to Version 5.2 of DB2, database migration will update the data types and the SYSFUN schema.

For DB2 Version 5.2, the SYSIBM.SYSDATATYPES catalog table includes a new data type, BIGINT, and other associated functions in the SYSFUN schema. To support these new features, we recommend that you run the db2upd52 command for each database owned by a DB2 instance being upgraded to Version 5.2. The command adds the new SYSFUN functions signatures that support the BIGINT data type as follows:

• Add SYSIBM.BIGINT to the SYSIBM.SYSDATATYPES catalog table.

• Add the following function signatures to the SYSIBM.SYSFUNCTIONS table:

     create function sysfun.abs(bigint) returns bigint ...
     create function sysfun.absval(bigint) returns bigint ...
     create function sysfun.ceil(bigint) returns bigint ...
     create function sysfun.ceiling(bigint) returns bigint ...
     create function sysfun.floor(bigint) returns bigint ...
     create function sysfun.mod(bigint,bigint) returns bigint ...
     create function sysfun.power(bigint,bigint) returns bigint ...
     create function sysfun.round(bigint,integer) returns bigint ...
     create function sysfun.sign(bigint) returns bigint ...
     create function sysfun.trunc(bigint,integer) returns bigint ...
     create function sysfun.truncate(bigint,integer) returns bigint ...
  

The db2upd52 command also adds the REAL data type to the SYSIBM.SYSDATATYPES catalog table and the function signature (SYSFUN.UCASE) to the SYSIBM.SYSFUNCTIONS table. For information on the syntax of the db2upd52 command, refer to the Command Reference.

[ DB2 List of Books | Search the DB2 Books ]