× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi Paul,

These message looks like your ts3220 is full, I mean all slots and drives are filled up and TS is having trouble to move medias between drives and slots, I got some messages like that on the other company and it was
resolved by ejecting couple of tapes, try to remove couple of tapes, reboot the library then run inventory again,

hope that helps.

Altino


-----Mensagem original-----
De: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] Em nome de midrange-l-request@xxxxxxxxxxxx
Enviada em: segunda-feira, 9 de fevereiro de 2015 14:09
Para: midrange-l@xxxxxxxxxxxx
Assunto: MIDRANGE-L Digest, Vol 14, Issue 181

Send MIDRANGE-L mailing list submissions to
midrange-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/midrange-l
or, via email, send a message with subject or body 'help' to
midrange-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
midrange-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific than "Re: Contents of MIDRANGE-L digest..."


*** NOTE: When replying to this digest message, PLEASE remove all text unrelated to your reply and change the subject line so it is meaningful.

Today's Topics:

1. finding differences between 2 files (Chris Pando)
2. AW: finding differences between 2 files (Birgitta Hauser)
3. AW: finding differences between 2 files (Birgitta Hauser)
4. should QSYS2 be in system portion of Library list? (Gqcy)
5. Re: should QSYS2 be in system portion of Library list?
(rob@xxxxxxxxx)
6. Can someone help me with my Query/400 quest? (yes, I know,
it's prehistoric ;) (Rene van der Kraats)
7. Re: finding differences between 2 files (Mark S Waterbury)
8. RE: Can someone help me with my Query/400 quest? (yes, I
know, it's prehistoric ;) (Lance Gillespie)
9. TS 3200 (3573) 80 8A 4B Inventory lost - destination probably
full (Steinmetz, Paul)


----------------------------------------------------------------------

message: 1
date: Sun, 8 Feb 2015 22:55:29 -0600
from: Chris Pando <chris.pando@xxxxxxxxx>
subject: finding differences between 2 files

Not an SQL solution, but I have an RPG utility that will print out the differences between two files with identical layouts and a unique key:

http://www.brilligware.com/cp1030.html


Chris
chris@xxxxxxxxx
www.brilligware.com - the home of MineSweeper5250


------------------------------

message: 2
date: Mon, 9 Feb 2015 07:41:31 +0100
from: "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>
subject: AW: finding differences between 2 files

For finding out in which table the row is located you may try the following
statement:

With x as ( ( Select * from YourTable1
Except
Select * from YourTable2)
Union
( Select * from YourTable2
Except
Select * from YourTable1))
( Select 'YOURTABLE1', x.* From x
Intersect
Select 'YOURTABLE1', a.* From YourTable1 a) Union
( Select 'YOURTABLE2', x.* From x
Intersect
Select 'YOURTABLE'2, b.* From ADRESSEX b) Order By Key1, Key2 ... KeyN, 1

Mit freundlichen Gr??en / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok) "What is worse than training your staff and losing them? Not training them and keeping them!"

-----Urspr?ngliche Nachricht-----
Von: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Chris Pando
Gesendet: Monday, 09.2 2015 05:55
An: MIDRANGE-L@xxxxxxxxxxxx
Betreff: finding differences between 2 files

Not an SQL solution, but I have an RPG utility that will print out the differences between two files with identical layouts and a unique key:

http://www.brilligware.com/cp1030.html


Chris
chris@xxxxxxxxx
www.brilligware.com - the home of MineSweeper5250
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.




------------------------------

message: 3
date: Mon, 9 Feb 2015 08:44:03 +0100
from: "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>
subject: AW: finding differences between 2 files

Sorry there was a typo in my previous post:
Again the revised SQL statement

With x as ( ( Select * from YourTable1
Except
Select * from YourTable2)
Union
( Select * from YourTable2
Except
Select * from YourTable1))
( Select 'YOURTABLE1', x.* From x
Intersect
Select 'YOURTABLE1', a.* From YourTable1 a) Union
( Select 'YOURTABLE2', x.* From x
Intersect
Select 'YOURTABLE'2, b.* From YourTable2 b) Order By Key1, Key2 ... KeyN, 1

Mit freundlichen Gr??en / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok) "What is worse than training your staff and losing them? Not training them and keeping them!"




------------------------------

message: 4
date: Mon, 09 Feb 2015 09:30:58 -0600
from: Gqcy <gmufasa01@xxxxxxxxx>
subject: should QSYS2 be in system portion of Library list?

I ask because because in the latest DB ptf group a file object called "LIBLIST" was produced.
it is a view over QSYS2.QSQLIBL.

I notice that there are lots of objects that don't have "Q" names in QSYS2...

we had some apps break because we had a production file of the same name...

I presume that in the PTF cover letters it would have told me of this.





------------------------------

message: 5
date: Mon, 9 Feb 2015 10:58:43 -0500
from: rob@xxxxxxxxx
subject: Re: should QSYS2 be in system portion of Library list?

QSYS2 should be in the system portion of the library list.

I am sure that somewhere WAY BACK there would have been a Memo To Users that would have warned you that this was going to be added to the system portion of the library list when you upgraded to release x.y.z and you should plan accordingly.

Yes, there will be a lot of objects that do not begin with Q. You can see many of them here:
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/db2/rbafzcatalog.htm?lang=en-us


Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.