|
|
-
|
|
Using: platform Powershell 2 CTP & Excel 2003
I was troubleshooting a Powershell problem –- on a script that creates a Excel spreadsheet. All worksheets up to 4 were OK- but soon as I past 5 the following error was displayed.
Exception getting "Item": "Invalid index. (Exception from HRES......
|
|
-
|
|
After a period of usage – quite often I see these type of messages on the monitoring reports.
USERSPACE1 in MYDB has 98 pct used. Instance: MyInstance
The first step I take is:
Db2 connect to MYDB
db2 list tablespace containers for 2 show detail.
Tablespace ID ......
|
|
-
|
|
This message appeared on the error logs this morning:
“Backup of MYDB failed. ACO5422E Received the following from the MS SQL server: An exception occurred while executing a Transact-SQL statement or batch. BackupVirtualDeviceSet::SetBufferParms: Request large buffers failure on backup device......
|
|
-
|
|
One of our system administrators – who manages the Integrated Tivoli Monitoring Applications (ITMA) - noticed that the ITM package that ships with DB2 V95 was installed.
As he manages separate installs of ITM – the request was to uninstall the ITM from the particular Linux Server.
Un......
|
|
-
|
|
If you require a list of every index on every table on a database use the query below
SELECT
T.[name] AS [table_name], I.[name] AS [index_name]
FROM sys.[tables] AS T
INNER JOIN sys.[indexes] I ON T.[object_id] = I.[object_id]
WHERE I.[type_desc] 'HEAP'
ORDER BY T.[name], I.[index_i......
|
|
-
|
|
Quite often, this question appears on forums or on various jobs."Is there any way that I can tell when a stored procedure was last executed or who executed it? Is there any execution history that I can look at?"
The following query will assist in telling you what time a stored procedure was last ex......
|
|
-
|
|
Focus on the following areas:
1)OLE Automation usage that is causing VAS pressure\fragmentation
2)Excessive Linked Server Usage
3)Custom Extended Stored Procedure
4)3rd Party Backup Application (such as Redgate SQL Backup) using to large of a Network Packet Size.
5)Your applications are connec......
|
|
-
|
|
Step 1 - connect to the db, and run the following command.
select
substr(reg_var_name,1,24) as reg_var_name,
substr(reg_var_value,1,12) as reg_var_value,
level
from table(sysproc.reg_list_variables()) as registryinfo
this will return:
REG_VAR_NAME REG_VAR_VALUE LEVEL
-----......
|
|