Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

FileAID Installation getting SQLCODE -311

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> HomeWorks & Requests
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    Post subject: FileAID Installation getting SQLCODE -311
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10255
Location: italy

PostPosted: Thu Apr 29, 2010 11:11 pm    Post subject: Reply to: FileAID Installation getting SQLCODE -311
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
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNC1K11/CCONTENTS

and to the page where the -311 SQLCODE is described
http://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

Senior Member


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

PostPosted: Fri Apr 30, 2010 4:49 pm    Post subject: Re: FileAID Installation getting SQLCODE -311
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    IBMMAINFRAMES.com Support Forums -> HomeWorks & Requests All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fileaid 2 commands instream work. In ... descann Compuware & Other Tools 2 Tue May 16, 2017 3:31 pm
No new posts Fileaid Update Replace with null string descann Compuware & Other Tools 4 Mon May 15, 2017 3:00 pm
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am
No new posts Using Field names in FILEAID Batch CO... Atul Banke Compuware & Other Tools 2 Wed Jun 29, 2016 9:54 pm
No new posts FileAid to compare(logical operations... anand1204 Compuware & Other Tools 3 Wed Apr 06, 2016 2:55 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us