Search:
Type: Posts; User: amjain
Search: Search took 0.00 seconds.
-
08-24-2012, 11:15 PM
Thread: backupset - restore permissions
by amjain- Replies
- 1
- Views
- 429
backupset - restore permissions
Hi,
We are planning to change our archive strategy. Planning to do one time full backup and then create two backup sets, latter delete the backups. With this strategy we can have single tsm... -
03-12-2012, 02:31 AM
Thread: explain select query
by amjain- Replies
- 2
- Views
- 660
Hema,
Some more details...about my...
Hema,
Some more details...about my environment:
I kicked this backup via command line, no schedules used. Backup is still running. In my case the disk pool is small and backup is running from... -
03-12-2012, 01:47 AM
Thread: explain select query
by amjain- Replies
- 2
- Views
- 660
explain select query
Hi,
Can someone please explain this query:
tsm: server>SELECT entity AS "Node name", CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS "MB xfer", SUBSTR (CAST(min (start_time) AS char(29)),1,10) AS... -
03-11-2012, 06:28 PM
Thread: queries for 6.2.2 version of tsm server
by amjain- Replies
- 0
- Views
- 667
queries for 6.2.2 version of tsm server
Hi,
These queries work tsm version 5.3 but not for 6.2. Can you please assist:
{code}
Summary of Operations in a specific date (GB)
SELECT activity, cast(float(sum(bytes))/1024/1024/1024... -
03-11-2012, 12:04 AM
- Replies
- 1
- Views
- 812
migration threads for random access pool and backups issue
Hi,
I have to backup large data ~ 300TB and have small DISK POOL SIZE 500GB. I have 3 filespaces, backing up on single node. I am triggering multiple dsmc, dividing the filespace on directories.... -
02-23-2012, 08:40 PM
Thread: wild cards in select statement
by amjain- Replies
- 2
- Views
- 819
Thanks Harsh
Thanks Harsh
-
02-19-2012, 09:43 PM
Thread: wild cards in select statement
by amjain- Replies
- 2
- Views
- 819
wild cards in select statement
Hi,
I am trying to figure out, if select statement uses wild cards.
I want to find out all the tables having word *drm* in them.
Something like :
select * from syscat.tables where... -
02-19-2012, 12:27 AM
- Replies
- 5
- Views
- 3,351
Hi,
Can you please post the steps that were...
Hi,
Can you please post the steps that were done for the configuration.
Thanks
Amit -
01-25-2012, 08:55 PM
Thread: passowrd reset for operator id
by amjain- Replies
- 2
- Views
- 674
Thanks a lot.....
-Amit
Thanks a lot.....
-Amit -
01-24-2012, 05:40 PM
Thread: passowrd reset for operator id
by amjain- Replies
- 2
- Views
- 674
passowrd reset for operator id
Hi,
I want to reset the password for operator "alpha" , but not finding any command in update or set. No command as update admin ..or something. CAn you please assist.
Thanks
Amit -
01-08-2012, 03:08 PM
Thread: q archive details on server
by amjain- Replies
- 1
- Views
- 593
q archive details on server
Hi,
There is no query archive command ? How to see the the archive details for the node? q filespace f=d doesnt shows the date for archive.
Thanks
Amit
Results 1 to 11 of 11

