Personal tools
You are here: Home DB2
Navigation
Log in


Forgot your password?
 

Search results

Did you not find what you were looking for? Try the Advanced Search for more precise search options.

124 items matching your criteria. RSS Feed
"SQLCA has already been built" [20%] by db2dba, 2008-04-08 02:31
Hi,     I am seeing below error in db2diag.log file.Whats this and how to remove??? Its urgent plz. db2diag -time 2008-04-07-00.00.00.230520| ...
Confirming TCP/IP configuration for a DB2 instance [19%] by Perallis, 2008-03-21 08:36
Confirming TCP/IP configuration for a DB2 instance
getting too much locks and lock escalation?????????? [19%] by db2dba, 2008-04-25 02:41
Below are the parameters related to locks... Max storage for lock list (4KB)              (LOCKLIST) = 100 Interval for checking deadlock (ms)         ...
Error in db2 size procedure [19%] by kanakaraju, 2009-01-20 08:24
Getting the following error for a db , for rest all dbs under the same instance  it's working fine , any ideas anyone ? ...
Re: database security [19%] by spider007, 2008-08-21 01:53
I am not sure whether you got the response for this one or not, but here it is: 1. you have to add db2profile in the .profile of this new user C 2. ...
sqloLinuxDoesFHSupportAIO when AIO is enabled [18%] by Perallis, 2010-02-01 11:02
FUNCTION: DB2 UDB, oper system services, sqloLinuxDoesFHSupportAIO, probe:10 CALLED : OS, -, io_queue_init OSERR: EAGAIN (11) DATA #1 : File handle, ...
Re: Any one help? [18%] by kanakaraju, 2010-09-14 11:37
Previously Olivier Windels wrote: Hi, Are those federated databases or just two independent databases like for instance: one for homologation ...
Package Cache increase without limit [18%] by Perallis, 2009-12-07 11:41
db2 FLUSH PACKAGE CACHE DYNAMIC
Re: External Comm error [18%] by perallis, 2008-04-16 04:51
The 0x81360012 message is only informational, and can be ignored. It means communication failure when the authentication of a user has failed. Here are ...
How to migrate DB2 to Version 9 [17%] by Josana, 2009-02-02 15:17
The main steps for the migration v8 to DB2 v9. It is really an usefull and complete guide. I really encourage anyone that will perform or be involved in a DB2 ...
Re: db2explain and runstat [17%] by perallis, 2009-05-13 13:31
Example, for table staff and for query "select * from staff where id=10" Before you run the db2expln, you have to enable the explain tables, see the ...
How to get more memorary available on DB2 Server running on ZLINUX [17%] by Perallis, 2009-12-08 10:25
drop_caches
Re: New user creation on linux but not able to access db2 [17%] by perallis, 2008-07-28 01:02
Add the db2profile path in the home directory of the new user $ vi .profile Hello Pawan, You just need to add the db2profile path in the home ...
Re: DB2 Health Monitor how to disable in db2 v8.2 [17%] by perallis, 2008-04-08 12:18
Pawan, Did you recycle your instance after change the parameters ? If not, please recycle and let us know if disabled Health Monitor. If it doesn't ...
reorgchk issue.....with deadlock [16%] by db2dba, 2008-07-24 04:17
Dear All, Please look in my issue. I am running below command... db2 reorgchk update statistics on table all but throwing error SQL2310N The ...
Various DB2 failures may occur on Linux with kernel.randomize_va_space=1 [16%] by Perallis, 2011-01-26 10:17
Memory errors
How to verify that your database is ready for migration [16%] by Perallis, 2009-03-24 11:27
db2ckmig
How to create and use sequence on DB2 [16%] by Perallis, 2009-10-08 16:00
Re: difference between db2diag.log and instance.nfy file [16%] by perallis, 2008-04-01 05:36
Administration notification log - instance.nfy     When significant events occur, DB2 writes information to the administration notification log. The ...
Update parameter value from all your db´s [15%] by owindels, 2010-02-19 16:54
Based on another script, this one can update a parameter value for all the db´s you have in a single instance. To run it, supply parameter name and value.
SQL6030N and SQL6031N when starting / stopping an instance on UNIX/LINUX [15%] by rmunhoz, 2009-07-08 12:01
Hello everyone ! I just wanted to share a recent experience I have had with starting / stopping a DB2 instance. Every time I tried to do it I got the ...
Displaying the contents of a bind file using the db2bfd tool [15%] by Perallis, 2008-04-24 07:01
db2 not startint after license add [14%] by araujo70, 2010-11-10 10:23
After install license in db2 , db2start no load
AUTOMAINT_SET_POLICYFILE procedure can fail with a misleading error message. [14%] by elderibeiro, 2012-07-27 18:48
Setting up a user exit [14%] by Perallis, 2008-04-01 07:00
using the db2uext2.cdisk sample c program provided by DB2
Verifying if backup images are corrupted. [14%] by Perallis, 2008-03-21 06:38
To check if a backup image is corrupted, you can use the db2ckbkp command.
How to investigate a bad page in table space [14%] by Perallis, 2009-02-13 11:23
ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error" DIA8426C A invalid page checksum was found for page "".
How much log space is requeried during an online reorg ? [14%] by Perallis, 2009-04-07 15:00
How to use the Administration Server (DAS) [13%] by Perallis, 2008-05-14 06:28
How to use the Administration Server (DAS)
Dynamic XML from SQL Server [13%] by josana, 2009-01-29 17:53
In this article you have seen how to generate XML from a relational table using SQL server 2005 and with the introduction of the xml datatype in SQL we are ...
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls