ASP.NET News from Blogger:
DBA DB2
Total News: 79
Question:How can I delete old archive logs from Tivoli Storage Manager (TSM) ?Ive confirmed the TSM backup client configuration for DB2 on Linux is all OKAnswer: The db2adutl command comes with DB2. T...
Question : I am seeing this SQL0911N Reason Code 68 message in my DB2 diaglog file:command : db2 backup db MYDB online use TSM include logs
SQL0911N The current transaction has been rolled back becau...
Question : In the db2diag.log file Im getting the the error messageVendor RC=0x00000019=25 -- see DB2 API Guide for meaning.2012-04-25-06.30.42.834149+060 I1209204241E814 LEVEL: Error
PID : 1...
QuestionThe following error log files appeared in the DB2 db2diag.log file. Along with failed to archive log errors . How do I find the DB2 return codes and TSM API return codes to pass onto the TSM s...
Question: These errors started appearing in the db2diag.log files for a production DB2 database. I have a process to Manage DB2 db2diag.log files.The daily DB2 onlinebackup was successful but failed ...
According to the DB2 documentation, the LOGINDEXBUILD database configuration parameter specifies whether index creation, recreation, or reorganization operations are to be logged so that indexes can b...
Question: I am getting the SQL2563W messages on a DB2 database restoreSQL2563W The restore process has completed successfully, but one or moretable spaces from the backup were not restored.How do I re...
Question. In vSphere 4.1 theres a limit of 8 virtual cores per guest. If the host has 24 cores available and I have only one other Virtual Machine(VM) using 8 virtual cores how can I utilise the rem...
After youve installed the DB2 server there may be a situation where you need to uninstall DB2.These notes will helpdb2_deinstall -F - Removes a feature from a DB2 database product in the current loca...
Nmon is a tuner and benchmark tool on Linux. Capture disk, cpu, memory , filesystem, resource usage, virtual memoryAs a DB2 DBA it's a very effective method of capturing different types of in data in ...
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 q...
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 b...
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 securit...
Q.What are the contents of a DB backup ?A. The items contained are dependant on the backup method , such as database or TABLESPACEUse the backup utility : db2ckbkp to interrogate the contents of a DB2...
This post discusses SORTHEAP DB2 and pinned pagesInformation message in db2diag.logFUNCTION: DB2 UDB, buffer pool services, sqlbKeepPagesPinned, probe:20
MESSAGE
: ADM6071I The maximum number of pinn...
A DB2 Incremental Restore recovery strategy requires:a) The full backup imageb) 0 or more incremental backupc) The days logsThe db2ckrst utility parses the history file and allows you to source the re...
A useful command for DB2 DBAs is the LIST UTILITIES command.It displays the list of active utilities.Examples of usage include : BACKUPS, RESTORES, performance issue, progress of RUNSTATS
[db2usr1@ser...
This article describes some methods of checking DB2 is running on a Linux ServerMethod 1Log onto the server and execute db2start as the instance owner. If the instance is running youll see , something...
You can look up any error message from the command line with ""db2 ? sqlxxxx"" (where xxxx is the SQLCODE with no sign and leading 0 to make it 4 digits long)You can also use db2 ? SQLxxxx | moreT...
I received the following error , when attempting to connect to a DB2 databasedb2 connect to MYDB
SQL1036C An I/O error occurred while accessing the database. SQLSTATE=58030
#Checked in the db2diag...
A quick method to use for executing a script on Linux start.After all the other processes are started by the init command at boot time, the script is run on Red Hat based systems:/etc/rc.d/rc.local
Ad...
By default , when creating a new DB2 database , the Log path is on the same drive as the data files.To change the log path , configure the NEWLOGPATH database parameterdb2 update db cfg for MYDB using...
In large Tivoli environments System Adminstrators prefer to manage the installation of the Monitoring AgentsAs a DBA you may need to exclude the ITMA from the DB2 server installation. Methods are:1) ...
Q. How do I calculate the DB2 instance startup time ?A. Use the dbm snapshotdb2 get snapshot for dbm |grep Start
See AlsoDB2 manager status and get snapshot for dbm...
Returns the values of individual entries in the database manager configuration file.
-- Get configuration values for instance
GET DATABASE MANAGER CONFIGURATION
-- Focus on
-- DFT_MON_BUFPOOL
-- HEALT...
The following message appeared in the db2diag.log
ADM4000W A catalog cache overflow condition has occurred. There is
no error b...
Within a database multiple SCHEMAS can exist. If a table or view exists in a schema different from the default SCHEMA of the logon and the reference to the object does not include a qualified na...
An unscheduled table reorganisation was occurring while attempting a db2sop .. db2start .
Upon restart of the instance and an attempt to connect to the database the following messag...
The SYSIBM.SYSDBAUTH maintains user privileges on databases
The SYSIBM.SYSPLANAUTH maintains user privileges on plans
The SYSIBM.SYSUSERAUTH maintain user privileges on the sys...
I completed a DB2 backup on server1 with the command:
db2 backup db sample online include logs
Backup successful. The timestamp for this backup image is : 20120106215500
There was a requ...
Question: Ive just been handed a new Linux Server build , on a new storage system. The RAID levels are different and the storage parameters have changed. I need to measure the IO performance of ...
Part of the Performance Tuning series Performance Stack , this section looks at Access Path Tuning. How does the user access the data and how can the access be maintained. The...
Tuning DB2 is critical if Websphere Portal is the main client. In larger Websphere Portal architectures , where load balancing is standard , this become obvious.
Follow these general guide...
2012 a new year . Im looking forward to it , on a professional and personal level.
Im already booked out for a lot of DB2 DBA work in the upcoming months. The projects require DB2 performance t...
When a DB2 database starts the total memory required for the bufferpools must be available.
If this memory is not available when a database starts, the database manager will only start with sys...
The Top 10 viewed DBA-DB2.com posts for 2011
1. DB2 Database code set
2. DIAGLEVEL db2
3. DBA personality Traits
4. POC
5. Database Tuning overview Storage Tuning
6. DB2 HADR and HADR_PEER_WIND...
Find bottlenecks in DB2 performance is part of maintaining good response times. Here's a useful approach to locating slow query response times. Focusing on scans
1) Run a user ...
While troubleshooting a DB2 performance problem for Websphere Portal 6.1.0 using DB2 9.5 Enterprise Edition , one of the DB2 tuning recommendations from the Portal Tuning guide...
The Environment Variable DB2_RR_TO_RS enables\disables the Repeatable Read attribute. I's enabled for DB2 performance purposes
DB2 registry parameter DB2_RR_TO_RS is used to:
Set a defaul...
When executing a DB2 backup command , an error message appeared
db2 backup db MyDB online use TSM include logs
SQL2033N An error occurred while accessing TSM during the processing of a
d...
For Tivoli Application Dependancy Discovery Manager (TADDM) to successfully discover DB2 instances, standardising OS and DB2 security access is the key, particularly for a large DB2 server...
The following commands are useful to gather Linux server information. The Linux system information is useful for such scenarios as : a) The Server Engineer requests a spec for a new Linux ...
The current DBA trend is increased database management requirements and less DBAs to manage.
Many factors are responsible , such as :
1) Global trends an...
Usually when the DB2 instance ends unexpectedly, trap files are created .There is usually one trap file capturing the root cause . A number of other files are created, supporting data abou...
Diaglevel refers to the Diagnostic error capture level configuration parameter.
There are 5 levels:
0 - No diagnostic data captured
1 - Severe errors only
2 - All errors
3 - All errors and ...
Storage Monitoring requires an end to end view. Consider the different types of drives and servers connecting to the sub storage system
Monitor Hard Drives
Controllers (CPU,Ca...
In 2013 PC install base will be 1.78 billionSmartphone install base to be 1.32 billion in 2013By 2013, 505 million enhanced phones with advanced browsers in useMobile phones will drive more web access...
Using Iometer with Linux requires a few extra steps than running it on Windows.
Iometer is a great tool , but aim to test on real-data. Consider testing on tools which simulate database server IO patt...
Youre experiencing a sudden slow down inDB2 performance. Users are complaining . Many reasons could be causing this sudden slowdown .ForDB2 problems, gathering and analyzing data is not enough. A lot ...
What would you think if a Senior Executive stated our goal is to own no IT assets by 2014. ?
This is a goal of many companies . If not a stated goal , it is on the agenda for conversations.
Why?
1)&n...
View Other bloggers