ADSM-L

[ADSM-L] SQL Queries

2007-05-18 14:48:20
Subject: [ADSM-L] SQL Queries
From: Lamar Cope <llc0001 AT AUBURN DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 18 May 2007 13:32:31 -0500
Hello, I am new to TSM and the ADSM list.

I have a few questions if anyone would like to respond.

I am running SQL queries against the TSM database.
Some of these queries are not using indexes, and
are taking a long time to complete.

Questions:

How are these queries impacting normal operations (expiration,
migration etc.)?

Is it possible for these queries to cause a normal operation to fail
due to
resource contention?

Lamar Cope
Auburn University
Auburn Alabama

<Prev in Thread] Current Thread [Next in Thread>
  • [ADSM-L] SQL Queries, Lamar Cope <=