[teiid-issues] [JBoss JIRA] (TEIID-3262) Database Logging: Problems with DB2

[Van Halbert (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3262?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13028304#comment-13028304 ] 

Van Halbert commented on TEIID-3262:
------------------------------------

I think its an IBM configuration problem.   When I ran the create table statement directly to DB2 using SQurrel, I get a different IBM Error:

Error: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=16384;BQT2, DRIVER=4.0.100
SQLState:  42727

And I found a similar issue on the IBM Knowledge base and is the following:

Problem: If you are using Repotools with DB2® as your database to create tables forRational® Quality Manager, the error message SQL Message: DB2 SQL error: SQLCODE: -286, SQLSTATE: 42727, SQLERRMC: 16384;DB2ADMIN might be displayed.

Solution: When you create the Rational Quality Manager database, you must increase the default bufferpool and table page size space to 16k. For more information, see the Rational Quality Manager installation documentation.

I'll do more investigation.

> Database Logging: Problems with DB2
> -----------------------------------
>
>                 Key: TEIID-3262
>                 URL: https://issues.jboss.org/browse/TEIID-3262
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.7.1
>            Reporter: Jan Stastny
>            Assignee: Steven Hawkins
>         Attachments: stack-trace.txt
>
>
> When Database Logging feature is turned on and configured with DB2 version 10, problems are encountered when an attempt to create a command log.
> The issue produces long stacktrace, so it is attached in a text file.



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)