|
|
-
|
|
To return only severe messages
db2diag –merge db2diag.1.log db2diag.2.log -level severe ? Merge 2 dlog files filtering on severe
...
|
|
-
|
|
After you’ve installed the DB2 server – there may be a situation where you need to uninstall DB2.
These notes will help
db2_deinstall -F - Removes a feature from a DB2 database product in the current location. Execute the command from the DB2...
|
|
-
|
|
Nmon is a tuner and benchmark tool on Linux. Capture disk, cpu, memory , filesystem, resource usage, virtual memory
As a DB2 DBA it's a very effective method of capturing different types of in data in one interface.
nmon is useful ...
|
|
-
|
|
Q . How can I see the details of multipathing on a Red Had Enterprise Linux 5 server, using DM-Multipath? This is normally a prerequisite for a DB2 installation using SAN and Linux. The DBA can do a quick check
A. Use the multipath �...
|
|
-
|
|
This DB2 error message SQL2219N reason code 9 appeared in the db2 db2diag file.
The DB2 documentation details for reason code 9 are “START is not allowed as a prior paused table reorganization has not been stopped”.
I discovered there was a s...
|
|
-
|
|
First thing this morning – a request from a DBA to confirm if Differential BACKUPS can be restored on a database in SIMPLE RECOVERY mode. Yes , you can.
A few assumptions are made :
1) A Differential base exists
2) The Differential base is not a COPY_ONL...
|
|
-
|
|
Run and put "regedit.exe" and click "Ok";
2. Navigate to HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\i8042prt\Parameters in Registry Editor;
3. Add a new REG_DWORD "Headless" and set the value to 1;
4. Reboot the ser...
|
|
-
|
|
2012-03-14-21.59.22.121301+000 E1040722932E430 LEVEL: Severe
PID : 26754 TID : 182956718112 PROC : db2bp
INSTANCE: db2my NODE : 000
FUNCTION: DB2 UDB, bsu security, sqlexGetDefaultLoginContext, probe:150
MESSAGE : ADM1...
|
|
-
|
|
The System logs returned :
The device, xxxxxxxxxxxxxx, did not respond within the timeout period.
Some common causes
1) SCSI controller firmware
2) Incorrect transfe...
|
|
-
|
|
Transactions generate IO, latching and locking on tables and indexes , while attempting to access data. The sys.dm_db_index_operational_stats DMV returns aggregated data on this activity.
Warning : sys.dm_db_index_operational_stats returns data only as long ......
|
|