Search results

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

89 items matching your criteria.

Re: severe error in db2diag [1%] by perallis, 2008-05-07 06:12: Pawan, Take a look in the link below: http://www.dbatodba.com/Forums/db2/290851908/#171694765
Re: related adding new container for DMS TS command [1%] by perallis, 2008-05-02 13:29: Hello Pawan, Your alter tablespace command is right! Just to let you know. Container operations (ADD, EXTEND, RESIZE, REDUCE, DROP, or BEGIN ...
Re: getting too much locks and lock escalation?????????? [1%] by perallis, 2008-04-28 13:55: Pawan, In this case, your LOCKLIST VALUE is very low. Try to increase the LOCKLIST parameter to 1000 and monitor your database again. See the ...
Re: reorg on system tables and indexes? [1%] by perallis, 2008-04-28 13:15: Hello Pawan, Yes, you are right. SCHEMA NAME CARD OV NP FP ACTBLK TSIZE F1 F2 F3 REORG ...
Re: Percentage of Sorts That Overflowed [1%] by perallis, 2008-04-28 12:44: Hello Pawan From the CLP, you can obtain the Health indicator description and recommended actions by executing the following commands: GET ...
Re: getting too much locks and lock escalation?????????? [1%] by perallis, 2008-04-25 05:13: In the first moment, check the type of index you have: http://www.dbatodba.com/db2/how-to-do/how-to-identify-the-type-of-index-on-db2 If you have ...
Re: Need another forum for Suggestions & Feedback [1%] by perallis, 2008-04-22 09:26: Thanks Gnana for your suggestion !!! The forum was created!!! http://www.dbatodba.com/Forums/suggestions-to-the-dbatodba ...
How to add images into a page [1%] by perallis, 2008-04-22 09:14: Adding Images Using Kupu 1.4 Notes: The procedure given here is a generic procedure for adding images to dbatodba pages. After you have uploaded ...
How to add a table into a page [1%] by perallis, 2008-04-22 08:47: Adding and Editing Tables Using Kupu 1.4 Tables provide a convenient way to present information in an orderly way. The sections below provide ...
Re: changed cfg parameter??? [1%] by perallis, 2008-04-18 10:18: Hi Pawan, To set CATALOGCACHE_SZ back to value "MAXAPPLS*4" you have to execute the command below: db2 update db cfg for <dbname> using ...
Re: What is better to have little and big primary logs or small and less primary logs? [1%] by perallis, 2008-04-18 06:26: Variant 1:LOGFILSIZ = 10000 LOGPRIMARY = 4 disk primary log capacity = LOGFILSIZ * LOGPRIMARY = 40000 pages In the Variant 1 you will have more perform ...
Re: Asynchronous pool data page reads ????????? [1%] by perallis, 2008-04-17 10:03: Hi Pawan, The "Asynchronous pool data page reads" indicates the total amount of time spent reading in data and index pages from the table space containers ...
Re: External Comm error [1%] 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 ...
Re: how to recover database on getting system crashed? [1%] by perallis, 2008-04-11 15:01: Hello Pawan, You have many options!!! If you don't get to connect on database, you will have to restore it. The basic restore command for ...
Re: how to recover database on getting system crashed? [1%] by perallis, 2008-04-11 06:36: Pawan, To create the same database on other system, please see the link below: How to create the same database on other system
Re: related health indicator history entry [1%] by perallis, 2008-04-11 04:14: Hello Pawan, When you use the show detail option will be display the historical data for each health monitor data element in the form of {(Timestamp, ...
Re: "SQLCA has already been built" [1%] by perallis, 2008-04-09 03:15: So, try to apply the fixpack 12!
Re: DB2 Health Monitor how to disable in db2 v8.2 [1%] 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 ...
Re: DB2 Health Monitor how to disable in db2 v8.2 [1%] by perallis, 2008-04-08 12:16: Pawan, In DB2 UDB Version 8.2, the db2hmon process is no longer controlled by the HEALTH_MON database manager configuration parameter, so if the db2hmon ...
Re: "SQLCA has already been built" [1%] by perallis, 2008-04-08 09:34: Possible workarounds: change the table cardinality. Cardinality might get DB2 to switch from a right outer hash join to a nested-loop join. This would ...
Re: what are archive logs in db2 [1%] by perallis, 2008-04-07 16:52: Archival logging : archived logs are logs that were active but are no longer required for crash recovery. Set USEREXIT to ON or LOGRETAIN to RECOVERY to ...
Re: getting top 5 most time consuming query [1%] by perallis, 2008-04-04 13:48: Pawan, you can use these consults : db2 "select TOTAL_EXEC_TIME/NUM_EXECUTIONS as EXEC_TIME, TOTAL_EXEC_TIME, NUM_EXECUTIONS, substr (STMT_TEXT, ...
Re: getting top 5 most time consuming query [1%] by perallis, 2008-04-04 07:26: I am checking ...
Re: difference between db2diag.log and instance.nfy file [1%] by perallis, 2008-04-03 02:56: yes , all event that happens at database and instance level, it is record in the db2diag.log and instance.log
Re: lock escalation [1%] by perallis, 2008-04-03 02:53: You need to kill the application that is holding locks! Please view the document below: ...
Re: How to catalog a remote database [1%] by perallis, 2008-04-01 17:02: Correct, those are the two simple steps to catalog a remote database on AIX. Just to remember,the value of parameter "SERVER ..." must the same value of ...
Re: ADM1832E error got ???? [1%] by perallis, 2008-04-01 07:03: The error code 24 means "The user exit program was not found". In your case, you are using USEREXIT to archive the logs "First log archive method ...
Re: difference between db2diag.log and instance.nfy file [1%] 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 ...
Re: Welcome [1%] by perallis, 2008-03-23 07:51: Hello Gnana, I really hope the DB2 DBA can post their doubts here, and the DBA to DBA community can help each other So, Everybody Welcome to DB2 Forum. ...

« Previous 30 items 1 2 [3]

DBA to DBA

Personal tools

Search results

Would you like your company to implement gamification into your security awareness program?