|
|
-
Jack Vamvas Commented 11 Months ago through Just Learned
Using non-sargable is a performance killer - and can be a reason why an optimizer will use a Clustered Index Scan . [Why does Query Optimizer choose a Clustered Index Scan? ][1]
[1]: http://www.sqlserver-dba.com/2012/06/why-does-query-optimizer-c...
|
-
Jack Vamvas Commented 11 Months ago through Just Learned
Using non-sargable is a performance killer - and can be a reason why an optimizer will use a Clustered Index Scan . [Why does Query Optimizer choose a Clustered Index Scan? ][1]
[1]: http://www.sqlserver-dba.com/2012/06/why-does-query-optimizer-c...
|
-
Jack Vamvas Liked 1 Years ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
Jack Vamvas Posted 1 Years ago through Syndicated Blogs
To return only severe messages
db2diag –merge db2diag.1.log db2diag.2.log -level severe ? Merge 2 dlog files filtering on severe
...
|
-
Jack Vamvas Posted 1 Years ago through Syndicated Blogs
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 ...
|
-
Jack Vamvas Posted 1 Years ago through Syndicated Blogs
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 usef...
|
-
Jack Vamvas Posted 1 Years ago through Syndicated Blogs
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 ...
|
-
Jack Vamvas Posted 1 Years ago through Syndicated Blogs
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_...
|
-
Jack Vamvas Posted 1 Years ago through Syndicated Blogs
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 ...
|
-
Jack Vamvas Posted 1 Years ago through Syndicated Blogs
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 ...
|