Re: switches for DSMADMC command (OS/390)

2002-04-05 Thread William White
Andy, I recently wanted to execute DSMADMC (true name ANSADM) in batch. Rather than use TSO batch I invoked the program via JCL. Like this: //CCCOWWTX JOB (CC-CO),'W. WHITE',MSGLEVEL=1,NOTIFY=CCCOWW, // CLASS=P,MSGCLASS=X,REGION=4M /*JOBPARM LINES=100 //DSMADMC EXEC

disaster recovery ?

2002-04-05 Thread bizzorg
I hope someone out there can help. All our TSM servers run on OS390 or z/OS, except for one UNIX based TSM. This UNIX server is not setup for offsite storage. I think we can back this server up to a TSM on z/OS. How do I backup the backed up data? It's all in a tape silo attached to this UNIX

RE: don?t aynone know anything about Encryption in TSM.

2002-04-05 Thread Petur Ey?orsson
when i said that they have extremely valible data i am meaning that this genetic reasearch company has the medical records, detatild information on peoples relatives back to the middle ages and the DNA codes of every person in this country. now thats one jucy database. You guys can hopfully see

Re: Library

2002-04-05 Thread Mark Bertrand
Keith, May I ask why did you upgrade to 22U0? I am asking this because IBM wants us to upgrade to 22U0 as well and they have told us that it is at engineering code level so we were reluctant to go anyway. We are and have been experiencing problems that opened a critsys ticket that initiated IBM

TDP SQL 2.2 problem

2002-04-05 Thread Tom Hrouda
Hi all, W2000 Server, SP2, MS SQL 2000, TDP SQL 2.2 Sometimes (3-4 days in week) TDP client failed to connect to SQL server at start of backup and full backup failed. This is part of sqlsched.log: === 04/01/2002 03:00:04 Executing scheduled command now. 04/01/2002 03:00:04

Re: Library

2002-04-05 Thread Keith Gourd
We are just implementing TSM and I have been trying to get everything up and running. Well, I was told to upgrade the microcode, when I did I started getting I/O errors so I call Tivoli, who said it was a hardware problem for me to contact my IBM rep. I read on the ADSM site that this has

Re: Library

2002-04-05 Thread Ford, Phillip
We put on 18N2 and IBM said that there was a problem with it. They told us to go to 22U0 which we did. We have had no problems with it as far as I know. Don't know what type of problems you are looking for. We do not do any straight to tape backups. All our backups go to disk pools and then

Re: Library

2002-04-05 Thread Burak Demircan
I am using 22u0 since it was released. It works fine. Just install it. Regards, Burak [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05.04.2002 15:04 Please respond to ADSM-L                 To:        [EMAIL

Re: TDP SQL 2.2 problem

2002-04-05 Thread Del Hoobler
ACO5424E Could not connect to SQL server; SQL server returned: [Microsoft][ODBC SQL Server Driver]Timeout expired Microsoft SQL-DMO (ODBC SQLState: HYT00) (HRESULT:0x8004) Tom, Do you know if there were some large jobs running against your SQL server at the times that the time-out

Re: don?t aynone know anything about Encryption in TSM.

2002-04-05 Thread Thomas Denier
This is what i have understand of you guys so far. Encryption in TSM is always done on the TSM B/A-Client there do you put a 56bit encryption key on the data witch cannot be retreved without the key. So they need to come up with some sort of disaster Recovery plan, regarding the key

Re: don?t aynone know anything about Encryption in TSM.

2002-04-05 Thread Justin Derrick
when i said that they have extremely valible data i am meaning that this genetic reasearch company has the medical records, detatild information on peoples relatives back to the middle ages and the DNA codes of every person in this country. Um, that's spooky. I suspect it's an exaggeration

Re: disaster recovery ?

2002-04-05 Thread Aaron Widmeyer
If I understand what you are saying here is that you want to not only backup the UNIX machines TSM database but the actual tapes as well to another TSM server? There are some options here and it has been a while since I have read up on this and please correct me if I misunderstand or misstate

Re: TSM/ODBC connection not working...

2002-04-05 Thread Andrew Raibeck
What version of the ODBC driver are you using, which version of Excel, and what symptoms are you seeing? The latest ODBC driver should work okay with Excel 97 and 2000 (haven't tested with Office XP yet, but in theory, should work there, too). You can confirm the version by starting the ODBC Data

Re: TSM/ODBC connection not working...

2002-04-05 Thread Tab Trepagnier
Paul, For the last six months or so I've used Excel 97 with the ODBC link as a read-only GUI. Excel allows sorting and filtering - tools that are missing from the web client. To work with Excel you must have MS Query installed as part of MS Office. In my case, somewhere along the line of

Activity log messages

2002-04-05 Thread David E Ehresman
How would I modify the SELECT statement in the TSM supplied sample Q_MSG-SEV script to only return messages from the past 24 hours?

Re: disaster recovery ?

2002-04-05 Thread Hunley, Ike
There are business critical servers backing up to the TSM on this UNIX server. I understood that the backup data is on tape. It is that data we need to recover in a disaster situation. -Original Message- From: Aaron Widmeyer [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002

Re: don?t aynone know anything about Encryption in TSM.

2002-04-05 Thread Andrew Raibeck
Starting in 4.2, encryption is also supported on UNIX and NetWare. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes

Re: MEMORYEFFICIENT Backup Option may be functioning incorrectly

2002-04-05 Thread Andrew Raibeck
Hi Paul, Offhand, I can't explain why you are seeing what you are seeing. One thing you could try, if you are willing, is to code MEMORYEFFICIENTBACKUP YES on one or two machines and see how it performs in comparison. But from my checking, specifying NO still remains the same as not coding the

Re: disaster recovery ?

2002-04-05 Thread Miller, Ryan
Have you thought about using Server to Server Virtual Volumes, you could do this and create a copy pool on one of your OS/390 TSM servers. Ryan -Original Message- From: Aaron Widmeyer [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 9:23 AM To: [EMAIL PROTECTED] Subject: Re:

Re: switches for DSMADMC command (OS/390)

2002-04-05 Thread Andrew Raibeck
Hi William, You should be running the admin client in TSO batch mode. It's not called the TSO Administrative Client for nothing! :-) And yes, the admin client has not been upgraded on OS/390 since it there isn't really any new functional enhancements. Regards, Andy Andy Raibeck IBM

Re: Activity log messages

2002-04-05 Thread Rushforth, Tim
ADD in a and date_timecurrent_timestamp-1 days Tim Rushforth City of Winnipeg -Original Message- From: David E Ehresman [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 9:09 AM To: [EMAIL PROTECTED] Subject: Activity log messages How would I modify the SELECT statement in the

Re: Laptop Backup Fails.

2002-04-05 Thread Rushforth, Tim
Yes it could. Check the System Event Log for event 6005 and 6006 The event log service was started/stopped This indicactes a shutdown and startup. Tim Rushforth City of Winnipeg -Original Message- From: Amini, Mehdi [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 9:09 AM To:

my timesheet

2002-04-05 Thread Wholey, Joseph (TGA\\MLOL)
joseph_wholey_040402.xls Regards, Joe Wholey TGA Distributed Data Services Merrill Lynch Phone: 212-647-3018 Page: 888-637-7450 E-mail: [EMAIL PROTECTED] joseph_wholey_040402.xls Description: MS-Excel spreadsheet

Re: disaster recovery ?

2002-04-05 Thread Aaron Widmeyer
I understand that the data in on tape on the UNIX TSM server in question but why are you trying to backup data on tape to another server when there may be better/easier ways of getting the data off site and safe in case of a disaster? Why not create a copy pool and point it to a small section of

Re: my timesheet

2002-04-05 Thread Amini, Mehdi
here we go again Mehdi Amini -Original Message- From: Wholey, Joseph (TGA\MLOL) [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 10:42 AM To: [EMAIL PROTECTED] Subject: my timesheet joseph_wholey_040402.xls Regards, Joe Wholey TGA Distributed Data Services Merrill Lynch

Re: my timesheet

2002-04-05 Thread Adolph Kahan
Joe, why do you keep sending your timesheet to the ADSM list? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Wholey, Joseph (TGA\MLOL) Sent: Friday, April 05, 2002 10:42 AM To: [EMAIL PROTECTED] Subject: my timesheet joseph_wholey_040402.xls

my timesheet... please don't reply

2002-04-05 Thread Wholey, Joseph (TGA\\MLOL)
Please don't reply to the my timesheet message thx. sorry for inadvertantly sending Regards, Joe Wholey TGA Distributed Data Services Merrill Lynch Phone: 212-647-3018 Page: 888-637-7450 E-mail: [EMAIL PROTECTED]

Laptop Backup Fails.

2002-04-05 Thread Amini, Mehdi
We have a Laptop (WIN2K) that we backup every night. It fas failed for the last few days. The errors I see are the following: DSMERROR.LOG 04/04/2002 19:43:34 ConsoleEventHandler(): Caught Logoff console event . 04/04/2002 19:43:34 ConsoleEventHandler(): Process Detached. 04/04/2002 19:43:44

tdp r3 and versioning

2002-04-05 Thread Davidson, Becky
Has anyone out there used the tdp for r3 versioning instead of expiration? How does it work with disaster recovery? What are the bonuses or detriments? Thanks Becky Davidson Data Manager/AIX Administrator EDS/Sara Lee Bakery Group voice: 314-259-7589 fax: 314-877-8589 email: [EMAIL PROTECTED]

Re: don?t anyone know anything about Encryption in TSM.

2002-04-05 Thread Nicholas Cassimatis
The 'always' above raises a potentially critical point that I don't think has been mentioned in this thread. I attended a Tivoli presentation on new features in TSM 4.1 which stated that only the Windows client would have encryption support. As far as I know, the Windows client is still the only

Query Output Format

2002-04-05 Thread David E Ehresman
If I put a Q DB and a Q DB F=D together in a script and run it from a terminal (AIX), the Q DB output is in table format and the Q DB F=D output is in list format. This is what I want. If, however, I redirect the output to a file, RUN QUERY query.txt, they both come out in table format and the

Multiple TSM Servers on Same Host

2002-04-05 Thread Fought,Tom
Curious if anyone has done this on AIX. We are migrating 3 servers to one 6M1/AIX box. Issues? All servers have to be same version? Thanks Tom

Re: Activity log messages

2002-04-05 Thread Seay, Paul
Send me the select and I will tell you but it is probably adding the following: where date_time current_timestamp - 24 hours It is crucial to have the current_timestamp together. -Original Message- From: David E Ehresman [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 10:09 AM

Re: Compaq SAN/Groupwise

2002-04-05 Thread Seay, Paul
You will find that Gigabit cards in the groupwise servers is the way to go anyway. If you figure out the SAN client software costs it will offset most of the hardware cost for the Gigabit. I have seen numbers has high as 55MB/sec on this even on a PC100 Intel Machine if you have good switching

Re: don?t aynone know anything about Encryption in TSM.

2002-04-05 Thread Seay, Paul
In the DoD arena we prescribe to a security called FIPS-140. Basically, it requires encryption of all the network and a closed environment and extending beyond that is all the issues of vault certification and physical plant protection. Sounds like there has been no government classification

Re: TSM/ODBC connection not working...

2002-04-05 Thread Seay, Paul
Actually Andy, I cannot remember what I was trying to do with EXCEL XP. But, when I tried it again I get an application error trying to read location 0x0. A test connection works, but I cannot do the OK to open the database. -Original Message- From: Andrew Raibeck [mailto:[EMAIL

Re: Query Output Format

2002-04-05 Thread Seay, Paul
David you have the option of doing a select command for each field one at a time. Yes, it is a kludge, but it is an option. Select * from db Will get them all, then pick the ones that you want. You may want to format them also. Not sure what you are trying to do here. -Original

Re: my timesheet

2002-04-05 Thread Wholey, Joseph (TGA\\MLOL)
An automated process gone awry... -Original Message- From: Adolph Kahan [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 10:49 AM To: [EMAIL PROTECTED] Subject: Re: my timesheet Joe, why do you keep sending your timesheet to the ADSM list? -Original Message- From: ADSM:

Re: Multiple TSM Servers on Same Host

2002-04-05 Thread Lisa Cabanas
Not necessarily-- if you want different server versions, you will need to have different environmental variables and separate directories for the different versions. I am running 3 or 4 different servers on each of two 6M1s, and will have 6 production instances on each when I am thru. I opted

Re: For those Security conscious people running AIX

2002-04-05 Thread Lisa Cabanas
--duuuhh-- Thanks Justin, I missed that point-- The tsm family of commands (tsm,getty,login). Anyone have any idea of what tsm means (you know, the obscure reason it was named tsm-- like AIX means Advanced Interactive eXecutive?) lisa Justin Derrick

Timesheets in excel

2002-04-05 Thread William F. Colwell
Someone sent this to the adsm-l discussion list by mistake. I am passing it on as a curiosity that companies use excel to report time. - bill At 10:42 AM 4/5/2002 -0500, you wrote: joseph_wholey_040402.xls Regards, Joe Wholey TGA Distributed Data Services Merrill Lynch Phone: 212-647-3018

Re: Query Output Format

2002-04-05 Thread Andrew Raibeck
You could try using -outfile instead of redirection. An alternative: have the script run Q DB with -DISPLAYMODE=TABLE, redirecting to your output file. Then run Q DB F=D with -DISPLAYMODE=LIST, appending to the output file. With all that said, I'm curious: Q DB F=D includes what is in Q DB, so

Re: Accounting Log

2002-04-05 Thread Williams, Tim P {PBSG}
I kinda like the summary table and it may have less issues than the dsmaccnt.log ** we have nodes that do hundreds of archives not to mention that multithreading incremental backups (resourceutilization in the dsm.opt) will create multiple dsmaccnt.log records... ** the select (2nd one below)

Re: Monthly Backups, ...again!

2002-04-05 Thread Marc Levitan
Thanks to all that replied! Looks like I am not alone! I'll let you know the outcome... Marc Levitan Storage Manager PFPC Global Fund Services Seay, Paul seay_pd@NAPTTo: [EMAIL PROTECTED] HEON.COMcc:

Accounting Log

2002-04-05 Thread Marc David
Hi All, We turn on the Account Log on our TSM server (H50 running AIX 4.3.3). This way we can charge back clients for disk space usage. My question is, does anyone use this ? Plus how do you get the output from the file DSMACCNT.LOG into a readable report for management. Marc David Storage

Re: For those Security conscious people running AIX

2002-04-05 Thread Justin Derrick
I'm guessing here... To Sabotage Mailinglists. -JD. --duuuhh-- Thanks Justin, I missed that point-- The tsm family of commands (tsm,getty,login). Anyone have any idea of what tsm means (you know, the obscure reason it was named tsm-- like AIX means Advanced Interactive eXecutive?) lisa

Re: TSM server unable to start

2002-04-05 Thread Alex Paschal
I don't know about corrupted, but it looks like someone went in and changed the size of the Logical Volume. If you look in the admin guide for raw logical volumes vs files in filesystems, it'll tell you that this is one of the dangers of using raw logical volumes. Perpetua, I think it likely

Re: don?t aynone know anything about Encryption in TSM.

2002-04-05 Thread Petur Ey?orsson
Hi justin. Personally, I can't imagine a use for it, but I'm not a biotech geek. =) They use this database for Gentetic Research, there is one good thing about genetic Research and Iceland and that here is so few people and we have documents about every birth since 1500 or so. this potential

Re: Query Output Format

2002-04-05 Thread David E Ehresman
Not sure what you are trying to do here. Trying to duplicate my MVS/TSM email reports in an AIX environment :-( David

Re: Query Output Format

2002-04-05 Thread David E Ehresman
With all that said, I'm curious: Q DB F=D includes what is in Q DB, so why do you want both? Well the simple answer is I'm trying to duplicate an existing MVS/TSM report in Aix. The better answer is that %database full stands out better in Q DB than in QD F=D but the later has additional detail

Strange behaviour...

2002-04-05 Thread Robert Ouzen
Hi to all I made a selective backup of one of my Unix client(nodename DRM_STUDY) directly to tape (it's the managment class by default). The backup took a very long time and I saw that the backup wrote files too on disk. I made a list contents of what is written on disk (here is the output).

Re: TSM database maximum recommended size

2002-04-05 Thread Scott McCambly
Thanks to all who responded to my inquiry. All your comments were valid, and I especially liked Nick Cassimatis point about TSM DB backups spanning multiple volumes. The main point of my question was to gather a survey of database sizes out there, so I'm happy to keep seeing responses come in

Re: For those Security conscious people running AIX

2002-04-05 Thread David Longo
Per AIX 4.3.3 man page: tsm Command Purpose: Provides terminal state management. Syntax tsm Port Description The tsm command invokes the terminal state manager, which controls the ports used in the trusted path. David Longo [EMAIL PROTECTED] 04/05/02 11:57AM --duuuhh-- Thanks Justin, I

Re: Multiple TSM Servers on Same Host

2002-04-05 Thread Fought,Tom
Thanks so much Lisa. This is exactly what I was looking for. Tom -Original Message- From: Lisa Cabanas [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 1:26 PM To: [EMAIL PROTECTED] Subject: Re: Multiple TSM Servers on Same Host Tom, In the manual TSM 4.2 for AIX, Quick Start

Re: Multiple TSM Servers on Same Host

2002-04-05 Thread Lisa Cabanas
Tom, In the manual TSM 4.2 for AIX, Quick Start (GC35-0402-01), there is a section (p 11) that describes how to set up multiple servers on one box (for each instance you export the DSMSERV_DIR to /usr/tivoli/tsm/server1/bin or /usr/tivoli/tsm/server2/bin and you have installed the binaries into

Re: For those Security conscious people running AIX

2002-04-05 Thread Lisa Cabanas
Boy, I am really batting 1.000 here! Who woulda thunk?? the MAN page (bigger duhhh) David Longo David.Longo@HEALTH- To: [EMAIL PROTECTED] FIRST.ORG cc: Sent by: ADSM: Dist

TSM on AIX 64-bit

2002-04-05 Thread Andrew Carlson
I was looking at the Tivoli site for information about TSM 5.1 running in 64-bit mode on AIX. I couldn't find anything about 5.1, but TSM 4.1 and 4.2 say that TSM is supported on an RS/6000 64-bit system. Does this mean that TSM is taking adavantage of the 64-bitness? I did not think they did,

FYI on tape volume usage select statement (use of DISTINCT)

2002-04-05 Thread Williams, Tim P {PBSG}
IF your tape stgpool is collocated (you have to consider if a node has offsite tape volumes and if that stgpool has colocation on or off as well) AND you want to know how many tapes a node spans... try this: tsm: ADSMselect node_name, count(distinct volume_name) from volumeusage where

Re: AIX system backup

2002-04-05 Thread David Longo
A quick Friday afternoon answer: Yes, AIX is a client just like any other platform. (You need to have an AIX mksysb tape made though to do restore from totally crashed system). You say make backups of regular production jobs, exactly what do you mean by that? If you need to make backups of

Re: TSM server unable to start

2002-04-05 Thread Selva, Perpetua
Thx :-) Luckily its on my test box! -Original Message- From: Alex Paschal [SMTP:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 12:16 PM To: [EMAIL PROTECTED] Subject: Re: TSM server unable to start I don't know about corrupted, but it looks like someone went in and

Re: Query Output Format

2002-04-05 Thread David E Ehresman
You could try using -outfile instead of redirection. That did the trick. Now does anyone know why -outfile minics output to a terminal while redirection does not? What's the difference between them? David

Re: Time audit library

2002-04-05 Thread Gabriel Wiley
Brain, As long as you use the checklabel=barcode you should have it done pretty quick. My largest library is 9 frames(2766 cells) , and it is packed, even if it wasn't - it would still scan the slots. Anyway, it takes about 15-20 minutes.. 3 other library(s) @ 7 , 4 , 3 frames take about 5-7

Re: dsmcsvc.exe Port Usage

2002-04-05 Thread David Longo
One thought is that there is a Virus that consumes ports. We have had it a couple of times. Don't remember exactly how it affected TSM but it did something like this. David Longo [EMAIL PROTECTED] 04/05/02 07:00PM Hopefully someone on this list can help me with this problem. I have a user