IV89492: MSSQL UPDATESTATS GIVES WARNING AWSJPL804W

9.4.0-IBM-IWS-WINDOWS_X86_64-FP0001
9.4.0-IBM-IWS-SOLARIS_I386-FP0001
9.4.0-IBM-IWS-LINUXPPC-FP0001
9.4.0-IBM-IWS-LINUX390-FP0001
9.4.0-IBM-IWS-LINUX_X86_64-FP0001
9.4.0-IBM-IWS-HPIA64-FP0001
9.4.0-IBM-IWS-AIX-FP0001
9.4.0-IBM-IWS-WIN_X86_64_ZOS_AGENT-FP0001
9.4.0-IBM-IWS-WIN_X86_64_AGENT-FP0001
9.4.0-IBM-IWS-SOL_I386_ZOS_AGENT-FP0001
9.4.0-IBM-IWS-SOL_I386_AGENT-FP0001
9.4.0-IBM-IWS-LNX_X86_64_ZOS_AGENT-FP0001
9.4.0-IBM-IWS-LNX_X86_64_AGENT-FP0001
9.4.0-IBM-IWS-LNX_S390_ZOS_AGENT-FP0001
9.4.0-IBM-IWS-LNX_S390_AGENT-FP0001
9.4.0-IBM-IWS-LNX_PPC_ZOS_AGENT-FP0001
9.4.0-IBM-IWS-LNX_PPC_AGENT-FP0001
9.4.0-IBM-IWS-LINUXPPC_LE_ZOS_AGENT-FP0001
9.4.0-IBM-IWS-LINUXPPC_LE_AGENT-FP0001
9.4.0-IBM-IWS-IBM_I_ZOS_AGENT-FP0001
9.4.0-IBM-IWS-IBM_I_AGENT-FP0001
9.4.0-IBM-IWS-HPIA64_ZOS_AGENT-FP0001
9.4.0-IBM-IWS-HPIA64_AGENT-FP0001
9.4.0-IBM-IWS-AIX_ZOS_AGENT-FP0001
9.4.0-IBM-IWS-AIX_AGENT-FP0001
9.3.0-TIV-TWS-FP0003_IV97080
9.3.0-IBM-IWS-WINDOWS_X86_64-FP0003
9.3.0-IBM-IWS-WIN_X86_64_ZOS_AGENT-FP0003
9.3.0-IBM-IWS-WIN_X86_64_AGENT-FP0003
9.3.0-IBM-IWS-SOLARIS_I386-FP0003
9.3.0-IBM-IWS-SOL_I386_ZOS_AGENT-FP0003
9.3.0-IBM-IWS-SOL_I386_AGENT-FP0003
9.3.0-IBM-IWS-LNX_X86_64_ZOS_AGENT-FP0003
9.3.0-IBM-IWS-LNX_X86_64_AGENT-FP0003
9.3.0-IBM-IWS-LNX_S390_ZOS_AGENT-FP0003
9.3.0-IBM-IWS-LNX_S390_AGENT-FP0003
9.3.0-IBM-IWS-LNX_PPC_ZOS_AGENT-FP0003
9.3.0-IBM-IWS-LNX_PPC_AGENT-FP0003
9.3.0-IBM-IWS-LNX_I386_ZOS_AGENT-FP0003
9.3.0-IBM-IWS-LNX_I386_AGENT-FP0003
9.3.0-IBM-IWS-LINUXPPC-FP0003
9.3.0-IBM-IWS-LINUX390-FP0003
9.3.0-IBM-IWS-LINUX_X86_64-FP0003
9.3.0-IBM-IWS-IBM_I_ZOS_AGENT-FP0003
9.3.0-IBM-IWS-IBM_I_AGENT-FP0003
9.3.0-IBM-IWS-HPIA64-FP0003
9.3.0-IBM-IWS-HPIA64_ZOS_AGENT-FP0003
9.3.0-IBM-IWS-HPIA64_AGENT-FP0003
9.3.0-IBM-IWS-AIX-FP0003
9.3.0-IBM-IWS-AIX_ZOS_AGENT-FP0003
9.3.0-IBM-IWS-AIX_AGENT-FP0003

APAR status

• Closed as program error.

Error description

• AWSJPL804W The start time of first not complete preproduction
  plan job stream instance is "2/6/16 4:00 AM" and it is old.
  Please check it running planman showinfo command.
  
  Generated, even with jobs less than one day old.
  

Local fix

Problem summary

• There is a wrong check to determine that he start time of first
  not complete preproduction
  plan job stream instance is old.
  

Problem conclusion

• This apar will be  fixed in 9.3.0-TIV-TWS-FP0003 and
  9.3.4-TIV-TWS-FP0001
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• 9W2
  

Fix information

• Fixed component name

  TIV WKLD SCHDL

• Fixed component ID

  5698WKB92

Applicable component levels

• R9W2 PSY

     UP