View previous topic :: View next topic
|
Author |
Message |
oesler
New User
Joined: 29 Apr 2010 Posts: 1 Location: Brazil
|
|
|
|
Hi all,
We'r installing FileAID V6R1 but it's failing with SQLCODE -311 when trying to run the following job;
"SDDB2.FD.V6R1M0.INSTALL(FD$T08)".
We current have DB2 V7, and according to Compuware, FileAID V6R1 should work with DB2 V7. Once DB2 V7 is not supportable any longer, we don't know if maybe some PTF should be applied on DB2 before installing FileAID.
Below are current STEPs execution;
16.56.35 JOB07194 SEC SEC MIN ----PAGING COUNTS---
16.56.35 JOB07194 JOBNAME STEPNAME PROCSTEP RC EXCP TCB SRB ELAPS SERV PG PAGE SWAP VIO SWAPS
16.56.35 JOB07194 SDDB2FDU BIND1 04 816 3.77 0.01 0.4 462K 0 0 0 0 0
16.56.36 JOB07194 SDDB2FDU CREATE 08 225 0.06 0.00 0.0 8566 0 0 0 0 0
16.56.36 JOB07194 SDDB2FDU DROPDX00 00 273 0.06 0.00 0.0 9054 0 0 0 0 0
16.56.36 JOB07194 SDDB2FDU INITDX00 08 323 0.07 0.00 0.0 9664 0 0 0 0 0
16.56.36 JOB07194 SDDB2FDU BUILD1 00 37 0.01 0.00 0.0 1292 0 0 0 0 0
16.56.36 JOB07194 SDDB2FDU BUILD2 00 46 0.01 0.00 0.0 1467 0 0 0 0 0
16.56.37 JOB07194 SDDB2FDU BUILD3 00 45 0.01 0.00 0.0 1501 0 0 0 0 0
16.56.37 JOB07194 IEF404I SDDB2FDU - ENDED - TIME=16.56.37
Error found on SYSOUT
SQLCODE = - 311
SQL : CREATE DATABASE DBFD610 STOGROUP SGFD610
DSNT408I SQLCODE = -311, ERROR: THE LENGTH OF INPUT HOST VARIABLE NUMBER 001 IS NEGATIVE OR GREATER THAN THE MAXIMUM
DSNT418I SQLSTATE = 22501 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXECP SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -320 0 0 32765 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFEC0' X'00000000' X'00000000' X'00007FFD' X'00000000' X'00000000' SQL DIAGNOSTIC
INFORMATION
SQIDCI 00998 REFER TO LAST SQLCODE FOR REASON FOR TERMINATING
I've seen another post related to SQLCODE -311 but this is different, once it's on FileAID installation.
Please, let me know if you need more detailed information.[/i]
Attachment deleted, does not convey any additional info |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
oesler wrote: |
We'r installing FileAID V6R1 but it's failing with SQLCODE -311 when trying to run the following job;
"SDDB2.FD.V6R1M0.INSTALL(FD$T08)". |
Why don't you contact Compuware Corporation? You've already paid for their product! |
|
Back to top |
|
|
|