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
PI23273
Reported component name
FILE MANAGER Z/
Reported component ID
5655Q1200
Reported release
D12
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-08-04
Closed date
2014-11-07
Last modified date
2014-12-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
FMN2LVL FMN2LVLJ FMN2LVLK
Fix information
Fixed component name
FILE MANAGER Z/
Fixed component ID
5655Q1200
Applicable component levels
RD1B PSY UI22876
UP14/11/12 P F411
RD12 PSY UI22877
UP14/11/12 P F411
RD13 PSY UI22878
UP14/11/12 P F411
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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSXJAV","label":"File Manager for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
29 April 2020