Forgot your password?
DBA experiences
How to use the DBA to DBA
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.
- Re: How to Stop One Database Under Single Instance?? [13%] by perallis, 2008-05-12 08:39
- Example: db2 connect to sample Database Connection Information Database server = DB2/NT 9.5.0 SQL authorization ID = PERALLIS Local ...
- Mirror online DB with automated rollforward. [13%] by owindels, 2011-08-02 18:34
- Imagine you have a huge DB which cannot be stopped to mirror with db2inidb or alter instance parameters, maybe this little script will help you.
- SQL0805N Package NULLID.SYS* was not found. [13%] by Perallis, 2011-01-25 10:37
- There might be instances where applications do not close their cursors after they are done with them.
- Transactions Log Full [12%] by Perallis, 2008-03-17 03:20
- Applications are using all primaries and secondary logs and the database stops to run.
- DS400 Storage Performance with Oracle [12%] by Perallis, 2008-03-26 00:07
- Performance sizing guideline for Storage SubSystems
- HADR and TSA [12%] by Perallis, 2011-01-17 11:37
- Dlconn for event monitor DB2DETAILDEADLOCK - MAXLOCKS [12%] by Perallis, 2009-11-04 15:35
- Dlconn for event monitor DB2DETAILDEADLOCK truncated by 134065 bytes! Deadlock ID: 25 Participant:1 Original locks in list: 807. Redefine the event ...
- How to check the db2 version for a backup image [11%] by Perallis, 2010-02-08 14:47
- using the command db2ckbkp
- How to read db2diag.log file [11%] by Perallis, 2008-06-10 10:56
- When an error occurs, the db2diag.log file is updated with information about the error.
- How to discover the maximum numbers of connection has been reached [11%] by jrgrazia, 2008-06-10 10:05
- Steps you should perform to find the maximum numbers of active connections that a database support and if this number has been reached
- SQL1224N - DB2 has terminated your connection [11%] by Perallis, 2009-02-15 13:52
- The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated your particular request due to an error ...
- How to set DB2 Governor Config File [11%] by Perallis, 2009-05-25 09:38
- How to use DB2 Federation [11%] by Perallis, 2009-05-07 10:03
- wrapper -> server -> user mapping -> nickname
- Re: How to Stop One Database Under Single Instance?? [11%] by perallis, 2008-05-12 08:35
- Hello Pawan, You do that executing the followings commands: db2 connect to <dbname> Where <dbname> is the database name you desire no ...
- Capture: Error reading DB2 log [10%] by Perallis, 2008-04-09 05:34
- The DB2 transaction log changes needed by capture process can’t be read
- How to use Connection Concentrator [10%] by Perallis, 2009-01-17 19:42
- DB2 EEE Quick Guide [10%] by rmaglio, 2008-05-13 06:35
- This guide will help you to do your first steps to administrate a partitioned database
- SQLO_QUE_BAD_HANDLE "Bad Queue Handle" [10%] by Perallis, 2010-05-24 15:52
- MESSAGE : ZRC=0x870F003E=-2029060034=SQLO_QUE_BAD_HANDLE "Bad Queue Handle" DIA8555C An invalid message queue handle was encountered.
- DMS Tablespace is Full [9%] by eduhl, 2008-03-23 08:57
- Tablespace has reached it's limit size. Unable to allocate new pages in table space.
- db2gov - DB2 Governor Command [8%] by rmaglio, 2009-05-25 09:32
- General Syntax and Useful Tips to use DB2 Governor
- Connection Broken - QueryTimeoutInterval [8%] by Perallis, 2010-08-20 14:43
- Problem Description
- How to calculate BPHR,PCHR and CCHR [8%] by db2dba, 2008-05-05 01:04
- How to work with TSM commands [8%] by Perallis, 2010-08-11 11:10
- The most commons TSM commands used to work as DBA
- How to alter shmall and shmmax kernel parameters on LINUX [7%] by Perallis, 2009-03-05 16:30
- SHMMAX is the maximum size of a shared memory segment on a Linux system whereas SHMALL is the maximum allocation of shared memory pages on a system
- db2diag - db2diag.log analysis tool command [7%] by rmaglio, 2008-04-25 08:23
- Parameters to use the db2diag tool to analyze your db2diag.log file
- Transaction Logs Filesystem is Full [7%] by rmaglio, 2008-06-10 11:49
- The error occurs when the transactions log's filesystem is full
- Restoring a table in a db2 EEE [6%] by danilocpereira, 2009-03-25 12:00
- A step by step of how to restore a table in a db2 EEE.
- Monitor CPU, MEM and I/O usage [6%] by Perallis, 2008-04-25 13:46
- AIX utilities and commands which you can use either to analyze the issue
- How to Increase a DMS Tablespace [6%] by rmaglio, 2008-04-25 00:43
- This topic shows you how to increase a Database-Managed tablespace
- package cache hit ratio is so less???? [6%] by db2dba, 2008-07-21 08:22
- Hi , i am facing problem in package cache hit ratio its between 37-45% which is very less. here are my database configuration snapshot Database ...
Hacker Rangers - Gamification for CyberSecurity