|
|
-
|
|
If attempting to add the Active Directory snap in to the Microsoft Management Console and you can’t see the Active Directory options in the Standalone snap ins – take the following steps:
1) Download the Administration Tools Pack – in my case it was the Windows 2003 Ad......
|
|
-
|
|
A developer asked me if he could install “microsoft.office.interop.excel.dll” on a Production database server. This dll is part of the Microsoft Excel 11.0 Object Library.
This would satisfy his requirement to run a transformation on an Excel file, as part of a SSIS job.
The database s......
|
|
-
|
|
The online definition is “An error occurred while accessing TSM during the processing of a database utility”.
The 610 code means the message catalog aka dscenu.txt can’t be found.
I see this error usually when a DBA configures TSM at the DB2 instance level.
When you configure......
|
|
-
|
|
I use this method to find files which grow – and trigger low disk space alerts.
There are cron jobs to maintain certain system logs and db2diag.log , but systems administrators execute packages for fix packs, monitoring agents for instance status, virus scanners and other utilities, which a......
|
|
-
|
|
This shell script creates an output file with every table size on every database of a DB2 instance.
The columns are : TABSCHEMA, TABNAME, DATA_OBJECT_P_SIZE, INDEX_OBJECT_P_SIZE, LONG_OBJECT_P_SIZE,
LOB_OBJECT_P_SIZE, XML_OBJECT_P_SIZE
The script checks to see if it’s a db2 hadr PRIM......
|
|
-
|
|
I encountered a windows locked file, while doing a TSM file backup causing an error. I used Handle, which identifies windows locked files.
I received the following message in the Event Viewer when File Incremental backups are taken.
ANE4007E (Session: 80258, Node: BRTM7030) Error
......
|
|
-
|
|
The regular comment passed by DBAs is “90 % of the overall db performance is based on the code written against it”.
There is truth to this comment, and large amounts are written on optimising queries on DB2 databases. DB2 database design physical supports logical database design.
Th......
|
|
-
|
|
I received a db2 Tivoli monitoring message, warning of disk space issues.
TRV_DB2_UsedSpace_Minor db2inst1:myserver:UD Fri May 13 16:57:21 2011
Description
I executed a Linux find command.
find /db2inst1 -type f -ls | sort -k 7 -r -n | head -10
The 10 biggest files in the directory /db2inst1......
|
|
-
|
|
DBA Interview Questions and Answers for a DB2 on Linux, Unix and Windows DBA focusing on Server Operations.
Describe the DB2 Database Configuration Parameter – SORTHEAP?
Defines the maximum number of memory pages used for private sorts or the maximum number of shared memory pages to be used......
|
|
-
|
|
Currently working on a Webspere Business Monitor application integrating with DB2
9.5 on Linux. I've made a few observations.One
that is interesting, particuarly as Webspere Business Monitor uses BLOBs\CLOBs,
relates to HADR and BLOB\CLOB replication.
Database logs are us......
|
|