SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Limits on Number of Fields in DB2

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Limits on Number of Fields in DB2
Author Message
John Muir



Joined: 31 Oct 2006
Posts: 1

Post Limits on Number of Fields in DB2 Reply with quote

Hi there,

When I try to set up auditing on a DB2 V8.11 table with 529 columns
I get the error message

A Database Error occurred...
SQLSTATE=54040
SQL1424N Too many references to transition variables and transition
> table columns or the row length for these references is too long.
> Reason code="1". LINE NUMBER=20. SQLSTATE=54040

If I reduce the number of columns to be audited to say 502, then
the trigger is created and seems to work fine.

Is this due to an inherent restriction in DB Audit, in DB2 or is there
another explanation?

Thanks,
John

Tue Oct 31, 2006 11:54 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Re: Limits on Number of Fields in DB2 Reply with quote

The max number of columns is 750, but….. the max length of a row in version 8 is 32K
DB Audit creates a repository table whose columns match your data table, plus it adds several extra "header" columns to store information about who made the change, when, where and what type of change. All together this probably exceeds DB2's 32K row size limit.

Another slim possibility is that for the DB Audit repository you selected a tablespace whose page size is smaller then in the tablespaces hosting your data table (same for temporary tablespace). This could also produce weird results leading to SQL1424N

: Hi there,

: When I try to set up auditing on a DB2 V8.11 table with 529 columns
: I get the error message

: A Database Error occurred...
: SQLSTATE=54040
: SQL1424N Too many references to transition variables and transition

: If I reduce the number of columns to be audited to say 502, then
: the trigger is created and seems to work fine.

: Is this due to an inherent restriction in DB Audit, in DB2 or is there
: another explanation?

: Thanks,
: John

Tue Oct 31, 2006 12:13 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.