Internal Error Type 3107
V7R1, but not V6R1 From: CRPence
V7R1, but not V6R1 From: Charles Wilt
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers http://stackoverflow.com/questions/11185150/ibmdb2-simple-query-error-901-system-error or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x http://www.progtown.com/topic678625-error-901-not-clearly-what-to-do.html Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up IBMDB2 simple query error 901 - system error up vote 2 down vote favorite I'm working on a IBM iseries v6r1m0 system. I'm trying to execute a very simple query : select * from XG.ART internal error where DOS = 998 and (DES like 'ALB%' or DESABR like 'ALB%') The columns are: DOS -> numeric (3,0) DES -> Graphic(80) CCSID 1200 DESABR -> Garphic(25) CCSID 1200 I get : SQL State : 58004 SQL Code : -901 Message : [SQL0901] SQL System error. Cause . . . . . : An SQL system error has occurred. The current SQL statement cannot be completed successfully. The error will not prevent other SQL statements from being processed. Previous messages internal error type may indicate that there is a problem with the SQL statement and SQL did not correctly diagnose the error. The previous message identifier was CPF4204. Internal error type 3107 has occurred. If precompiling, processing will not continue beyond this statement. Recovery . . . : See the previous messages to determine if there is a problem with the SQL statement. To view the messages, use the DSPJOBLOG command if running interactively, or the WRKJOB command to view the output of a precompile. An application program receiving this return code may attempt further SQL statements. Correct any errors and try the request again. If I change DES into REF (graphic(25)), it works... EDIT : I run some tests this afternoon, and it is very strange : Just after the creation of the table/indexes, I have no errors. If I insert some datas : error If I clear the table : error If I remove an index (see below) : it works (with or without datas) !! The index is : create index XG.GTFAT_ART_B on XG.ART( DOS, DESABR, ART_ID ) Edit 2 : Here is the job log (sorry, it is in French...) It sais : Function error X'1720' in machine instruction. Internal snapshot ID 01010054 Foo file created in library QTEMP. *** stuff with the printer DBOP *** FAILED open. Exception from call to SLIC$ Internal error in the query processor file Sql system error sql db2 ibm-midrange share|improve this
901.... Not clearly what to do.... Pages 1 You must login or register to post a reply Topic RSS feed Posts [ 15 ] 1 Topic by TORT 2012-06-14 11:20:30 TORT Member Offline Registered: 2012-06-15 Posts: 954 Topic: Error 901.... Not clearly what to do.... From some time by a serial call of successively several procedures the server produces2006-02-08-15.13.24.796000+180 I966H455 LEVEL: ErrorPID: 3672 TID: 1964 PROC: db2syscs.exeINSTANCE: DB2 NODE: 000 DB: DBASEAPPHDL: 0-496 APPID: C0A82D82.FC05.010B48120727FUNCTION: DB2 UDB, access plan manager, sqlraFixupSqlDD, probe:5MESSAGE: Out sqlz_valueDATA #1: Hexdump, 12 bytes0x76621534: 0101 A00F 0100 E304 D000 0000............2006-02-08-15.13.25.234000+180 I1423H388 LEVEL: ErrorPID: 3672 TID: 1964 PROC: db2syscs.exeINSTANCE: DB2 NODE: 000 DB: DBASEAPPHDL: 0-496 APPID: C0A82D82.FC05.010B48120727MESSAGE: In sqlz_valueDATA #1: Hexdump, 12 bytes0x766214C4: 0101 C800 0100 E304 0800 0000............2006-02-08-15.13.25.234000+180 I1813H425 LEVEL: SeverePID: 3672 TID: 1964 PROC: db2syscs.exeINSTANCE: DB2 NODE: 000 DB: DBASEAPPHDL: 0-496 APPID: C0A82D82.FC05.010B48120727FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:20RETCODE: ZRC=0x8012006D =-2146303891=SQLR_CA_BUILT"SQLCA has already been built"2006-02-08-15.13.25.234000+180 I2240H709 LEVEL: SeverePID: 3672 TID: 1964 PROC: db2syscs.exeINSTANCE: DB2 NODE: 000 DB: DBASEAPPHDL: 0-496 APPID: C0A82D82.FC05.010B48120727DATA #1: SQLCA, PD_DB2_TYPE_SQLCA, 136 bytessqlcaid: SQLCA sqlcabc: 136 sqlcode:-901 sqlerrml: 16sqlerrmc: bni/bno mismatchsqlerrp: sqlrafudsqlerrd: (1) 0x00000000 (2) 0x00000000 (3) 0x00000000(4) 0x00000000 (5) 0x00000000 (6) 0x00000000sqlwarn: (1 (2) (3) (4) (5) (6)(7 (8) (9) (10) (11)sqlstate:Well and the message that a pier an error 901, but do not worry, it is possible to work....Where to look prompt? 2 Reply by TORT 2012-06-14 11:23:30 TORT Member Offline Registered: 2012-06-15 Posts: 954 Re: Error 901.... Not clearly what to do.... System Win2003 Server..... 3 Reply by TORT 2012-06-14 11:24:31 TORT Member Offline Registered: 2012-06-15 Posts: 954 Re: Error 901.... Not clearly what to do.... Version 8.1.9..... 4 Reply by SunnyVa 2012-06-14 08:54:31 SunnyVa Member Offline Registered: 2012-04-23 Posts: 113 Re: Error 901.... Not clearly what to do.... Too faced this error and I do not know how to be ...The version: DB2 UDB for iSeries (AS/