APAR status
Closed as fixed if next.
Error description
Job upgraded from v7 to v8.1 aborts with error message ""nulls" property only applies to nullable fields". It appears after a db2read operator.
Local fix
remove the property "-nulls firsts" on the export file, it is automatically reset after import.
Problem summary
**************************************************************** USERS AFFECTED: DB2 EE OP **************************************************************** PROBLEM DESCRIPTION: Job migrated from V7 to V8.1 aborts with error message :"When validating sort key schema: "nulls" property only applies to nullable fields; on key "CD_FAM_CNT: {nulls=first}" **************************************************************** RECOMMENDATION: Use patch ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
JR33137
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-05-26
Closed date
2009-06-10
Last modified date
2009-06-10
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
DB2EE
Fix information
Applicable component levels
R810 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
10 June 2009