DB2 FOR LUW / DB2FORLUW / A10 - DB2

Example query: 
 
 db2 -x "SELECT distinct TIMESTAMP, varchar (SUBSTR(MSG,1,100)) 
AS MSG FROM TABLE ( PD_GET_LOG_MSGS( CURRENT TIMESTAMP - 1 DAYS) 
) AS PD ORDER BY TIMESTAMP DESC" 
SQL22237N  A file system error occurred when performing an 
operation on path 
"/dump/newdemo1/DIAG0129/newdemo1*.nfy". Reason code = "2". 
 
Such SQL22237N is due to admin log ( <instance>.log, or 
<instance>.*.log ) not existing under the DIAGPATH 
directories

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 5.                      * 
****************************************************************

Create a fake admin log, or copy another admin log to the 
directory that is missing the admin log, then the error should 
be gone.

First fixed in DB2 Version 10.1 Fix Pack 5.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

08.07.2014
15.07.2015
15.07.2015