|
|
-
|
|
The dynamic management view (DMV) sys.dm_exec_requests returns information about each request that is executing within SQL Server.
Instead of using Activity Monitor to view the status of a Rollback, use this T-SQL code.
Activity monitor is based on window panes and is cumbersome to export any inf......
|
|
-
|
|
Developers like to have some control over the development process. An example is index building. Asking a DBA repeatedly for changes to a Development Database might not be the best use of time – for either parties.
For example, a developer may want to work over the weekend to finish a Data Impor......
|
|
-
|
|
I typed the Linux Command GET DBM CFG
into my Putty console – rather than db2 GET DBM CFG and web page code was
returned. That’s interesting!
The GET program is used to send requests to www servers. There are various switches,
such as:
-b This URI will ......
|
|
-
|
|
DBA Interview Questions and Answers for a DB2 on Linux, Unix and Windows DBA focusing on DB2 Security Management
Read the DB2 Security Notes for checklists on DB2 Authentication Types, Authorities, DB2 Privileges, Object
Privileges, GRANT & REVOKE usages
What is the purpose of Authoriti......
|
|
-
|
|
When the infrastructure database server design has finished – logical and physical
design, details of the target design should be documented. My focus is on database
servers, but similar issues relate to all technology platforms.
The database design includes the Logical ......
|
|
-
|
|
Example of DB2 backup online
db2 backup database online use TSM
Read the DB2 documentation for a full list of parameters
DB2 backup online only works if: a)logretain is enabled or b)userexit is enabled.
If not you could see an error message DB2 SQL2413N - Online backup is not allowed
While onli......
|
|
-
|
|
HNT5QSPZ6P93
The following code will create a DDL of an existing table. If you don't need to create an output file omit the use of the -o option.
db2look -d MY_DB -a -e -x -o MY_FILE.sql
Republished from http://www.dba-db2.com/.......
|
|
-
|
|
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.......
|
|
-
|
|
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......
|
|
-
|
|
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......
|
|