Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
what is the softmax,mincount(db cfg)
sorry!! not mincount,mincommit(db_cfg) -
what is the softmax,mincount(db cfg)
what is the softmax,mincount in db cfg ? I can't understand! -
What is the db2kmapp.cur?
hi all! I installed the PATROL(for DB2® Universal Database) in my server. What is the db2kmapp.cur? Is it the file? in my server,I can't find db2kmapp.cur -
What's the mean "NOTRUNCATE TABLE"?
I reorgnize online my table.(online reorg) db2 "reorg table TEST INPLACE ALLOW WRITE ACCESS NOTRUCATE TABLE START" Um.. "NOTRUNCATE TABLE" I can't understand this option. What's the mean "NOTRUNCATE TABLE -
the strange message in db2diag.log
hi all! 2006-09-06-22.01.34.183570+540 I5679485A498 LEVEL: Error PID : 655366 TID : 1 PROC : db2agent (AMISDB) 0 INSTANCE: amisinst NODE : 000 DB : AMISDB APPHDL : 0-553 APPID: AC1F205E.J009.01B346130038 FUNCTION: DB2 UDB... -
Error message in db2diag.log after restore of database.
Hi all, After a full offline restore of my dev database which reported as completed successfully, I have got the following messages in db2diag.log. Can anyone please help me understand these error messages and what is the impact on my database? 2006-01-06-10.35.56.272155+240 I7308494A422... -
DB21006E The input command is too long. The maximum length is 65535.
Hi, I would like to know whether I can increase the size of the SQL statement in DB2 because I am getting the following error message: DB21006E The input command is too long. The maximum length is 65535. Some applications inserts blobs or clobs in one sql statement. If I can change the sql... -
SQL0332N error problem
hi all I have big problem. my db is AIX5.3 DB2V8.2(FixPack 12) and DCS catalog AS/400(5.1 830) the problem is: As/400->table nickname:web400.s@ch01a(federate wrapper) AIX5.3 DB2V8.2->SNDCH01A COLUMN->RECSTS(char(1)) db2 " insert into web400.s@ch01a(RECSTS) select RECSTS from SNDCH01A fetch... -
SQL0304N Problem(AS/400 zoned,packed decimal)
hi all I have big problem. my db is AIX5.3 DB2V8.2(FixPack 12) and DCS catalog AS/400(5.1 830) the problem is: As/400->table nickname:web400.s@ch01a(federate wrapper) AIX5.3 DB2V8.2->SNDCH01A COLUMN->RECSTS(char(1)) db2 " insert into web400.s@ch01a(RECSTS) select RECSTS from SNDCH01A fetch... -
SQL0304N Problem(AS/400 zoned,packed decimal)
Hi All! My DB is AIX5.3 DB2V8.1(FixPack10) And DCS catalog AS/400(AS/400 830 OS/400 ver 5.1.5) I only execute " select CODE(type:Decimal) from COMLIB.TB00Z" , SQL0304N A value cannot be assigned to a host variable because the value is not within the range of the host variable's data type. -
SQL2025N An I/O error "-40" occurred on media "TSM".
hi all! While I restore db redirect, the error occured. SQL2025N An I/O error "-40" occurred on media "TSM". in db2diag.log 2006-05-20-11.32.25.208470 Instance:crmsprod Node:000 PID:20790(db2med.36982.1 0) TID:1 Appid:none database utilities sqluMCReadFromDevice Probe:102 Media... -
Locks held by application=4294967293(application snapshot)
Hi all! when I only connect to mydb,Locks held by application=4294967293(app snapshot). Also " select count(*) from TABname" like Locks held by application=4294967293(app snapshot). Snapshot Bug? Locks held(lock snapshot)=0
