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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: gbag
  • Order by date
  1. gbag

    System slows down and will be alright after the bounce.

    Thanks Juliane. We are not using any blobs. What is the memory switch. Is it a DB2 configuration or .. Thanks for your help. gBag
  2. gbag

    System slows down and will be alright after the bounce.

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

    Simulating the SORT and Deadlock

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

    Problem in executing the RIGHT function of SYSFUN schema

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

    Simulating the SORT and Deadlock

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

    Procedure for upgrading the DB

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

    Simulating the SORT and Deadlock

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

    How to find Database size in DB2

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

    How to find Database size in DB2

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

    sortheap parameter problem

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

    which tablespace will be used for a Global Temp table in a Stored Proc

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

    resource-locking issues [may be caused by Idle Agents ]

    Thanks Sathyaram, Is more no. of agents bad for DB2 or for the system? thanks
  13. gbag

    resource-locking issues [may be caused by Idle Agents ]

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

    Communicating between two difft. databases on difft. instances

    I was thinking that federated servers are for communicating with different types of database servers with DB2. Thanks
  15. gbag

    Restoring the db to a new db

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

    Communicating between two difft. databases on difft. instances

    It did not work. Can you pls give me a working example. Thanks
  17. gbag

    Restoring the db to a new db

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

    I don't know a name for a tech of DB2

    connection concentrator. gbag
  19. gbag

    Communicating between two difft. databases on difft. instances

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

    Optimiser not showing the newly created index for Path

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

Part and Inventory Search

Back
Top