Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]WF Repository 8105 install fail DB2
Go
New
Search
Notify
Tools
Reply
  
[CLOSED]WF Repository 8105 install fail DB2
 Login/Join
 
Gold member
posted
Has anyone had some tables fail during install?
Most tables are built but some error like below. I increased table space size to 32k but still get -286 error.

[EL Fine]: sql: Connection(73920627)--CREATE TABLE UOA_GROUPS (ID INTEGER NOT NULL, DEFROLEID INTEGER, DESCRIPTION VARCHAR(255), EXTGROUPNAME VARCHAR(2000), EXTERNALID VARCHAR(255), NAME VARCHAR(255) NOT NULL, NAMESPACE VARCHAR(255), PARENTID INTEGER NOT NULL, PROPERTIES VARCHAR(2000), type INTEGER, PRIMARY KEY (ID))
[EL Fine]: sql: VALUES(1)
[EL Finest]: connection: Connection(73920627)--Connection released to connection pool [default].
[EL Warning]: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.0.v20130507-3faac2b): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=8192;WBFADMIN, DRIVER=4.14.137
Error Code: -286

This message has been edited. Last edited by: RRKen,


8.1.05M AIX Client Windows Tomcat
DB2, Terradata, SQL, Oracle
 
Posts: 55 | Location: Fort Worth, Texas USA | Registered: January 27, 2012Reply With QuoteReport This Post
Platinum Member
posted Hide Post
SQL0286N
A default table space could not be found with a page size of at least pagesize that authorization ID user-name is authorized to use.

Explanation
The CREATE TABLE or DECLARE GLOBAL TEMPORARY TABLE statement did not specify a table space, and a table space of the right type (USER TEMPORARY for declared temporary table) with sufficient page size (at least pagesize), over which authorization ID user-name has USE privilege, could not be found.

Sufficient page size for a table is determined by either the byte count of the row or the number of columns.

User response
Ensure the existence of a table space of the correct type (REGULAR or USER TEMPORARY) with a page size of at least pagesize and that authorization ID user-name has USE privilege on this table space.


Above the official explanation of the SQL error. You error message indicates SQLERRMC=8192, so a minimum pagesize of 8K is required, so your 32K should be sufficient.

I would suggest you check the type of tablespaces you have, and if user WBFADMIN has the correct rights to use the tablespaces.

regards, Martin.


WebFocus 8203M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 154 | Registered: March 29, 2013Reply With QuoteReport This Post
Gold member
posted Hide Post
quote:
suggest you check the type of tablespaces you have

Do you know if REGULAR or USER TEMPORARY is what is needed?


8.1.05M AIX Client Windows Tomcat
DB2, Terradata, SQL, Oracle
 
Posts: 55 | Location: Fort Worth, Texas USA | Registered: January 27, 2012Reply With QuoteReport This Post
Platinum Member
posted Hide Post
I am not a DBA, I just read the IBM information on the DB2 error. It seems both REGULAR and USER TEMPORARY are correct types for the table space.

Martin.


WebFocus 8203M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 154 | Registered: March 29, 2013Reply With QuoteReport This Post
Gold member
posted Hide Post
Ended up creating tables manually, there are some tables from previous version in there that are no longer used. The utility will create the sql to manually build tables (exportcfg.bat)


8.1.05M AIX Client Windows Tomcat
DB2, Terradata, SQL, Oracle
 
Posts: 55 | Location: Fort Worth, Texas USA | Registered: January 27, 2012Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]WF Repository 8105 install fail DB2

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.