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".
Showing posts with label DB. Show all posts
Showing posts with label DB. Show all posts
Wednesday, July 25, 2012
Monday, March 7, 2011
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
Download the Oracle Database 11g Interactive Quick Reference
Source: Oracle's Database Application Developer Newsletter
![]() | 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:
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 :-)
Backup of DB:
- Backup of one table:
# mysqldump -uusername -p /path/file.sqlpassword > - Restore one table:
# mysql --user=username --pass=password --host=localhost db_name < /path/file.sql
Backup of DB:
- # mysqldump -u username -p password > /path/file.sql
- We have to know where one table starts and where ends:
# grep -n 'Table structure' /path/file.sql - 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 - Then we can restore it into DB:
# mysql --user=username --pass=password --host=localhost db_name < /path/file.sql
Subscribe to:
Posts (Atom)


