Re: TSM 5.2 AIX client - DB2/SAP R3 Direct Archiving

2003-07-22 Thread Tudor,Troy,VEVEY,GL-IS/IT
Hi Lindy

I guess your using the SAP supplied db2uext2.  I suggest you contact SAP for
assistance.
Oss note 104019 provides some good information regarding the return codes

Cheers
Troy Tudor


-Original Message-
From: Crawford, Lindy [mailto:[EMAIL PROTECTED]
Sent: 21 July 2003 12:14
To: [EMAIL PROTECTED]
Subject: TSM 5.2 AIX client - DB2/SAP R3 Direct Archiving


Hi TSMers,

DB2 direct archiving to tsm does not work it comes up with the following
error messages, it show target as disk even although I have changed it to
ADSM:DISKPOOL after I upgraded to tsm 52 aix 64bit  5.2:-
Time Started:  Mon Jul 21 12:03:40 2003 (20030721120340)

Parameters Passed:
  db2uext2 -OSAIX 64BIT -RLSQL07026 -RQARCHIVE -DBPRD -NNNODE
-LP/db2/PRD/log_dir/ -LNS008.LOG
System Action   : ARCHIVE
Target  :DISK
RC  : 104||| ERROR |||
Time Completed  :Mon Jul 21 12:03:42 2003 (20030721120342)


Time of Error: Mon Jul 21 12:03:42 2003

Action:ARCHIVE
Database Name: PRD
Log File Path: /db2/PRD/log_dir/
Log File Name: S008.LOG
Audit Log File:/db2/PRD/db2dump/db2uext2.log.NODE
Media Type:Disk
User Exit RC:  23
 Error isolation: Creating log file id failed. Reason: DB6CliExecute():
[IBM][C
LI Driver][DB2/AIX64] SQL0204N  SAPR3.DB6LOGFILE_PLACE is an undefined
name.
SQLSTATE=42704

Please help.

Lindy Crawford
Information Technology
Nedbank Corporate - Property  Asset Finance
*+27-31-3642185
  +27-31-3642946
 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]






Re: Stats

2003-07-22 Thread P Baines
This should also show you the amount of active data on a node in MB:

select sum(capacity*pct_util/100) from filespaces where node_name=''



-Original Message-
From: William Rosette [mailto:[EMAIL PROTECTED]
Sent: 21 July 2003 19:36
To: [EMAIL PROTECTED]
Subject: Re: Stats


Thanks,
Good one,
Bill Rosette
Data Center/IS/Papa Johns International
WWJD



  Richard Sims
  [EMAIL PROTECTED] To:
[EMAIL PROTECTED]
  Sent by: ADSM:  cc:
  Dist StorSubject:  Re: Stats
  Manager
  [EMAIL PROTECTED]
  .EDU


  07/21/2003 01:39
  PM
  Please respond to
  ADSM: Dist Stor
  Manager






I am looking for a way to figure a total Gb of active files on a
particular
node. ...

Hello, Bill - This question came up a few weeks ago, and the excellent
  suggestion was the expedient:

Active files, number and bytes  Do 'EXPort Node NodeName
FILESpace=FileSpaceName
FILEData=BACKUPActive
Preview=Yes'
Message ANR0986I will report the
number
of files and bytes.

(This is immortalized in http://people.bu.edu/rbs/ADSM.QuickFacts)

   Richard Sims, BU

Any e-mail message from the European Central Bank (ECB) is sent in good faith but 
shall neither be binding nor construed as constituting a commitment by the ECB except 
where provided for in a written agreement.
This e-mail is intended only for the use of the recipient(s) named above. Any 
unauthorised disclosure, use or dissemination, either in whole or in part, is 
prohibited.
If you have received this e-mail in error, please notify the sender immediately via 
e-mail and delete this e-mail from your system.


Re: move nodedata

2003-07-22 Thread Remco Post
On Mon, 21 Jul 2003 22:59:28 -0400
bizzorg [EMAIL PROTECTED] wrote:

 What happened to the move Nodedata function?  We're running on z/OS 1.2 TSM
 server at 5.1.6.4.  I read that there would be a move nodedata funtion
 startingat V5.1.5.

It's there

tsm: BASKEThelp move nodedata
MOVE NODEDATA



MOVE NODEDATA (Move Data by Node in a Sequential Access Storage Pool)
Use this command to move data located in a sequential-access storage pool.
snip

(at least on aix it is...)
--
Met vriendelijke groeten,

Remco Post

SARA - Stichting Academisch Rekencentrum Amsterdamhttp://www.sara.nl
High Performance Computing  Tel. +31 20 592 8008Fax. +31 20 668 3167

I really didn't foresee the Internet. But then, neither did the computer
industry. Not that that tells us very much of course - the computer industry
didn't even foresee that the century was going to end. -- Douglas Adams


Re: Space reclamation

2003-07-22 Thread Chandrasekhar, C.R
Questions:

(j) Can I use reclaimation when I have got only i1 tape drive and the
reclamation pool is to another sequential stgpool?

We can do manual reclamation using file device class(sequential), ref Admin
guide for instructions.

(ii) what is the meaning of insufficient mount points in the message. For
info, my client nodes are defined with a max no of 2 mount points.

For auto reclamation you must have minimum two tape drives in your library.

(iii) Why TSM is not loading the required volume when the tape is alaready
in the library?
Library does not have two drives to load source and target tapes for auto
reclamation.

CRC,

C.R.Chandrasekhar.
Systems Executive.
Tivoli Certified Consultant (TSM).
TIMKEN Engineering  Research - INDIA (P) Ltd., Bangalore.
Phone No: 91-80-5536113 Ext:3032.
Email:[EMAIL PROTECTED]


-Original Message-
From: RAMNAWAZ NAVEEN [mailto:[EMAIL PROTECTED]
Sent: Monday, July 21, 2003 6:12 PM
To: [EMAIL PROTECTED]
Subject: Space reclamation


Hi,


I am quite new to TSM and trying to configure some setups by myself 
currebntly facing some problems.

My setup is as follows:

I run a daily backup for around 200 GB on LTO tapes. I permanently have 3
tapes in a 3590 library defined to a stgpool (UATPOOL). I want to keep the
last 3 copies. So I am using the expiry features and want to use reclamation
to recover the recalimable space so that my automated backups goes
continuosly on these 3 volumes.


My problem is that I am geeting the following messages :

ANR1040I Space reclamation started for volume UATHOT01, storage pool
UAT_POOL (process number 39).
ANR1044I Removable volume UATHOT01 is required for space reclamation.
ANR0985I Process 39 for SPACE RECLAMATION running in the BACKGROUND
completed with completion state FAILURE at 16:13:35.
ANR1082W Space reclamation terminated for volume UATHOT01 - insufficient
number of mount points available for removable media.
ANR1042I Space reclamation for storage pool UAT_POOL will be retried in 60
seconds.
ANR1043I Space reclamation retry delay ended; checking volume reclamation
status for storage pool UAT_POOL.

Questions:

(j) Can i use reclaimation when i have got only i1 tape drive and the
reclamation pool is to another sequential stgpool?

(ii) what is the meaning of insufficient mount points in the message. For
info, my client nodes are defined with a max no of 2 mount points.

(iii) Why TSM is not loading teh required volume when the tape is alaready
in the library?

All assistance will be much appreciated

Thansk  regards
###

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.F-Secure.com/


Re: TDP Oracle config question

2003-07-22 Thread Conko, Steven
So is this an expected error message every time we run the TDP? Does that
mean it can be ignored?

-Original Message-
From: Neil Rasmussen [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 17, 2003 10:10 AM
To: [EMAIL PROTECTED]
Subject: Re: TDP Oracle config question


Steve,

The reason that you are seeing this error is that Oracle/Rman first tries
to delete the backuppiece that it is about to create on the TSM Server. In
this way Oracle/Rman ensures that only one copy of the backuppiece exists
on the Backup Media so Rman tries to delete the backuppiece in case it
already exists. The Rman specifications state that only one copy of a
backuppiece will exist at one time on Media Manager (DP for Oracle).

Unfortunately, Oracle/Rman also specifies that the delete routine act as
single and seperate operation, so when Oracle tries to delete a
backuppiece that does not exist, that is an error and DP for Oracle
returns that error. There is no way for DP for Oracle to determine if the
deletion is a true delete of a backuppiece or if Oracle is checking for
backuppiece existence prior to backup.

Hope this helps clear things up.

--

Date:Wed, 16 Jul 2003 13:13:39 -0600
From:Conko, Steven [EMAIL PROTECTED]
Subject: Re: TDP Oracle config question

Thanks for that bit of information... it definitely clears some things up.
According to the docs, we should be using unique TDPO_FS names for each
node
we are backing up using TDP, correct?

After doing the query and some further investigation into the BACKUPS
table,
it appears we are getting this message because of a missing -

When I do a select in the BACKUPS table, the LL_NAME shows up as:
c-3756527612-2003-0714-02

However, in the error we are getting, the name of the object is:
c-3756527612-20030714-02

Any idea why this is??

Steve



Regards,

Neil Rasmussen
Software Development
TDP for Oracle


Re: 5.2 bug?

2003-07-22 Thread Paul Zarnowski
Just as an aside, the fix for this is supposedly available in 5.1.7.1,
which is now available from the ftp site.  We saw this problem show up when
we upgraded to 5.1.7.0. ..Paul
At 01:16 PM 7/18/2003 +0200, Remco Post wrote:
Hi all,

I have a small test-server that I upgraded from 5.1.7 to 5.2 last week. To
be able to do that I had to upgrade the OS from AIX 4.3.3 to AIX 5.1 (ml4),
ever since, migration does not seem to work (I have no tapes in that box,
just a bunch of old disks) Actlog tells me:
07/18/03   08:01:05  ANR1000I Migration process 23 started for storage
pool
  BACKUPPOOL.
07/18/03   08:01:05  ANR8340I FILE volume /tsm/data/027A.BFS mounted.
07/18/03   08:01:08  ANR8341I End-of-volume reached for FILE volume
  /tsm/data/027A.BFS.
07/18/03   08:01:09  ANR8340I FILE volume /tsm/data/0283.BFS mounted.
07/18/03   08:01:25  ANRD ssutil.c(1636): ThreadId35 Invalid
format code
  - 1.
07/18/03   08:01:25  ANR1032W Migration process 23 terminated for
storage pool
  BACKUPPOOL - internal server error detected.
07/18/03   08:01:25  ANR0985I Process 23 for MIGRATION running in the
  BACKGROUND completed with completion state
FAILURE at
  08:01:25.
I deleted (del vol) a previous filedev volume (was empty), thinking that
might have been corrupted, unfortunately, that did not help. The
filesystem is a plain old JFS.
--
Met vriendelijke groeten,
Remco Post

SARA - Stichting Academisch Rekencentrum Amsterdamhttp://www.sara.nl
High Performance Computing  Tel. +31 20 592 8008Fax. +31 20 668 3167
I really didn't foresee the Internet. But then, neither did the computer
industry. Not that that tells us very much of course - the computer industry
didn't even foresee that the century was going to end. -- Douglas Adams


--
Paul Zarnowski Ph: 607-255-4757
719 Rhodes Hall, Cornell UniversityFx: 607-255-8521
Ithaca, NY 14853-3801  Em: [EMAIL PROTECTED]


Re: Can anyone help?

2003-07-22 Thread Marco Spagnuolo
Sorry gang!!

Didn't mean to send that out to the whole group!!


Marco Spagnuolo
System Administrator
University of Windsor (IT Services)
401 Sunset
Windsor, Ontario N9B 3P4
(519) 253-4232 Ext. 2769
Email: [EMAIL PROTECTED]


Re: Problem with the W2k 5.2.0.1 Client?

2003-07-22 Thread Richard Sims
Just one of my Windows 2000 SP3 servers to the 5.2.0.1 client.  My server is
5.1.1.6 on AIX 4.3.3.
...
07/22/2003 08:39:31 ANSE ntrc.cpp(890): Received Win32 RC 1450 from
FileRead(): ReadFile
...
I was also receiving errors on my old version 5.1.6.0 on this server.
Is the problem with the client or the journal engine?  Also anybody have any
ideas on how to fix this?

Refer to your Windows Return Codes reference when encountering such problems:

 1450   Insufficient system resources exist   ERROR_NO_SYSTEM_RESOURCES
to complete the requested service.

Is this an undersized PC, perhaps - too little real memory or paging space?
This would explain it occurring regardless of client level, as it is endemic
to the PC configuration.  (Have your Windows admins get that machine to SP4
when opportune, for safety.)

  Richard Sims, BU


Re: Problem with the W2k 5.2.0.1 Client?

2003-07-22 Thread Kamp, Bruce
SP4 is not an option until the vendor certifies it...
Also it is a quad Xeon system with hyper threading (looks like 8 to the OS)
 8Gig of memory pagefile size 2046-4092.
The average CPU utilization is 10%  memory 25%


--
Bruce Kamp
Midrange Systems Analyst II
Memorial Healthcare System
E: [EMAIL PROTECTED]
P: (954) 987-2020 x4597
F: (954) 985-1404
---


-Original Message-
From: Richard Sims [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 10:11 AM
To: [EMAIL PROTECTED]

Just one of my Windows 2000 SP3 servers to the 5.2.0.1 client.  My
server is
5.1.1.6 on AIX 4.3.3.
...
07/22/2003 08:39:31 ANSE ntrc.cpp(890): Received Win32 RC 1450 from
FileRead(): ReadFile
...
I was also receiving errors on my old version 5.1.6.0 on this server.
Is the problem with the client or the journal engine?  Also anybody
have any ideas on how to fix this?

Refer to your Windows Return Codes reference when encountering such
problems:

 1450   Insufficient system resources exist
ERROR_NO_SYSTEM_RESOURCES
to complete the requested service.

Is this an undersized PC, perhaps - too little real memory or paging space?
This would explain it occurring regardless of client level, as it is endemic
to the PC configuration.  (Have your Windows admins get that machine to SP4
when opportune, for safety.)

  Richard Sims, BU


Database numbers don't add up

2003-07-22 Thread Zoltan Forray/AC/VCU
TSM server V5.1.6.2 on z/OS.

Can someone explain why these numbers from a Q DB F=D don't add up (at
least they don't make sense to me ?):

  Available Space (MB): 35,160
Assigned Capacity (MB): 35,160
Maximum Extension (MB): 0
Maximum Reduction (MB): 5,372
 Page Size (bytes): 4,096
Total Usable Pages: 9,000,960
Used Pages: 4,968,239
  Pct Util: 55.2
 Max. Pct Util: 55.2
  Physical Volumes: 15

In summary, it says that of the roughly 35GB DB, only 55% is used.  In
round numbers, 20GB is in use. This means that 15GB is not.

However, the Maximum Reduction value is 5GB.

Where is the other 10GB ?

Even if TSM kept the reduction values based on the volume sizes (roughly
2.3GB per 3390-3 volume is what it is reporting), I should still be able
to reduce the size by 6-volumes, or roughly 13GB !


Re: Database numbers don't add up

2003-07-22 Thread Remco Post
On Tue, 22 Jul 2003 10:27:04 -0400
Zoltan Forray/AC/VCU [EMAIL PROTECTED] wrote:

 TSM server V5.1.6.2 on z/OS.

 Can someone explain why these numbers from a Q DB F=D don't add up (at
 least they don't make sense to me ?):

   Available Space (MB): 35,160
 Assigned Capacity (MB): 35,160
 Maximum Extension (MB): 0
 Maximum Reduction (MB): 5,372
  Page Size (bytes): 4,096
 Total Usable Pages: 9,000,960
 Used Pages: 4,968,239
   Pct Util: 55.2
  Max. Pct Util: 55.2
   Physical Volumes: 15

 In summary, it says that of the roughly 35GB DB, only 55% is used.  In
 round numbers, 20GB is in use. This means that 15GB is not.

 However, the Maximum Reduction value is 5GB.

 Where is the other 10GB ?



'In between', some people refer tot this as database fragmentation. There
are appereantly in your case, a lot op pages unused, but that cannot be
freed for database reduction. This probably has something to do with how TSM
allocates a fresh db page when it needs one, I'm guessing that it tries to
allocate pages in a way that leaves you with a as good as possible
performance. As long as you don't really need the diskspace, I wouldn't
worry. If you really do need the disks, I guess unloading than loading the
db will temporarely resolve this problem (and in the end will leavy you with
a db that performs far less than currently).

 Even if TSM kept the reduction values based on the volume sizes (roughly
 2.3GB per 3390-3 volume is what it is reporting), I should still be able
 to reduce the size by 6-volumes, or roughly 13GB !


--
Met vriendelijke groeten,

Remco Post

SARA - Stichting Academisch Rekencentrum Amsterdamhttp://www.sara.nl
High Performance Computing  Tel. +31 20 592 8008Fax. +31 20 668 3167

I really didn't foresee the Internet. But then, neither did the computer
industry. Not that that tells us very much of course - the computer industry
didn't even foresee that the century was going to end. -- Douglas Adams


Re: Can anyone help? (someone certainly needs help...)

2003-07-22 Thread Dan Goodman
ENOUGH!

It is one thing to post a commercial message on this list, eventually turning it
into a combined ADSM/misc.jobs.tivoli list; another to be able to do so unflamed.
But it is unbelievable to me that *anyone* would reply to such a post *TO THE
LIST* when the ing email address of the job listing poster is right there
for the taking?
Is this the way anyone on this list would want to advertise themselves? Or is it
the group consensus that any and everyone may have such a useful resume that it
would be in the best interest of all the list if we all posted our resumes here
on a regular basis. Maybe I'm missing something here.
Currently there are about 1600 subscribers. Even if it only takes two seconds to
recognize and delete such posts, that is about one person-hour wasted. Multiply
this be about three dozen posts per day minimum of what passes on this list. A
little consideration, PLEASE!
And I thought Usenet had deteriorated over the years.

Thanks to the people who really post useful things here that aren't *EASILY*
(and that *is* the key word!) found elsewhere, but let me be the first to
suggest that a separate list etiquette post probably should be posted here
*daily*, with a subject line something like: LOOK! READ ME BEFORE POSTING!.
Can I get a second on that?

I used to build filters to filter out certain noise. In all seriousness, I am
considering building a filter to only filter in certain posts for this list,
with Richard Sims and *.us.ibm.com as the only immediate candidates.
Can anyone else suggest a few more names I might want to leave in?

--
Dan Goodman
Systems Engineer Specialist
Thomas Jefferson University Hospital
215-503-6808
Daniel.Goodman AT mail.tju.edu

When you throw a rock into a pack of dogs, the one that yelps the loudest is
usually the one that got hit.
Marco Spagnuolo wrote:


Heather,

I may be interested in a position.  Attached is my resume.  Please contact
me with further details if you feel my qualifications and experience match
your customer's needs.
Thanks,

(See attached file: CDI-Corp-resume.doc)

Marco Spagnuolo
System Administrator
University of Windsor (IT Services)
401 Sunset
Windsor, Ontario N9B 3P4
(519) 253-4232 Ext. 2769
Email: [EMAIL PROTECTED]


  Bartel, Heather
  [EMAIL PROTECTED]To:   [EMAIL PROTECTED]
  dicorp.com  cc:
  Sent by: ADSM:  Subject:  Can anyone help?
  Dist Stor
  Manager
  [EMAIL PROTECTED]
  .edu
  07/21/2003 03:44
  PM
  Please respond to
  ADSM: Dist Stor
  Manager




Hello.  I don't know much about this list, other than I'm told those who
utilize Tivoli are subscribed to it.  I'm wondering if there is anyone out
there who may be seeking Tivoli work and may be interested in a
contract-to-hire situation for our premier client in Auburn Hills, MI.  We
are seeking a Tivoli Administrator.  If you may be interested or know
someone who may be, please let me know and I can provide all the details.
Regards,

Heather L. Bartel
Technical Recruiter
CDI Professional Services
  A division of CDI Corporation
1960 Research Drive
Suite 200
Troy, MI 48083
Phone: (248) 786-5922
Fax: (248) 786-5722
Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Check us out on the web at www.cdicorp.com http://www.cdicorp.com/





This email has been scanned for all viruses by the MessageLabs Email
Security System. For more information on a proactive email security
service working around the clock, around the globe, visit
http://www.messagelabs.com



Re: Strange query output, using ODBC interface with M$ Access ...

2003-07-22 Thread Andrew Raibeck
ADSM-L reject my original response due to size, so I have removed the
attachments and sent them to Arnaud privately. But they aren't really
critical to my response.

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]

The only dumb question is the one that goes unasked.
The command line is your friend.
Good enough is the enemy of excellence.
- Forwarded by Andrew Raibeck/Tucson/IBM on 07/22/2003 07:43 -




Andrew Raibeck
07/22/2003 07:39


To: ADSM: Dist Stor Manager [EMAIL PROTECTED]
cc:
From:   Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Subject:Re: Strange query output, using ODBC interface
with M$ Access ...


Hello Arnaud,

I am unable to reproduce your problem. Attached is a .jpg file
(tmodbc.jpg) showing my results. My TSM server is version 5.1.7.0, ODBC
driver is 5.1.6.0, Access is 2002 version 10.4302.4219 SP-2. I have also
tried this with the 5.2.0.0 ODBC driver and Access 2000 version 9.0.3821
SR-1, and it works for me.



Here are the messages that appear on my TSM console when I run the query:


ANR0407I Session 47 started for administrator SHERIDAN (WinNT) (Tcp/Ip
9.11.153.65(1078)).
ANR2017I Administrator SHERIDAN issued command: DEFINE CURSOR C358701c
SQL=SELECT START_TIME ,END_TIME ,ACTIVITY ,ENTITY ,BYTES
FROM ADSM.SUMMARY WHERE (ACTIVITY = 'STGPOOL BACKUP' ) 
ANR2017I Administrator SHERIDAN issued command: DISPLAY CURSOR C358701c
ANR2017I Administrator SHERIDAN issued command: OPEN CURSOR C358701c
ANR2017I Administrator SHERIDAN issued command: FETCH NEXT 50
ANR2017I Administrator SHERIDAN issued command: CLOSE CURSOR
ANR2017I Administrator SHERIDAN issued command: DELETE CURSOR C358701c
ANR0405I Session 47 ended for administrator SHERIDAN (WinNT).


Here are the steps I used to attempt to reproduce your scenario:

1) Start Microsoft Access.

2) Create a new blank database.

3) Link to SUMMARY table. When presented with list of columns to choose
for unique record identifier, I just clicked OK.

4) Select View/Database Objects/Queries menu item.

5) Double-click Create query in Design view. In the Show Table dialog,
I selected SUMMARY and clicked Add, then Close.

6) Select View/SQL View menu item.

7) Copy and paste your exact SQL (as shown in your original post) into the
Select Query window.

FYI, I have attached a .jpg file, design.jpg, that shows the resulting
design view.



8) Select View/Datasheet View menu item. I get the results shown in the
attached .jpg file.

..

Try this:

a) From the same machine you run Access on, start the Admin client in
console mode:

   dsmadmc -console

This will allow you to watch the commands sent to the TSM server as they
occur.

b) Try my steps above (create a new Access database, do not use an
existing database). Watch the Admin console when you perform step #8. What
do you get?

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]

The only dumb question is the one that goes unasked.
The command line is your friend.
Good enough is the enemy of excellence.




PAC Brion Arnaud [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED]
07/21/2003 08:33
Please respond to ADSM: Dist Stor Manager


To: [EMAIL PROTECTED]
cc:
Subject:Strange query output, using ODBC interface with M$ Access ...



Hi list,

I'm currently using TSM ODBC (V 5.1.6.0)  interface with an Access 2002
database (V 10.4302.4219 sp-2), and built a  query looking like :
SELECT SUMMARY.START_TIME, SUMMARY.END_TIME, SUMMARY.ACTIVITY,
SUMMARY.ENTITY, SUMMARY.BYTES, DateDiff(w,[START_TIME],Now()) AS
timediff
FROM SUMMARY
WHERE (((SUMMARY.ACTIVITY)=STGPOOL BACKUP) AND
((DateDiff(w,[START_TIME],Now()))1));

Basically, this should extract all stgpool backup jobs registered in
summary table, which have been started during the last day.
Now, this is what  that query returned (snippet of it, sorry for bad
formating) :

1/7/2003 11:04:11   1/7/2003 11:04:17   BACKUP  PACRS270
  102604912
15/7/2003 5:00:14   15/7/2003 8:59:32   STGPOOL BACKUP
TAPELTO1_INF_DB - COPYLTO1_INF_DB 2023371194890
15/7/2003 8:59:32   15/7/2003 8:59:50   STGPOOL BACKUP
DISKPOOL_ARCH - COPYLTO1_ARCH   0   0
15/7/2003 8:59:32   15/7/2003 9:00:46   STGPOOL BACKUP
DISKPOOL_SQL_LOGS - COPYLTO1_SQL_LOGS   553779200
15/7/2003 8:59:32   15/7/2003 9:01:32   STGPOOL BACKUP
DISKPOOL_DB2_L0 - COPYLTO1_DB2_L0 798760960
1/7/2003 11:04:57   1/7/2003 11:05:03   BACKUP  PACRS270
  102604912

Re: 5.2 bug?

2003-07-22 Thread Remco Post
On Tue, 22 Jul 2003 09:42:39 -0400
Paul Zarnowski [EMAIL PROTECTED] wrote:

 Just as an aside, the fix for this is supposedly available in 5.1.7.1,
 which is now available from the ftp site.  We saw this problem show up when
 we upgraded to 5.1.7.0. ..Paul


or on 5.2.0.1 that just showed up Thanks ;-)

 At 01:16 PM 7/18/2003 +0200, Remco Post wrote:
 Hi all,
 
 I have a small test-server that I upgraded from 5.1.7 to 5.2 last week. To
 be able to do that I had to upgrade the OS from AIX 4.3.3 to AIX 5.1 (ml4),
 ever since, migration does not seem to work (I have no tapes in that box,
 just a bunch of old disks) Actlog tells me:
 
 
 07/18/03   08:01:05  ANR1000I Migration process 23 started for storage
 pool
BACKUPPOOL.
 07/18/03   08:01:05  ANR8340I FILE volume /tsm/data/027A.BFS mounted.
 07/18/03   08:01:08  ANR8341I End-of-volume reached for FILE volume
/tsm/data/027A.BFS.
 07/18/03   08:01:09  ANR8340I FILE volume /tsm/data/0283.BFS mounted.
 07/18/03   08:01:25  ANRD ssutil.c(1636): ThreadId35 Invalid
 format code
- 1.
 07/18/03   08:01:25  ANR1032W Migration process 23 terminated for
 storage pool
BACKUPPOOL - internal server error detected.
 07/18/03   08:01:25  ANR0985I Process 23 for MIGRATION running in the
BACKGROUND completed with completion state
  FAILURE at
08:01:25.
 
 
 I deleted (del vol) a previous filedev volume (was empty), thinking that
 might have been corrupted, unfortunately, that did not help. The
 filesystem is a plain old JFS.
 
 --
 Met vriendelijke groeten,
 
 Remco Post
 
 SARA - Stichting Academisch Rekencentrum Amsterdamhttp://www.sara.nl
 High Performance Computing  Tel. +31 20 592 8008Fax. +31 20 668 3167
 
 I really didn't foresee the Internet. But then, neither did the computer
 industry. Not that that tells us very much of course - the computer industry
 didn't even foresee that the century was going to end. -- Douglas Adams


 --
 Paul Zarnowski Ph: 607-255-4757
 719 Rhodes Hall, Cornell UniversityFx: 607-255-8521
 Ithaca, NY 14853-3801  Em: [EMAIL PROTECTED]


--
Met vriendelijke groeten,

Remco Post

SARA - Stichting Academisch Rekencentrum Amsterdamhttp://www.sara.nl
High Performance Computing  Tel. +31 20 592 8008Fax. +31 20 668 3167

I really didn't foresee the Internet. But then, neither did the computer
industry. Not that that tells us very much of course - the computer industry
didn't even foresee that the century was going to end. -- Douglas Adams


Re: Problem with the W2k 5.2.0.1 Client?

2003-07-22 Thread Andrew Raibeck
Yes, SP4 is only recently available so we do not know what, if any,
incompatibilities may exist between TSM and SP4. However, for those who
choose to install SP4, we will support it to as great an extent as
possible, i.e. if you report a problem and it turns out to be a bug in
TSM, we will take an APAR for it.

I don't know what the RC 1450 problem is off-hand, but a quick review of
similar reported problems suggest looking at the following MS KB articles:

142719 - Windows Reports Out Of Resources Error When Memory Is Available

192409 - Open Files Can Cause Kernel to Report INSUFFICIENT_RESOURCES

236964 - Delayed Return of Paged Pool Causes Error 1450 Insufficient
Resources

247904 - How To Configure the Paged Address Pool and System Page Table
Entry Memory Areas

304101 - Backup Fails with Event ID 1450

You might check these out, though I can not say for sure whether they will
help. However, Q142719 was helpful in resolving in at least one case.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]

The only dumb question is the one that goes unasked.
The command line is your friend.
Good enough is the enemy of excellence.




Kamp, Bruce [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED]
07/22/2003 07:22
Please respond to ADSM: Dist Stor Manager


To: [EMAIL PROTECTED]
cc:
Subject:Re: Problem with the W2k 5.2.0.1 Client?



SP4 is not an option until the vendor certifies it...
Also it is a quad Xeon system with hyper threading (looks like 8 to the
OS)
 8Gig of memory pagefile size 2046-4092.
The average CPU utilization is 10%  memory 25%


--
Bruce Kamp
Midrange Systems Analyst II
Memorial Healthcare System
E: [EMAIL PROTECTED]
P: (954) 987-2020 x4597
F: (954) 985-1404
---


-Original Message-
From: Richard Sims [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 10:11 AM
To: [EMAIL PROTECTED]

Just one of my Windows 2000 SP3 servers to the 5.2.0.1 client.  My
server is
5.1.1.6 on AIX 4.3.3.
...
07/22/2003 08:39:31 ANSE ntrc.cpp(890): Received Win32 RC 1450 from
FileRead(): ReadFile
...
I was also receiving errors on my old version 5.1.6.0 on this server.
Is the problem with the client or the journal engine?  Also anybody
have any ideas on how to fix this?

Refer to your Windows Return Codes reference when encountering such
problems:

 1450   Insufficient system resources exist
ERROR_NO_SYSTEM_RESOURCES
to complete the requested service.

Is this an undersized PC, perhaps - too little real memory or paging
space?
This would explain it occurring regardless of client level, as it is
endemic
to the PC configuration.  (Have your Windows admins get that machine to
SP4
when opportune, for safety.)

  Richard Sims, BU


Re: Can anyone help? (someone certainly needs help...)

2003-07-22 Thread Ochs, Duane
Quite a rant Dan... But I think if you filter everyone else, you might as
well go to IBM.com for your answers... Besides we all just *READ* your
message ( 5 minutes) and deleted for a loss of about 133 person-hours for a
message that has nothing to do with ADSM. Both senders E-mail was in the
messages and you also sent to the list how is that different ?

Sorry for the response but I had to say something.

-Original Message-
From: Dan Goodman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 9:45 AM
To: [EMAIL PROTECTED]
Subject: Re: Can anyone help? (someone certainly needs help...)


ENOUGH!

It is one thing to post a commercial message on this list, eventually
turning it
into a combined ADSM/misc.jobs.tivoli list; another to be able to do so
unflamed.

But it is unbelievable to me that *anyone* would reply to such a post *TO
THE
LIST* when the ing email address of the job listing poster is right
there
for the taking?

Is this the way anyone on this list would want to advertise themselves? Or
is it
the group consensus that any and everyone may have such a useful resume that
it
would be in the best interest of all the list if we all posted our resumes
here
on a regular basis. Maybe I'm missing something here.

Currently there are about 1600 subscribers. Even if it only takes two
seconds to
recognize and delete such posts, that is about one person-hour wasted.
Multiply
this be about three dozen posts per day minimum of what passes on this list.
A
little consideration, PLEASE!

And I thought Usenet had deteriorated over the years.

Thanks to the people who really post useful things here that aren't *EASILY*
(and that *is* the key word!) found elsewhere, but let me be the first to
suggest that a separate list etiquette post probably should be posted here
*daily*, with a subject line something like: LOOK! READ ME BEFORE
POSTING!.

Can I get a second on that?

I used to build filters to filter out certain noise. In all seriousness, I
am
considering building a filter to only filter in certain posts for this list,
with Richard Sims and *.us.ibm.com as the only immediate candidates.

Can anyone else suggest a few more names I might want to leave in?

--
Dan Goodman
Systems Engineer Specialist
Thomas Jefferson University Hospital
215-503-6808

Daniel.Goodman AT mail.tju.edu

When you throw a rock into a pack of dogs, the one that yelps the loudest
is
usually the one that got hit.


Marco Spagnuolo wrote:



 Heather,

 I may be interested in a position.  Attached is my resume.  Please contact
 me with further details if you feel my qualifications and experience match
 your customer's needs.

 Thanks,

 (See attached file: CDI-Corp-resume.doc)

 Marco Spagnuolo
 System Administrator
 University of Windsor (IT Services)
 401 Sunset
 Windsor, Ontario N9B 3P4
 (519) 253-4232 Ext. 2769
 Email: [EMAIL PROTECTED]



   Bartel, Heather
   [EMAIL PROTECTED]To:
[EMAIL PROTECTED]
   dicorp.com  cc:
   Sent by: ADSM:  Subject:  Can anyone help?
   Dist Stor
   Manager
   [EMAIL PROTECTED]
   .edu


   07/21/2003 03:44
   PM
   Please respond to
   ADSM: Dist Stor
   Manager





 Hello.  I don't know much about this list, other than I'm told those who
 utilize Tivoli are subscribed to it.  I'm wondering if there is anyone out
 there who may be seeking Tivoli work and may be interested in a
 contract-to-hire situation for our premier client in Auburn Hills, MI.  We
 are seeking a Tivoli Administrator.  If you may be interested or know
 someone who may be, please let me know and I can provide all the details.


 Regards,

 Heather L. Bartel
 Technical Recruiter
 CDI Professional Services
   A division of CDI Corporation
 1960 Research Drive
 Suite 200
 Troy, MI 48083
 Phone: (248) 786-5922
 Fax: (248) 786-5722
 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 Check us out on the web at www.cdicorp.com http://www.cdicorp.com/





 
 This email has been scanned for all viruses by the MessageLabs Email
 Security System. For more information on a proactive email security
 service working around the clock, around the globe, visit
 http://www.messagelabs.com
 



Re: Can anyone help? (someone certainly needs help...)

2003-07-22 Thread Patrick Boutilier
Perhaps this list should remove the Reply-To: header? This is the only
list that I am on that replies to the list instead of the sender of the
message.
Ochs, Duane wrote:
Quite a rant Dan... But I think if you filter everyone else, you might as
well go to IBM.com for your answers... Besides we all just *READ* your
message ( 5 minutes) and deleted for a loss of about 133 person-hours for a
message that has nothing to do with ADSM. Both senders E-mail was in the
messages and you also sent to the list how is that different ?
Sorry for the response but I had to say something.


TSM web client gave BLUE screen on Win2K SP3 server

2003-07-22 Thread Jin Bae Chi
Experts,

Trying to installl TSM baclient 5.1.0.0 on Windows 2000 SP3 server with oslevel 5.0. 
When start web client managed by CAD gave a BLUE screen that said .. no exception 
handling...and a bunch of 0 numbers. Event from Windows shows the followings;


Event Type: Error
Event Source:   Service Control Manager
Event Category: None
Event ID:   7023
Date:   7/21/2003
Time:   4:19:02 PM
User:   N/A
Computer:   GIS
Description:
The TSM Remote Client Agent service terminated with the following error: 
%%4294967295 


Event Type: Error
Event Source:   Service Control Manager
Event Category: None
Event ID:   7024
Date:   7/21/2003
Time:   4:20:43 PM
User:   N/A
Computer:   GIS
Description:

The TSM Scheduler service terminated with service-specific error 12. 


Anybody experienced a similar thing happend or any known bug? Thanks again your help. 
TSM server 5.1.6 on AIX 4.3.3


Gus


Re: Database numbers don't add up

2003-07-22 Thread Loon, E.J. van - SPLXM
Hi Zoltan!
There is a formula to check your 'fragmentation' level to verify Remco's
explanation:

SELECT CAST((100 - (CAST(MAX_REDUCTION_MB AS FLOAT) * 256 ) /
(CAST(USABLE_PAGES AS FLOAT) - CAST(USED_PAGES AS FLOAT) ) * 100) AS
DECIMAL(4,2)) AS PERCENT_FRAG FROM DB

Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines

-Original Message-
From: Remco Post [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 16:42
To: [EMAIL PROTECTED]
Subject: Re: Database numbers don't add up


On Tue, 22 Jul 2003 10:27:04 -0400
Zoltan Forray/AC/VCU [EMAIL PROTECTED] wrote:

 TSM server V5.1.6.2 on z/OS.

 Can someone explain why these numbers from a Q DB F=D don't add up (at
 least they don't make sense to me ?):

   Available Space (MB): 35,160
 Assigned Capacity (MB): 35,160
 Maximum Extension (MB): 0
 Maximum Reduction (MB): 5,372
  Page Size (bytes): 4,096
 Total Usable Pages: 9,000,960
 Used Pages: 4,968,239
   Pct Util: 55.2
  Max. Pct Util: 55.2
   Physical Volumes: 15

 In summary, it says that of the roughly 35GB DB, only 55% is used.  In
 round numbers, 20GB is in use. This means that 15GB is not.

 However, the Maximum Reduction value is 5GB.

 Where is the other 10GB ?



'In between', some people refer tot this as database fragmentation. There
are appereantly in your case, a lot op pages unused, but that cannot be
freed for database reduction. This probably has something to do with how TSM
allocates a fresh db page when it needs one, I'm guessing that it tries to
allocate pages in a way that leaves you with a as good as possible
performance. As long as you don't really need the diskspace, I wouldn't
worry. If you really do need the disks, I guess unloading than loading the
db will temporarely resolve this problem (and in the end will leavy you with
a db that performs far less than currently).

 Even if TSM kept the reduction values based on the volume sizes (roughly
 2.3GB per 3390-3 volume is what it is reporting), I should still be able
 to reduce the size by 6-volumes, or roughly 13GB !


--
Met vriendelijke groeten,

Remco Post

SARA - Stichting Academisch Rekencentrum Amsterdamhttp://www.sara.nl
High Performance Computing  Tel. +31 20 592 8008Fax. +31 20 668 3167

I really didn't foresee the Internet. But then, neither did the computer
industry. Not that that tells us very much of course - the computer industry
didn't even foresee that the century was going to end. -- Douglas Adams


**
For information, services and offers, please visit our web site: http://www.klm.com. 
This e-mail and any attachment may contain confidential and privileged material 
intended for the addressee only. If you are not the addressee, you are notified that 
no part of the e-mail or any attachment may be disclosed, copied or distributed, and 
that any other action related to this e-mail or attachment is strictly prohibited, and 
may be unlawful. If you have received this e-mail by error, please notify the sender 
immediately by return e-mail, and delete this message. Koninklijke Luchtvaart 
Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for 
the incorrect or incomplete transmission of this e-mail or any attachments, nor 
responsible for any delay in receipt.
**


Re: SV: Restore of a NetWare Cluster... what's happening?

2003-07-22 Thread Lee Wilson
Or could the reason be at this web link?
http://groups.google.ca/groups?q=tivoli+backup+of+NSShl=enlr=ie=UTF-8oe=UTF-8selm=3CBF1527.133BD849%40email.unc.edurnum=4

 [EMAIL PROTECTED] 07/17/03 04:19AM 
.. by the way - if I make a restore of 1 file, size around 6 kb - it cannot be 
restored before any migration and/or databasebackup has been stopped...

So I'm certain the problem is related to the filespace made by a NetWare Cluster!

Regards
Flemming

-Oprindelig meddelelse-
Fra: Richard Sims [mailto:[EMAIL PROTECTED] 
Sendt: 16. juli 2003 13:54
Til: [EMAIL PROTECTED] 
Emne: Re: Restore of a NetWare Cluster... what's happening?


...
On server: ANR0481W Session 49492 for node NODENAME
(NetWare)terminated - client did not respond within 300 seconds.
...

Sounds like your server COMMTimeout value is unrealistically low
for major client operations.

  Richard Sims, BU


Tape performance

2003-07-22 Thread Brenda Collins
I am wondering if there is something in TSM that throttles the tape
performance we should be getting.  I can do a dd test from the operating
system to the tape drive and with that receive 2 GB per minute (32 MB/sec)
but when I do a test through TSM, I only get 1 GB per minute.

My environment is:
TSM 5.7.0 on Solaris 8
Server: Sunfire 880
Tape drives are 9840 Fibre attached.

As a result, we are questioning the value of putting in the more expensive
tape drives when we can't seem to pump the data through as expected.

Any ideas of what I might look at would be appreciated.

Thanks,
Brenda Collins
ING


Tivoli and Novell NSS

2003-07-22 Thread Lee Wilson
We are considering adding Novell NSS volumes to our servers.  Does anyone have any 
experience with backing up NSS volumes?  We are using NetWare 6.0 SP2, are there any 
issues Tivoli vs NSS we should be aware of prior to taking on the migration to NSS?  
Does Tivoli work well with NSS when backing up data, what about restore?
 
Thanks in advance.
 
Lee Wilson  CNA
Network Server Support Specialist
Computing and Network Services
Grant MacEwan College
Phone(780)497-5591 Cell (780)982-2114
or Fax (780)497-5595
http://www.MacEwan.ca


Re: Tape performance

2003-07-22 Thread Richard Sims
I am wondering if there is something in TSM that throttles the tape
performance we should be getting.  I can do a dd test from the operating
system to the tape drive and with that receive 2 GB per minute (32 MB/sec)
but when I do a test through TSM, I only get 1 GB per minute.

My environment is:
TSM 5.7.0 on Solaris 8
Server: Sunfire 880
Tape drives are 9840 Fibre attached.

As a result, we are questioning the value of putting in the more expensive
tape drives when we can't seem to pump the data through as expected.

Any ideas of what I might look at would be appreciated.

Now, why did you not tell us what the test was?  :-)
Perspective and context is everything when trying to respond to postings.
You very much did the right thing in getting isolated benchmark numbers first.

Was the test a single, very large file so as to keep database updating out
of the picture, rather than many small files?  Was the client co-resident on
the server system as to keep network contention out of the picture?  All
them factors.

  Richard Sims, BU


Re: Tivoli and Novell NSS

2003-07-22 Thread Jim Kirkman
Lee,

You actually pointed to the key for NSS volume backup with the link in
your earlier post regarding Flemming's restore situation.

Novell's TID 10065605 and patch NW6SMS1A.EXE are needed. In particular,
you need the following entry in the smsrun.bas file: nlmArray =
Array(SMDR, TSA600 /cluster=off, TSAPROXY)in order for TSM to
recognize the clustered volumes.

Lee Wilson wrote:

 We are considering adding Novell NSS volumes to our servers.  Does anyone have any 
 experience with backing up NSS volumes?  We are using NetWare 6.0 SP2, are there any 
 issues Tivoli vs NSS we should be aware of prior to taking on the migration to NSS?  
 Does Tivoli work well with NSS when backing up data, what about restore?

 Thanks in advance.

 Lee Wilson  CNA
 Network Server Support Specialist
 Computing and Network Services
 Grant MacEwan College
 Phone(780)497-5591 Cell (780)982-2114
 or Fax (780)497-5595
 http://www.MacEwan.ca

--
Jim Kirkman
AIS - Systems
UNC-Chapel Hill
966-5884


Re: Tape performance

2003-07-22 Thread Brenda Collins
The test to move data from the operating system was just a 10GB file,
although it was all zero's.

The tape performance on TSM was achieved by doing a disk to tape.  We took
the ratings from doing a backup storagepool to tape.  We tried it with
storagepools that had filesystems and databases, the results are fairly
close to the same.  Our disk is on the SAN so we do not go through the
network.

Here are results from some new tests we just performed today.  (Our drives
are 9840B)

DD Test with CBN and RMT drivers


# mt -f /dev/rmt/6cbn status
StorageTek 9840B tape drive:
   sense key(0x6)= Unit Attention   residual= 0   retries= 0
   file no= 0   block no= 0
# time dd if=/dev/zero of=/dev/rmt/6cbn bs=256k count=4
4+0 records in
4+0 records out

RESULT:  38.78 MB/Sec

real4m24.29s
user0m0.17s
sys 1m13.05s
# time dd if=/dev/zero of=/dev/rmt/15mt bs=256k count=4
4+0 records in
4+0 records out

real5m15.57s
user0m0.19s
sys 1m50.37s
#

RESULT:  32.5 MB/Sec

Here is a core file used to test performance, with 453 MBytes, it take
average of 2.2 minutes...

# time tar -cvf /dev/rmt/14mt core
a core 453736K

real2m22.37s
user0m0.44s
sys 0m28.28s
# time tar -cvf /dev/rmt/14mt core
a core 453736K

real2m19.16s
user0m0.25s
sys 0m28.79s




|-+
| |   Richard Sims |
| |   [EMAIL PROTECTED] |
| ||
| |   07/22/2003 12:23 |
| |   PM   |
| |   Please respond to|
| |   ADSM: Dist Stor |
| |   Manager |
| ||
|-+
  
--|
  |
  |
  |   To:   [EMAIL PROTECTED]  
   |
  |   cc:  
  |
  |   Subject:  Re: Tape performance   
  |
  
--|



I am wondering if there is something in TSM that throttles the tape
performance we should be getting.  I can do a dd test from the operating
system to the tape drive and with that receive 2 GB per minute (32 MB/sec)
but when I do a test through TSM, I only get 1 GB per minute.

My environment is:
TSM 5.7.0 on Solaris 8
Server: Sunfire 880
Tape drives are 9840 Fibre attached.

As a result, we are questioning the value of putting in the more expensive
tape drives when we can't seem to pump the data through as expected.

Any ideas of what I might look at would be appreciated.

Now, why did you not tell us what the test was?  :-)
Perspective and context is everything when trying to respond to postings.
You very much did the right thing in getting isolated benchmark numbers
first.

Was the test a single, very large file so as to keep database updating out
of the picture, rather than many small files?  Was the client co-resident
on
the server system as to keep network contention out of the picture?  All
them factors.

  Richard Sims, BU


Re: Tape performance

2003-07-22 Thread Richard Sims
I am wondering if there is something in TSM that throttles the tape
performance we should be getting.  I can do a dd test from the operating
system to the tape drive and with that receive 2 GB per minute (32 MB/sec)
but when I do a test through TSM, I only get 1 GB per minute.

The test to move data from the operating system was just a 10GB file,
although it was all zero's.
...

Thanks, that extra info helps a lot...
The T9840B FICON Tape Drive Specifications that I see on the vendor web site
quote Performance, native 19 MB/sec.  I thought the 32 MB/s was a high
number.  I suspect that you did not disable tape drive compression in your
all-zero's test, and so ended up with a number which was a great test of your
FC, but not the drive-media.  In context, your ~16 MB/s TSM speed seems
excellent, then.  I'd be happy with that number.

Customers who also have 9840B drives might want to chime in on their
experiences.

  Richard Sims, BU


Complete a SQL statement

2003-07-22 Thread Fred Johanson
I have a domain admin who'd like to find obsolete filespaces.  This is his
SQL script:
select filespaces.node_name,filespaces.filespace_name,filespaces.backup_end
from -
 filespaces where (($1  -
 days(current_timestamp) - days(backup_end) or -
 backup_end is null) and filespaces.node_name in (select nodes.node_name
from nodes where domain_name=upper('$2'))
And this is the result:

tsm: TSMrun sincelast_fs 30 csm
ANR2909E The SQL statement is incomplete; additional tokens are required.
ANR1463E RUN: Command script SINCELAST_FS completed in error.
ANS8001I Return code 4.
What is missing??


Re: Complete a SQL statement

2003-07-22 Thread Allen Barth
Fred

the number of parens is not balanced.  You're missing a right paren
somewhere.






Fred Johanson [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED]
07/22/03 02:34 PM
Please respond to ADSM: Dist Stor Manager


To: [EMAIL PROTECTED]
cc:
Subject:Complete a SQL statement


I have a domain admin who'd like to find obsolete filespaces.  This is his
SQL script:

select
filespaces.node_name,filespaces.filespace_name,filespaces.backup_end
from -
  filespaces where (($1  -
  days(current_timestamp) - days(backup_end) or -
  backup_end is null) and filespaces.node_name in (select nodes.node_name
from nodes where domain_name=upper('$2'))

And this is the result:

tsm: TSMrun sincelast_fs 30 csm
ANR2909E The SQL statement is incomplete; additional tokens are required.
ANR1463E RUN: Command script SINCELAST_FS completed in error.
ANS8001I Return code 4.

What is missing??


Re: fiber attached 3590's for mksysb under AIX ?

2003-07-22 Thread Kenneth Susan Bury
We tested the SCSI process that you described but did not carry it over to
fibre. However, there really isn't all that much difference in the way AIX
recognizes fibre drives verses SCSI drives. You shouldn't have any trouble
converting the SCSI process to fibre.

Ken

 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]
 On Behalf Of Dwight Cook
 Sent: Tuesday, July 22, 2003 07:44
 To: [EMAIL PROTECTED]
 Subject: fiber attached 3590's for mksysb under AIX ?


 Kind of off topic but it is protection of TSM servers...

 We are still running with all SCSI attached 3590's both B1A's
 and E1A's

 nice thing is you can use mtlib to mount a tape, then cut a
 mksysb to that drive  tape

 Two TSM environments require capacity increases and I'm
 wondering if that occurs with upgrades of B1A's to newer E's
 or H's, and if I go with fiber attached this time if the
 drives will still be valid devices to cut mksysb's to ? ? ?

 so are any TSM'ers with aix boxes  fiber attached drives
 doing this ? ? ?

 (it makes for a real slick automated monthly mksysb process
 to better protect your TSM environments)

 just wondering...

 Dwight



help:server recovery

2003-07-22 Thread
Hi all,I deleted my logvol form my OS,my logmode is normal and I don't backup my db 
also.How can I recovery the server?
Thanx!
liming
[EMAIL PROTECTED]
2003-07-23


Re: help:server recovery

2003-07-22 Thread Pole, Stephen
I s your resume up to date :-)

I am sure someone else here will help you.

Cheeers

Stephen

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 23 July, 2003 11:24 AM
To: [EMAIL PROTECTED]
Subject: help:server recovery


Hi all,I deleted my logvol form my OS,my logmode is normal and I don't
backup my db also.How can I recovery the server?
Thanx!
liming
[EMAIL PROTECTED]
2003-07-23


FW: fiber attached 3590's for mksysb under AIX ?

2003-07-22 Thread Rane, Yashwant
We have fibre attached 3590's attached to RS/6000 Model F80. We can cut mksysb on 
these drives but can not boot from this mksysb tape using fibre attached 3590.

we are working with IBM H/W to make it work (as this is supported config.), but still 
no success.

Is there anybody tested booting using mksysb tape using fibre attached 3590?


Rane


-Original Message-
From: Kenneth  Susan Bury [mailto:[EMAIL PROTECTED]
Sent: Wed, July 23, 2003 3:04 AM
Subject: Re: fiber attached 3590's for mksysb under AIX ?


We tested the SCSI process that you described but did not carry it over to
fibre. However, there really isn't all that much difference in the way AIX
recognizes fibre drives verses SCSI drives. You shouldn't have any trouble
converting the SCSI process to fibre.

Ken

 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]
 On Behalf Of Dwight Cook
 Sent: Tuesday, July 22, 2003 07:44
 To: [EMAIL PROTECTED]
 Subject: fiber attached 3590's for mksysb under AIX ?


 Kind of off topic but it is protection of TSM servers...

 We are still running with all SCSI attached 3590's both B1A's
 and E1A's

 nice thing is you can use mtlib to mount a tape, then cut a
 mksysb to that drive  tape

 Two TSM environments require capacity increases and I'm
 wondering if that occurs with upgrades of B1A's to newer E's
 or H's, and if I go with fiber attached this time if the
 drives will still be valid devices to cut mksysb's to ? ? ?

 so are any TSM'ers with aix boxes  fiber attached drives
 doing this ? ? ?

 (it makes for a real slick automated monthly mksysb process
 to better protect your TSM environments)

 just wondering...

 Dwight



Error in deleting filespace

2003-07-22 Thread Zosimo Noriega
Hi all, I got the error in deleting filespace, please see the log from
activity log.
I hope everybody can help me.  thanks.

Zosi Noriega


07/23/03 08:33:59 ANR2017I Administrator ZBN3669 issued command: DELETE

   FILESPACE SAPPLIBP1 3 NAMETYPE=FSID TYPE=ANY DATA=ANY

   WAIT=NO

07/23/03 08:33:59 ANR0984I Process 2546 for DELETE FILESPACE started in
the
   BACKGROUND at 08:33:59.

07/23/03 08:33:59 ANR0802I DELETE FILESPACE Registries (fsId=3)
(backup/arc-
   hive data) for node SAPPLIBP1 started.

07/23/03 08:33:59 ANR0800I DELETE FILESPACE Registries (fsId=3) for node

   SAPPLIBP1 started as process 2546.

07/23/03 08:33:59 ANR0609I DELETE FILESPACE started as process 2546.

07/23/03 08:33:59 ANR0104E imutil.c(7529): Error 2 deleting row from
table
   Expiring.Objects.

07/23/03 08:33:59 ANRD imfsdel.c(1863): ThreadId79 Error 19
deleting
   group leader 0 48984968.

07/23/03 08:33:59 ANR0985I Process 2546 for DELETE FILESPACE running in
the
   BACKGROUND completed with completion state FAILURE at

   08:33:59.

This e-mail may contain confidential and/or priviledged information. If you are not 
the intended recepient (or have received this e-mail in error) please notify the 
sender immediately and destroy this e-mail.