Recent content by lcklee

thx so much T. Blom.

Hello All, I have issue following command in DB2 prompt: ======================================================= select * from ADM_ANNOUNCE where ann_id not in(select ann_id from ADM_ANNOUNCE_READ where user_id = 12) ======================================================= and then following...

The log show error 2055, is that error mesg SQL2055N ? If yes, the error is &quot;Unable to access memory from memory set <memory-heap>. A database utility was unable to access memory during processing. The utility stops processing. Can anyone tell me what happening and what action should be...

Sorry, I have make some mistake, the log is capture from the syslog with level user.error. The OS is AIX 3.4 and DB2 v7.2 There is only a JDBC connection connect to the db2, and it is use with the tomcat. The application running at the tomcat is stable, but I just notice that there are many...

I have receive many following log in the db2diag.log, Can anyone tell me what happened ?? ============================================================ DB2 (db2inst1.000) base_sys_utilities sqleriar reports: probe id 201 with error 2055 and alert num 0 extra symptom string provided: Error...

Can someone help me, I don know the meaning of the mesg below from db2diag.log. thx ========================================================== 2003-03-03-18.44.35.922888 Instance:db2inst1 Node:000 PID:39354(db2agent (JETDXTS1)) Appid:C0A89747.F9AF.030303104431 lock_manager sqlplnfd...

thx for all your reply. Let me talk about the background. I am using AIX DB2 and I have a java application run with the DB2. Now the application is run smooth, however I find that there are many DB2 log message in the AIX syslog. The log is the one I post at my question, I don know why DB2 send...

I have a application on AIX and it need to insert data to DB2 frequently. Now I find that the application encounter lock time out during the database performing full database backup. Is there any method to avoid this problem, since my application insert data all the time and it is hard to...

MarcLodge (Programmer) Feb 20, 2003 It could be something to do with the maximum number of locks as implied in this article (you have to find 2055 in it): http://www.cs.yorku.ca/~seela/db2/problem.htm hth Marc thx for reply, but the link require me login password. Can you also give me ? Calvin

Can someone tell me what wrong is this log mesg stands for ? my DB2 is work on AIX. Feb 19 00:59:23 sftpdb1 DB2[31406]: DB2 (db2inst1.000) INFO oper_system_services sqlofica reports: probe id 10 with error 2055 and alert num 0 Feb 19 00:59:23 sftpdb1 DB2[31406]: data: 53514c43 41202020...

Thx for your reply. I m beginner on the DB2, can you tell me where is the DB2 log ? I m using AIX with DB2. Moreover, my database only have one user since my application is java base and it connect to database by that user account. So who lock the account is not important. However, what I put...

Can someone tell me how to check the DB2 lock level or isolation level ?? Now, my application on DB2 encounter lock time out error. The application developer said the DB2's isolation level is &quot;Cursor Stability&quot;, how can I check that setting in database, moreover, how can I know the...