Re: q actlog

2002-05-30 Thread Burak Demircan
use SET ACTLOGRETENTION command [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 30.05.2002 09:11 Please respond to ADSM-L                 To:        [EMAIL PROTECTED]         cc:    

Re: q actlog

2002-05-30 Thread Slutsky, Boris
Hi, The reason why you get only 2 weeks old act log records, probably, is the retention period defined for activity log is 14 days. So, there are no more records in act log. Try to use SET ACTLOGRETENTION admin command to change it. Take into account that it influences DB size, because act log is

Re: TSM monitored by TME

2002-05-30 Thread Seay, Paul
We do not intend to monitor clients with TME. Just Media and Library issues. So we actually want to see all occurences. The default RLS does not compile. We are working on it. Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Ran Harel

Re: q actlog

2002-05-30 Thread Ruksana Siddiqui
Boris, Can I grab old actlog from my db backup , if so how - With regards, -Original Message- From: Slutsky, Boris [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 4:31 PM To: [EMAIL PROTECTED] Subject: Re: q actlog Hi, The reason why you get only 2 weeks old act log records,

Re: BACKUP to TAPE, PERFORMANCE

2002-05-30 Thread Seay, Paul
This is likely not a tape issue. 52GB/hr is about 14.8MB/sec. I am betting your disk cannot read the data any faster than that. Unless the data is not compressable at all the typical rates for a SCSI Magstar drive are 25+MB/sec and can get as high as 34 on Ultra SCSI if the cables are real

Re: SQL statement

2002-05-30 Thread Seay, Paul
Is the Q OCC command insufficient? If not try this: select node_name, stgpool_name from occupancy group by node_name, stgpool_name You can also add a where clause if you would like. Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Joel

Re: NT Cluster TSM

2002-05-30 Thread Jon Adams
Don't forget to check the Client Option Set as well. You may have an option in there for DOMAIN ALL-LOCAL and it may even be set to NOT allow overrides from clients (been there). ;) -Original Message- From: Zlatko Krastev [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 26, 2002 1:47 AM

Re: TSM monitored by TME

2002-05-30 Thread Ran Harel
The problem with the default rls is that the baroc does not match the rls: The old approach for TSM adapter was to create an event class for each message, which ment thousands of classes resulted with heavy load on TME. The new approach is one Server event class and one Client event class and one

ANR9999D Error message: Do you how to figure out this message?

2002-05-30 Thread Meensun Ahn
--- O/S: SunOS 5.6 TSM: Version 4, Release 2, Level 1.15 Tape library: scalar 1000 from ADIC Tape drive: AIT2 drive Tape : AIT2 (50GB~100GB) --- Dear All, Situation we face I am wondering where I can get more detailed

Re: q actlog

2002-05-30 Thread Pothula S Paparao
Yes you can ! All u need to have is restore your 'db' on development box. You must note as long as you have ACTLOGRETNETION set to 14 days or so, your earlier db also contains 14days of logs only. only thing you can have form the old db is back 14days from the date you restore your db. Thanks

Query Backupsetcontent

2002-05-30 Thread Crawford, Lindy
Hello TSMers. I generated a backupset on a tsm server a a remote site. I then brought the tape back to our local tsm site and I am trying to query the contents of the backupset but it hangsDoes anyone know how I can view what is on the tape Your assistance will be greatly appreciated.

Re: delete specific data.

2002-05-30 Thread Alexander Verkooijen
Leijnse, Finn F SITI-ITDSES31 wrote: Someone has decided to archive 1.5 TB (oracle DB) to a management class with 5 years retention period. Some ** idea of a manager. What has happened is that that archive has abended halfway. Is there a way to delete that data? I have not got an idea of

Re: SQL statement

2002-05-30 Thread Bernard Rosenbloom
Q OCC gives me for info then I need but your SQL statement is exactly what I was looking for...thanks Seay, Paul wrote: Is the Q OCC command insufficient? If not try this: select node_name, stgpool_name from occupancy group by node_name, stgpool_name You can also add a where clause if

Re: select formatting

2002-05-30 Thread Prather, Wanda
select node_name as + Node Name+++ from nodes. Put in as many fill chars as you need to force the output to be as wide as your widest node name. -Original Message- From: Gerald Wichmann [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 7:16 PM To: [EMAIL

Re: Storage Pool Size

2002-05-30 Thread Prather, Wanda
The answer is IT DEPENDS, and different people have different opinions, depending on what you are optimizing for. If you will go to www.adsm.org and click CURRENT MONTH, this topic was discussed at length over the past 2 days under the topic: allocating disk volumes on RAID5 array

Re: SQL statement

2002-05-30 Thread Sung Y Lee
I hope this is what you are looking for. select node_name,stgpool_name from occupancy similar to q occup Sung Y. Lee 512-823-1012 Bernard Rosenbloom To: [EMAIL PROTECTED] brosenbl@OPTONLIcc:

Re: SQL statement

2002-05-30 Thread Ammann, Tom
Hi, If you install the TSM ODBC Driver and point it at your TSM Server's IP Address and Port 1500, you can do this query in Excel or MS Access. In MS Excel click on Data, Get external data, new database query, Click on the Data Source name that is your ODBC connection Name, and log in to your

Re: Magstar Tape capabilities

2002-05-30 Thread Orville L. Lantto
Check the IBM web site for the current numbers: http://www.storage.ibm.com/hardsoft/tape/3590/prod_data/g225-6824.html 3590 tape drive performance depends on the model. The latest E1x models write at 14 MB/sec raw, with a maximum sustained rate on SCSI of 34 MB/sec (with compression) and 42

select formatting

2002-05-30 Thread Gerald Wichmann
The below output is from a simple select statement. I hate to ask this again but its been a while since I've done it and I forget how to format the columns. What I need to do is extract the node names from the backup server so that I can then perform operations on them. How do I increase the

Re: Mirror Recovery Log DB with RAID-5

2002-05-30 Thread Rushforth, Tim
See http://msgs.adsm.org/cgi-bin/get/adsm/864.html Along with multiple others (http://search.adsm.org/) -Original Message- From: Joni Moyer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 11:39 AM To: [EMAIL PROTECTED] Subject: Mirror Recovery Log DB with RAID-5 Hello! The

ANU2508E Wrong write state- any ideas?

2002-05-30 Thread Lisa Cabanas
Hello *SMers, On one of our production boxes (data warehouse) this error occurred yesterday during a hot backup with TDPO 2.2.0.2 (most current patch available on the ftp site). I can't find anything in the activity log or in the errpt for the TSM server and the client that correlates with this

Re: BACKUP to TAPE, PERFORMANCE

2002-05-30 Thread Gabriel Wiley
I thought it was 16MB/sec B1A model type, and up to 24MB for E1A Gabriel C. Wiley ADSM/TSM Administrator AIX Support Phone 1-614-308-6709 Pager 1-877-489-2867 Fax 1-614-308-6637 Cell 1-740-972-6441 Siempre Hay Esperanza |-+ |

Symbolic Links

2002-05-30 Thread Rajesh Oak
What is the correct way to backup Symbolic links for AIX. TSM server V 4.2.1.11 AIX client V 4.2.1.23 The client wants to backup all the folders pointed by the Link and also restore the folders pointed to by symbolic links. Should I be able to see the link in the Backup GUI ? Thanks Rajesh

Re: allocating disk volumes on RAID5 array

2002-05-30 Thread bbullock
Hmm... All of our disk storage pools are larger than 2 GB and have large files enabled because we do see files larger than 2GB come in from clients... I'm quite sure I'm not going to want to slice up a 36Gb disk into 18 2GB filesystems just to use direct I/O. I think the

Re: about DRM

2002-05-30 Thread Seay, Paul
You are correct. Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Luscombe John (HS) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 2:40 AM To: [EMAIL PROTECTED] Subject: AW: about DRM Burak, As far as I understand it, the

Magstar Tape capabilities

2002-05-30 Thread Gabriel Wiley
An excerpt from the Magstar Redbook. SG24-2594-02 The Magstar tape drive is capable of reading and writing data at a rate of 9 MB/sec. This is three times the rate at which IBM 3490E devices can read and write data. The IBM 3590 High Performance Tape Subsystem can transfer data between the

Re: Running a Windows Batch file on my Windows server

2002-05-30 Thread Rushforth, Tim
Thanks Bill. Great idea, I've modified ours and hope it runs tomorrow morning! Tim Rushforth City of Winnipeg -Original Message- From: Bill Boyer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 10:51 AM To: [EMAIL PROTECTED] Subject: Re: Running a Windows Batch file on my

BACKUP to TAPE, PERFORMANCE II

2002-05-30 Thread Francisco Molero
Hi again, I only use one drive. This is important. Sorry for my previous mail. Client Options: nodename IBM_TEST ERRORLOGRETENTION 5 PASSWORDACCESS GENERATE SCHEDLOGRETENTION 5 SCHEDMODE PROMPTED TCPB32 TCPNYES TCPPORT

ANU2508E Wrong write state- any ideas?

2002-05-30 Thread Lisa Cabanas
Hello *SMers, On one of our production boxes (data warehouse) this error occurred yesterday during a hot backup with TDPO 2.2.0.2 (most current patch available on the ftp site). I can't find anything in the activity log or in the errpt for the TSM server and the client that correlates with this

/VAR File System on AIX 4.3.3 and TSM Error

2002-05-30 Thread Adam Rowe
I am getting this error message on my TSM Server and was not sure if these files are cached and replaced with new files causing the ANE4005E error below. Also, is there a specific reason that the /VAR file system should be backed up on a regular basis. Thanks. ANE4005E (Session: 13772, Node:

Question about port configuration...

2002-05-30 Thread Keith Kwiatek
Hello, When the tsm client talks to the server it uses 1500. Is there a way to tell the server what port to talk to the client on? Thanks, Keith

Re: SQL statement

2002-05-30 Thread Mahesh Tailor
Here's an alternate . . . select distinct node_name,stgpool_name from occupancy Also, if you type . . . select * from occupancy . . . you'll get the entire table. Hope this helps. Mahesh [EMAIL PROTECTED] 05/29/02 11:18AM I hope this is what you are looking for. select

frame relay nodes-- can I avoid another full backup?

2002-05-30 Thread Lisa Cabanas
Hello again, here's the deal- we have approximately 50 frame relay nodes that backup to TSM servers. These NT boxes' drives are almost full (max is 16G on these) and partitions were created to hold data (D:\) and app shares (E:\). We are getting replacements (80G and expandable), and will be

Re: select formatting

2002-05-30 Thread Bill Boyer
Add the '-tab' command line parameter. We do this with Perl scripts and then split(/\t/,$RESULT) it. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Wichmann Sent: Wednesday, May 29, 2002 7:16 PM To: [EMAIL PROTECTED]

SQL/scripts

2002-05-30 Thread Joni Moyer
Hello! I don't have a reporting package and I was wondering if any on you could tell me some useful scripts that you run on a daily basis? Thanks!!! Joni Moyer Associate Systems Programmer [EMAIL PROTECTED] (717)975-8338

Re: BACKUP to TAPE, PERFORMANCE

2002-05-30 Thread Gianluca Mariani1
Francisco, those numbers are normal. 3590 drives have a native transfer rate of 12MB/s. that makes around the 50GB/h mark. to have more than that you have to compress your data, and the 3590 can compress up to 3:1. whether you can do that or not depends on your data (3:1 compression ratios are

Re: BACKUP to TAPE, PERFORMANCE II

2002-05-30 Thread Gianluca Mariani1
Fran, one parameter you can change is Bufpoolsize on the server. for 1GB of real RAM you should put it to 131072. the other thing is to turn compression off, in a single client, fast client, fast server, fast network it gives better performance. then on the AIX server try no -o rfc1323=1 no -o

Storage Pool Size

2002-05-30 Thread David E Ehresman
I am planning a TSM Server move from OS390/MVS to AIX. My largest storage pool is about 73gig and is spread across 32 volumes of about 2.3gig each. On AIX I will have a 128gig file system so I could put that storage pool into a single volume if that makes sense. My question is should I spread

Re: SQL/scripts

2002-05-30 Thread Bill Boyer
You should try the archives (http://www.adsm.org) and also the Scripts Depot at Coderelief (http://www.coderelief.com/depot.htm) Lots of good stuff people on this list have posted there. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On

special offer: IBM 3590 - 10GB cartridges (450 pcs.)

2002-05-30 Thread Uwe Schönacher
Hi TSMers, there is a special offer of IBM3590 10GB cartridges (amount approx. 450). Some of them were used for tests (only for a short period of time). The majority of them have never been used. All cartridges have been erased and are therefore useable. The cartridges will be available by

Re: SQL/scripts

2002-05-30 Thread Rushforth, Tim
I'm not prepared to post our scripts yet but will tell you some of the things that we run daily: Report on failed client schedules - q event * * enddate=today begintime=NOW-23:59 endtime=NOW f=d - filter and report on anything other than completed Report on Client errors (mostly failed

Re: Question about port configuration...

2002-05-30 Thread Rushforth, Tim
If asking about prompted mode when server connects to client to tell it to start a schedule, see client option TCPCLIENTPORT -Original Message- From: Keith Kwiatek [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 10:10 AM To: [EMAIL PROTECTED] Subject: Question about port

Re: /VAR File System on AIX 4.3.3 and TSM Error

2002-05-30 Thread David Longo
/var on AIX can have a lot of temporary files, print files and mail spool files etc. A file is there when TSM gets list of files to back up and is gone when actually tries to backup. I don't worry about. I like to backup up /var anyhow as there is stuff there worth saving (cron jobs, for

Re: frame relay nodes-- can I avoid another full backup?

2002-05-30 Thread David Longo
Haven't looked at 5.1 yet, I know there is a new command something like move nodedata. However as you are upgrading OS and rearranging disks, I would take your last option - Rename nodes (rename NODE NODE_OLD), then register new node names and do full backup of new machines. After comfortable

Changing Storage Pools/Management Classes

2002-05-30 Thread Todd Lundstedt
Currently, we backup everything either to DISKPOOL (which migrates to LTOTAPE), or directly to LTOTAPE. Files (backup/archive client), databases (TDP for Domino, and TDP for SQL), everything is eventually stored into LTOTAPE. The databases get backed up FULL every time. The largest database we

Re: select formatting

2002-05-30 Thread Seay, Paul
Select node_name as Node Name from Nodes You may have to add -tab to your dsmadmc command. Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -Original Message- From: Gerald Wichmann [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 7:16 PM

Re: ANR9999D Error message: Do you how to figure out this message?

2002-05-30 Thread Zlatko Krastev
ANRD is generic error message handling unknown situations. Usually such problems can be resolved only by IBM support due to their rare occurences. The large output is tracing information to help support and developers to analyse the root cause. The only hint I can give you is to perform AUDIT

Getting events formatted better????

2002-05-30 Thread Mark Brown
Hello, I have been using a q event * * node=* begindate=today-1 enddate=today begintime=08:00 endtime=06:30 format=detailed command for quite a while. I output the info into a web page for Operations staff to read. I am tired of having to move the page to the right to see the status. I've got it