и  2006 - 02 - 26 - 20 . 51 . 40 . 437000 + 300  I10723H420         LEVEL: Error
PID     :  2260                  TID  :  1708         PROC : db2syscs.exe
INSTANCE: DB2                  NODE :  000          DB   : TICKPROC
APPHDL  :  0 - 26                  APPID: *LOCAL.DB2. 060226155140 
FUNCTION: DB2 UDB, access plan manager, sqlra_passthru_describe, probe: 20 
RETCODE : ZRC=0x80260160=- 2144992928 =SQLQG_ERROR "Error constant for 
gateway.

CREATE NICKNAME p2a.FLT_PAX_DOC FOR WASP.P2.FLT_PAX_DOC

DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0804N  The application program parameters for the current request are not
valid.  Reason code "".  If a host variable or SQLVAR in the SQLDA is 
invalid
then:  host variable/SQLVAR number = "", SQLTYPE = "", SQLLEN = "", host
variable/SQLVAR type = "".  SQLSTATE= 07002 

(в db2diag.log ничего не пишется)

CREATE NICKNAME p2a.FLT_PAX_DOC FOR WASP.P2.FLT_PAX_DOC;
------------------------------------------------------------------------------
CREATE NICKNAME p2a.FLT_PAX_DOC FOR WASP.P2.FLT_PAX_DOC
DB21034E  The command was processed as an SQL statement because it was not a 
valid Command Line Processor command.  During SQL processing it returned:
SQL0804N  The application program parameters for the current request are not 
valid.  Reason code "".  If a host variable or SQLVAR in the SQLDA is invalid 
then:  host variable/SQLVAR number = "", SQLTYPE = "", SQLLEN = "", host 
variable/SQLVAR type = "".  SQLSTATE= 07002 

SQL0804N  The application program parameters for the current request are not valid.  Reason code "7".  If a host variable or SQLVAR in the SQLDA is invalid then:  host variable/SQLVAR number = "1251", SQLTYPE = "VVM     ", SQLLEN = "TICKPROC", host variable/SQLVAR type = "QDB2/NT".

Explanation: 

An error occurred while processing the current request.  

o   The call parameter list, which is created by the precompiler, 
    may not be correct if the application programmer has modified 
    the output of the precompiler or over-written the call        
    parameter list in another way.  

o   The SQLDA or host variable(s) in the SQL statement are   
    invalid.  

o   The request being made is not supported or is out of 
    context.  

 

 Reason codes are interpreted as follows: 
 

  100  The request being made is not supported or is out of         
context.  

  101  SQLDA.SQLN is less than SQLDA.SQLD 

  102  SQLVAR.SQLTYPE is invalid.  

 Federated system users: A data type that you specified is not    
supported by either the federated server or the data source that  
you want to access.  

  103  The length specified in SQLVAR.SQLLEN or SQLVAR2.SQLLONGLEN  
is incorrect for the SQL type given in SQLVAR.SQLTYPE.  

  104  Doubling of the SQLVARs is expected, but the SQLDOUBLED      
field of SQLDA.SQLDAID is not set to '2'.  This may be required   
because of a large object type or a structured type.  

  105  A double-byte character Large Object has an odd value        
indicated by the SQLVAR2.SQLDATALEN pointer, which is always in   
terms of bytes, even for DBCLOBs.  

  106  The SQLDATA pointer is invalid or points to insufficient     
storage.  

  107  The SQLIND pointer is invalid or points to insufficient      
storage.  

  108  The SQLDATALEN pointer is invalid or points to insufficient  
storage.  

  109  A specific number of host variables/SQLVARS is expected for  
the current SQL statement.  

  110  The LOB locator is not associated with a LOB of a compatible 
type.  

  111  A LOB is indicated by the SQLTYPE of the SQLVAR, but the     
second SQLVAR is null.  

  112  The SQLDATATYPE NAME field is not valid. It does not conform 
to the format for identifying an existing user-defined type in    
the database.  The format for identifying an existing             
user-defined type is as follows:  8  bytes, followed by a period,   
followed by  18  bytes.  

  113  The SQLFLAG4 field is not valid. If a structured type is     
specified the value must be X'12'. If a reference type is         
specified the value must be X'01'. Otherwise the value must be    
X'00'.  

  114  The DB2_TRUSTED_BINDIN registry variable is enabled, and an  
unsupported host variable data type is being used during bindin.  
Either unset the DB2_TRUSTED_BINDIN registry variable or change   
the data type of the input host variable.  

 In SQL statements with host variables, use the host variable 
number to count in from the beginning of the statement (or 
substatement, in the case of compound SQL) to locate the invalid 
host variable.  For statements using an SQLDA, the SQLVAR number 
is used to locate the invalid SQLVAR.  For an input SQLDA, count 
only input host variables or SQLVARs; similarly for output.  Note 
that this number is based at  1 .  

 The statement cannot be processed.  

User Response: 

Examine the application program for any errors noted.  Note that 
the programmer should not attempt to modify the precompiler 
output.  

 Federated system users: If you received reason code  102 , specify 
a supported data type and resubmit the program.  

 sqlcode :  - 804  

 sqlstate :   07002