IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

FileAID Installation getting SQLCODE -311


IBM Mainframe Forums -> HomeWorks & Requests
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
oesler

New User


Joined: 29 Apr 2010
Posts: 1
Location: Brazil

PostPosted: Thu Apr 29, 2010 10:59 pm
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Thu Apr 29, 2010 11:11 pm
Reply with quote

read about -311 SQLCODE in the db2 manuals
and reach Your own conclusions

We do not own the application, so very little we can do

to save some of Your precious time here a link to the relevant db2 manual
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNC1K11/CCONTENTS

and to the page where the -311 SQLCODE is described
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dsnc1k16/3.2.121?ACTION=MATCHES&REQUEST=311&TYPE=FUZZY&SHELF=&DT=20091012143256&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

does not make any difference if the DB2 version is different the conclusions would be the same
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Fri Apr 30, 2010 4:49 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> HomeWorks & Requests

 


Similar Topics
Topic Forum Replies
No new posts Search two or more word with FILEAID Compuware & Other Tools 15
No new posts z/vm installation problem All Other Mainframe Topics 0
No new posts Generate output lines (SYSIN card for... DFSORT/ICETOOL 4
No new posts zOS COD installation under zVM All Other Mainframe Topics 0
No new posts How to move DB2 Installation HLQ DB2 4
Search our Forums:

Back to Top