Showing posts with label DB. Show all posts
Showing posts with label DB. Show all posts

Wednesday, July 25, 2012

How to show DB2 level - version on TSM server

Using command db2level we can list information about version of DB2 installed as part of TSM server.
user@host:/opt/tivoli/tsm/db2/bin> ./db2level
DB21085I  Instance "tsminst1" uses "64" bits and DB2 code release "SQL09074"
with level identifier "08050107".
Informational tokens are "DB2 v9.7.0.4", "s110330", "IP23236", and Fix Pack
"4".
Product is installed at "/opt/tivoli/tsm/db2".

Wednesday, January 5, 2011

Oracle Database 11g: Interactive Quick Reference Guide to Oracle Database 11g Release 2

Oracle Database 11g: Interactive Quick Reference Guide to Oracle Database 11g Release 2 

Top DBA Views: Key DBA static data dictionary views and dynamic performance views organized by product feature areas
Architecture: A single diagram that illustrates the relationships between key database memory structures, processes, and storage
Background Processes: A comprehensive list that categorizes the background processes and flags which are new in Oracle

Download the Oracle Database 11g Interactive Quick Reference

Source: Oracle's Database Application Developer Newsletter

Wednesday, November 10, 2010

ORA-00600 [Librarycachenotemptyonclose] Reported At Shutdown

I've experienced this problem so I hope that it will be usefull...
My version: 10.2.0.3 (10.2.0.1 to 10.2.0.4)
Symptoms:
Alertlog:
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
Trace file:
Starting by line "----- Call Stack Trace -----" check if you see this functions:
kglshu kqlnfy kscnfy ksmshu
opistp_real opistp opiodr ttcpip opitsk opiino opiodr opidrv
sou2o opimai_real main libc_start_main
Cause:
Non-critical bug during database shutdown.
Workaround:
Run sql command before shutdown:
sqlplus / as sysdba
alter system flush shared_pool;
You can also create shutdown trigger to automatically invoke this action.

Thursday, October 7, 2010

How to recover one table from dump in MySQL

If you do dumps just of one table on regular basis then you are happy man :-)
  1. Backup of one table:
    # mysqldump -u username -p password > /path/file.sql
  2. Restore one table:
    # mysql --user=username --pass=password --host=localhost db_name < /path/file.sql
If you do dumps of whole DB then do following:
Backup of DB:
  1. # mysqldump -u username -p password > /path/file.sql
Restore of one table from dump of DB:
  1. We have to know where one table starts and where ends:
    # grep -n 'Table structure' /path/file.sql
  2. Then we have to separate part of file with required table into new file using line number gathered in previous command (where 7506 is start and 17684 is end):
    # sed -n '7506,17684 p' /path/file.sql > /path/new_file.sql
  3. Then we can restore it into DB:
    # mysql --user=username --pass=password --host=localhost db_name < /path/file.sql