Posts tagged "db2"

LiveCycle7: “A system temporary table space with sufficient page size does not exist” error on DB2

Issue

 If you are installing Workflow 7.2.2 onto a DB2 database you may encounter the following error during the bootstrapping process:

A system temporary table space with sufficient page size does not exist

Reason

 This is due to the “CREATE TEMPORARY TABLESPACE” command having failed when you created the LiveCycle Database.

Solution

 This can occur when the DB creation script is invalid, due to missing line breaks, or spaces.  Please consult the appropriate LC installation documentation for your version.  The script for LC7 is as follows:

CREATE TEMPORARY TABLESPACE ADOBE_TEMP_8K IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 8192 MANAGED BY SYSTEM USING (‘C:\DB2\ADOBE_TEMP’) EXTENTSIZE 32 PREFETCHSIZE 16 BUFFERPOOL BP8K;

CREATE REGULAR TABLESPACE ADOBE_DATA_8K IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (FILE’C:\DB2\ADOBE_DATA’1000) EXTENTSIZE 16 PREFETCHSIZE 16 BUFFERPOOL BP8K;

 

VN:F [1.9.22_1171]
Was this helpful? Please rate the content.
Rating: 0.0/10 (0 votes cast)