|
|
-
|
|
Database size in DB2 - Find 3 methods I use to find the database size in DB2
METHOD 1 - GET_DBSIZE_INFO
============================
db2 connect to
db2 "CALL GET_DBSIZE_INFO (?, ?, ?, -1)"
METHOD 2a (in MB) snapshot_tbs_cfg
===============================
db2 connect to
db2 "select (sum(......
|
|
-
|
|
SQL Server xp_msver is a SQL Server system stored procedure, returning general sql server information I find it useful for gathering basic server build and server information. Run it as EXEC master..xp_msver
I use it when I need gather information for a SQL Server Inventory audit. I use the process......
|
|
-
|
|
SQL Server Database Size and Free Disk Space reporting is critical in high volume databases.
One of the modelling applications I manage, maintains a large SQL Server database inventory on one SQL Server 2005 Enterprise Edition instance. The application generates a database per modelling request. An......
|
|
-
|
|
DB2 get snaphshot for dbm displays the database manage level information.
Scanning the information available, you’ll notice instance monitor switches.
I use the Database manager status value to get the status. If no value is returned,
then I assume the instance is unavailable.
Repu......
|
|
-
|
|
SQL Server Automation is one of the best ways for a DBA to achieve more in less time. If a task is repeatable – then why run it manually?
A word of warning! There are automated jobs out in the SQL Server world that are causing more damage then help. I have seen plenty of Daily Shrink Databas......
|
|
-
|
|
I suggested to a client last week ,Query Tuning is required to troubleshoot some SQL performance issues. He wanted a definition of Query Tuning. I sent him an email,
defining a Query Tuning approach .These are notes from the email
What is Query tuning?
In practise, there are predeployment qu......
|
|
-
|
|
Reorg table DB2
Step 1
run reorgchk:
------CODE START---------------
db2 reorgchk update statistics on table all > output.out
------CODE END------------------</b>
Running the command this way will run across all tables rather than RUNSTATS across every table.
The reorgchk update statistics r......
|
|
-
|
|
DBA is a demanding job. Expertise is required at different levels – hardware, OS , Database Server and Application Layer. As pressure increases to give input at an operations and architecture level, remember the two primary tasks of the DBA is to maintain availability and performance.
These a......
|
|
-
|
|
Windows Server Uptime and the last time a Windows Server restarted, on a database server is useful information. As well as SQL Server I do also manage some DB2 Server on Windows - which has different information available for server level information. Net Statistics Server displays the details.......
|
|
-
|
|
Powershell for SQL SMO has fantastic potential. Robert Matthew Cook left me some code on SQL Server xp_msver - seeing if I was interested on expanding.
The Server Object offers SQL Server Instance Information
[Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | Out-Null
$S......
|
|