I need some help. The problem is very strange.
Environment:
We are running DB2 8.1 FP-3 on AIX 5.1. We have a external
vendor's application [we cannot control it] which talks to DB2.
Problem:
The application runs fine for 2 or 3 days. But after that
the swappping goes on increasing and...
Thanks all for your replies.
I appreciate your time and suggestions.
Gregsimpson,
Do you mean to increase SORTHEAP or SORTHEAPTHRESH.
MarcLodge
Yes, the DB2 returns 911 error saying that the Deadlock has been detected. But I want to create that situation. Any ideas...
Thanks.
Hi ,
I have a problem in granting the privilegs to one of our users.
One of our users cannot execute the system functions like LEFT, RIGHT,etc of SYSFUN schema. When I tried to grant EXECUTE permission, I got the error as
[IBM][CLI Driver][DB2/AIX64] SQL0607N "GRANT OR REVOKE"
is not defined...
Thanks Stevexff & MarcLodge for your suggestions.
I really appreciate your time and suggestions.
I want to simulate the sort and want it to be driven to disk to create heavy io. I am having the following steps:
1. create a huge table without index.
2. Reduce the bufferpool size.
3. select all...
Hi,
We are in a process of upgrading our DB2 from 8.1 to 8.2. Can anybody tell me the process-steps involved or is there any procedures listed out. Also, if it fails how to revert back to 8.1. I have done DB2 Upgrade in Windows, but could not find a step to how to revert back to old verion.
We...
Thanks Greg.
For migration from 8.1 to 8.2 [stinger] we need to backup the database. Does this size be helpful.
Als, Any idea of how to revert back if the migration fails.
Thanks
Can anybody pls tell me how to find the database size in DB2. If I include all the tablespaces, then unused pages also get included.
Thanks in advance
gbag
Hi,
Need some help in sortheap configuration.
I am getting large amount of error as below:
Sortheap too large, trying smaller merge width.
0x0FFFFFFFFFFFAEC0 : 0x00000056
I can reduce the sortheap. Is there any other parameter(s) that I need to change [sortheapthres] along with this.
I...
Can anybody pls tell me as '
When you declare a Global Temporary table in a Stored Procedure, in which space it will be created'
I am getting permission error. I feel that I have given permissions to all but still want to find out the difference.
thanks in advance
gbag
Hi,
I am having problems with resource-locking issues. We had the CPU-bound and Memory-Bound situation. When we looked at the processes, there were lot of db2agent (idle) processes.
This we saw even when all the applications were disconnected. Are these processes the cause for the resource...
I am considering both the cases.
One with similar systems and another case with Linux to Windows. Right now we are doing for the second case, a db2move turning off the logging.
Thanks
Hi,
I need some help in restoring the db.
I have db [samp] on one system. I have taken the offline backup of that. Now I want to restore it onto another system with the name as sample.
The two systems are are similar. Can anybody tell me the exact command to do this.
When I tried to restore...
Hi,
I need some help in updating current table with the info of another db on another instance.
I need to read some data from one DB [db1] and update [and insert] another database [db2]. Both the databases are on different systems [s1 and s2]. On one of the systems I can see connect to both...
Thanks all for your great suggestions.
Blom0344- The full table scan is performance drag because,- even after we have shown a good path [index path], it is not using that, AND,
IF it has to scan the full table let it go through our index path.
For your suggestion for 'BETWEEN' and 'NOT IN', I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.