ADSM/DATE/SQL

2001-06-25 Thread Sheets, Jerald
Ladies and Gentlemen, Do any of you out there have links to a SQL reference for ADSM ( I already have the documentation from the Administrator's guide) or a SQL 92/93 reference? I am interested specifically with doing date calculations using fields from DB, BACKUPS, and FILESPACES and N

Re: ADSM/DATE/SQL

2001-06-25 Thread Sheets, Jerald
ssage- From: Gene Walters [mailto:[EMAIL PROTECTED]] Sent: Monday, June 25, 2001 11:45 AM To: [EMAIL PROTECTED] Subject: Re: ADSM/DATE/SQL Try this: SELECT NODE_NAME, PWSET_TIME from NODES where PWSET_TIME < CURRENT_TIMESTAMP - 100 DAYS >>> "Sheets, Jerald" <[EMAI

Simple archival problem (I hope)

2001-06-29 Thread Sheets, Jerald
Ladies and Gentlemen, I am encountering an issue that doesn't seem to be addressed (directly) in the documentation. The scenario is simple, but I am not sure of the method to enact what I'm trying to do. We are divided into 2 teams here, and the other team removed and shipped of

Re: total # of bytes by each client on a daily basis

2001-06-29 Thread Sheets, Jerald
I'm a little confused here... I was actually looking to figure out how to do this when you folks started talking about it. So, I pulled out my trusty data-extraction tools and found out that I don't have a SUMMARY table. Anybody wanna take a crack at that? Jerald Sheets, Systems Analyst TIS Ou

Re: Redirecting Output In Scripts

2001-07-03 Thread Sheets, Jerald
Yeah, ADSM has some little idiosyncrasies that are hard to get used to. Most often, I'm working out the selects from shell scripts as so: REPORT="~/adsm.report" ID="foo" PW="bar" and later: BU_DATE=`dsmadmc -id=$ID -pa=$PW "select node_name,filespace_name from filespace s where cast((current

Re: Q ACTL / SEARCH question

2001-07-03 Thread Sheets, Jerald
Certainly. Here is my statement for querying the accounting log for the previous workday/night: LOG_Q=`dsmadmc -id=foo -pa=bar -outfile=actlog.tmp q actlog begindate=TODA Y-1 begintime=17:00:00 enddate=TODAY endtime=05:59:59` and later I clal it with: echo "Unavailable tape list: $TAPELIST "

Re: Windows XP support

2001-08-17 Thread Sheets, Jerald
I leave for class 8/27. If you don't get an answer by then, I'll bring one back for you. JMS -Original Message- From: Paul Zarnowski [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 2:13 PM To: [EMAIL PROTECTED] Subject: Windows XP support I am told that Microsoft will be rele

Re: TDP for Domino Web access

2001-09-05 Thread Sheets, Jerald
Title: RE: TDP for Domino Web access The teacher said in the TSM install class last week that Tivoli is trying to eventually force everyone to websphere. Hope that helps. Jerald M. Sheets jr Programmer / Analyst, TIS Our Lady of the Lake Regional Medical Center 5000 Hennessy, Baton Rouge,

Re: ESS and Flashcopy for backups

2001-09-06 Thread Sheets, Jerald
No, no no! Post them here so we all can benefit Jerald M. Sheets jr Programmer / Analyst, TIS Our Lady of the Lake Regional Medical Center 5000 Hennessy, Baton Rouge, LA 70808 703.765.8734 [EMAIL PROTECTED] -Original Message- From: William Boyer [mailto:[EMAIL PROTECTED]] Sent:

Re: TSM & AIX 5L

2001-09-10 Thread Sheets, Jerald
AAMOF, I am installing a TSM 4.2 testbed right now, and when you do, you get some failures. The failures are: tivoli.tsm.devices.aix5.rte 4.2.0.0 tivoli.tsm.license.aix5.rte64 4.2.0.0 tivoli.tsm.server.aix5.rte64 4.2.0.0 due to a failed prerequisite of bos.rte 5.1.0.0 (I am installing to Ai

Re: Scheduled NT Client Performance Problems

2001-11-20 Thread Sheets, Jerald
Check your duplex/speed settings *both* at the NIC and the switch ports. Lock them according to your manufacturer's suggestions. --JMS -Original Message- From: Malbrough, Demetrius [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 3:19 PM To: [EMAIL PROTECTED] Subject: Schedule