Search results for query: *

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...

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...

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...

Can anybody pls tell me how to simulate the SORT and Deadlock in DB2. Thanks in advance Gbag

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...

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...

Hi, I am trying to optimize some SQLs. When I saw the plan, it showed me as 'Full Table Scan'. For this I created the index and in the next plan it did not considered index in its plan, but astonishingly it showed me the newly created index along with the other indexes. Again it is showing the...

Hi, I am executing a SQL on a system that has 2 CPUs and sufficient memory. It runs very slow. The same SQL runs very fast in a very similar another system. I checked the environment, onconfig differences. There is no difference. When I looked the sar output, it shows 50% idle all through the...

Hi, I have a strange situation. Need some help. I executed the db2expln command on a simple SELECT statement [select * from emp where emp_id=10]. In the output it said the isolation level as Cursor Stability [CS]. This is fine. But when I did the same thing with the sql statement as "select *...

Hi, I have two instances and having 2 databases in each instance on the same machine. Is it possible to connect to two databases of different instances with a single profile [.profile] or single environment. Thanks in advance. Gbag

Hi, Can anybody tell me how to find the who is doing what and where from the application id in DB2. [I got the application id and process id but not the ip-address]. Thanks

Hi, Can anybody pls tell me where to get the DB2 Systems catalog tables' chart [poster]. Thanks

Hi, I need some help. I am trying to load a table using the load command. The extracted data file, script both reside on the server. Whenever I run the command I am getting the error as SQL3025N A parameter specifying a filename or path is not valid. The SQL command is load from...

Hi, I am getting ^[[A in SQLPLUS whenever I try to recall previous commands using up-arrow key. The same thing works on Windows SQLPLUS. Is there any term setting that I need to do in order to make arrow-keys work. I set TERM to vt100, xterm. But none worked. Can anybody suggest me what value...

Hi, I am getting an error while loading data through SQLLOADER. Commit point reached - logical record count 12160 When this started, I typed control-c and aborted the process. It has not even loaded 1/4th of the data that is needed. Can anybody suggest me how to resolve this problem. Also, I...

Hi I installed the Sybase Adaptive Server 12.5. on windows-2000. But while configuring a new server it just hangs. In the error log, it doesnot say error. Instead it says the following messages [a part if it is given here] 00:00000:00001:2004/01/08 21:40:50.78 server Completed REDO pass for...