A fix is available
APAR status
Closed as program error.
Error description
The issue is a DB2 table that a user wants to copy rows from the table on one system and put them on another system (same table name - different DB2s). The problem is the that one of the columns is managed by DB2 to put a sequential number in the column when a row is added. This creates a problem when they do the insert because DB2 says that it manages the column and will not allow the inserting of the row from the other DB2, with an SQLCODE -798 "A VALUE CANNOT BE SPECIFIED FOR COLUMN column-name WHICH IS DEFINED AS GENERATED ALWAYS." This error only occurs on a view created against the table.
Local fix
A user can avoid the problem by processing the table, not the view.
Problem summary
**************************************************************** * USERS AFFECTED: All users of File Manager DB2 component. * **************************************************************** * PROBLEM DESCRIPTION: SQLCODE-798 errors processing DB2 * * views that reference a table containing * * a column defined with the GENERATED * * ALWAYS attribute. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** The column defined as GENERATED ALWAYS is being erroneously included in INSERT or UPDATE statements generated by FM/DB2.
Problem conclusion
File Manager DB2 component has been updated to correct the problem.
Temporary fix
Comments
APAR Information
APAR number
PI19264
Reported component name
FILE MANAGER Z/
Reported component ID
5655W6800
Reported release
C12
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-06-03
Closed date
2014-07-10
Last modified date
2014-08-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
FMN2LVL
Fix information
Fixed component name
FILE MANAGER Z/
Fixed component ID
5655W6800
Applicable component levels
RC12 PSY UI19500
UP14/07/24 P F407
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C12","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSXJAV","label":"File Manager for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C12","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
04 August 2014