|
midrange.com
As someone who has worked in both environments, I would have to say that
Oracle really isn't anywhere near as reliable as the AS/400. We actually
scrapped much of the Oracle stuff and ported many applications back to the
AS/400.
One could also take the amount you would spend on an Oracle DBA, (since the
'400 doesn't need someone babysitting it like Oracle does) upgrade to the
next larger '400 and get performance Oracle people can only dream about.
Terry Richardson
Vermont Information Processing, Inc.
terry@vtinfo.com
owner-midrange-l-digest@mi
drange.com (MIDRANGE-L To:
midrange-l-digest@midrange.com
Digest) cc:
Sent by: Subject: MIDRANGE-L
Digest V3 #767
owner-midrange-l-digest@mi
drange.com
10/10/00 03:45 PM
Please respond to
MIDRANGE-L
MIDRANGE-L Digest Tuesday, October 10 2000 Volume 03 : Number 767
This is the Midrange System Digest Mailing List!
To submit a new message, send your mail to MIDRANGE-L@midrange.com.
To subscribe to this list send email to MIDRANGE-L-DIGEST-SUB@midrange.com.
To unsubscribe from this list send email to
MIDRANGE-L-DIGEST-UNSUB@midrange.com.
Questions should be directed to the list owner/operator: david@midrange.com
*** DO NOT QUOTE THIS ENTIRE DIGEST WHEN REPLYING ***
Topics covered in this issue...
RE: SNA OVER TCP/IP
publication ordering
Re: Connect to Microsoft SQL Server
Re: publication ordering
Re: SNDTCPSPLF
SNA over IP
ODBC Driver
Network Slowness
RE: Connect to Microsoft SQL Server
RE: SNDTCPSPLF
Re: Network Slowness
FDDI
Wanna get REALLY pissed off ?
User Group Conf. Call tonight
RE: SNDTCPSPLF
RE: ODBC Driver
Re: Wanna get REALLY pissed off ?
----------------------------------------------------------------------
Date: Tue, 10 Oct 2000 10:54:35 -0500
From: pytel@us.ibm.com
Subject: RE: SNA OVER TCP/IP
> The AS400 with the restrictive ISP makes an SNA connection over a single
> port. Passthrough, DDM etc work fine. The link is kept open, and the
other
> AS400 can use the 'open' SNA connection to passthrough back.
There is no "link" for SNA over TCP/IP. Every session will establish it's
own connection to remote system.
Alexei Pytel
------------------------------
Date: Tue, 10 Oct 2000 12:25:22 -0400
From: "Jim Franz" <franz400@triad.rr.com>
Subject: publication ordering
This is a multi-part message in MIME format.
- ------=_NextPart_000_0055_01C032B5.293B5EC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Need to order a V4r5 Security Reference manual. My customer got one a =
month ago (for 4.4). On web, tried to order online-but no manual =
available, except "online view" or download. I need to carry this with =
me. Are we now cut off from purchasing the real thing?
jim
- ------=_NextPart_000_0055_01C032B5.293B5EC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3105.105" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2>Need to order a V4r5 Security Reference =
manual. My=20
customer got one a month ago (for 4.4). On web, tried to order =
online-but no=20
manual available, except "online view" or download. I need to carry this =
with=20
me. Are we now cut off from purchasing the real thing?</FONT></DIV>
<DIV><FONT face=3DArial =
size=3D2>jim</FONT></DIV></FONT></DIV></BODY></HTML>
- ------=_NextPart_000_0055_01C032B5.293B5EC0--
------------------------------
Date: Tue, 10 Oct 2000 12:51:46 -0400
From: Larry Bolhuis <lbolhuis@arbsol.com>
Subject: Re: Connect to Microsoft SQL Server
Art,
Take a look at www.datamirror.com at their Transformation Server
product. It'll do what you need for sure. I'm not sure the pricing will
be any cheaper but that depents on how big your AS/400 is.
HTH
- Larry
"Art Tostaine, Jr." wrote:
>
> I have a need to insert data into an imaging application that is running
> Microsoft SQL Server.
>
> I have searched the archives and deja.com and found messages that say I
need
> IBM's datajoiner. The cost is $14,999.
>
> Is there any other way? Both systems will be local to each other and on
a
> TCP/IP network.
------------------------------
Date: Tue, 10 Oct 2000 13:06:08 -0400 (EDT)
From: Don <dr2@cssas400.com>
Subject: Re: publication ordering
Jim,
why not download and print...use a highspeed laser and it's yours...
Don
On Tue, 10 Oct 2000, Jim Franz wrote:
> Need to order a V4r5 Security Reference manual. My customer got one a
month ago (for 4.4). On web, tried to order online-but no manual available,
except "online view" or download. I need to carry this with me. Are we now
cut off from purchasing the real thing?
> jim
>
------------------------------
Date: Tue, 10 Oct 2000 13:03:16 -0400
From: "Neil Palmer"<NeilP@DPSlink.com>
Subject: Re: SNDTCPSPLF
Could this be your problem ?
Item SA89035
APAR Identifier ...... SA89035 Last Changed..00/10/10
OSP-F/QLICHLIB-MSGCPF2182-T/QSPCRTSP CPF2182 F/QLICHLIB
T/QSPCRTSP WHEN SENDING SPOOLED FILE USING LPR
Symptom ...... MS MSGCPF2182 Status ........... CLOSED PER
Severity ................... 3 Date Closed ......... 00/05/11
Component .......... 5769SS1SP Duplicate of ........
Reported Release ......... 440 Fixed Release ............ 999
Component Name 5769 PRINT/SPOO Special Notice
Current Target Date ..00/05/18 Flags
SCP ...................
Platform ............
Status Detail: SHIPMENT - Packaged solution is available for
shipment.
PE PTF List:
PTF List:
Release 410 : PTF not available yet
Release 420 : PTF not available yet
Release 430 : SF62651 available 00/10/10 (0280 )
Release 440 : SF63673 available 00/09/12 (1000 )
Release 450 : SF62607 available 00/06/16 (0189 )
Parent APAR:
Child APAR list:
ERROR DESCRIPTION:
The sending of spooled files via SNA and TCP are behaving
differently. QSPCRTSP is attempting to change to the library
list of the user BEFORE swapping to the user when doing a
SNDTCPSPLF. The libraries are set to PUBLIC *EXCLUDE on the
customer's system and the user is part of a group profile that
has *USE authority to them. QTCP does not have *USE authority to
the libraries, therefore, CPF2182 'Not authorized to library
xxxxxx.' is issued in the LPD job logs.
LOCAL FIX:
Give QTCP *USE authority to the libraries referenced in CPF2182.
PROBLEM SUMMARY:
When creating spooled files on behalf of another user with the
use of the QSPCRTSP API, MSGCPF2182 could result if the
current user does not have *USE authority to all of the
libraries in the library list of the user that the file is
being spooled under.
PROBLEM CONCLUSION:
An OS/400 system program has been changed to swap to the
profile that the spooled file will be created under, before
changing to that user's library list.
Brad McDaniel <BMCDANIEL@ABSBC.ORG>
Sent by: owner-midrange-l@midrange.com
2000/10/10 11:01
Please respond to MIDRANGE-L
To: "'MIDRANGE-L@midrange.com'" <MIDRANGE-L@midrange.com>
cc:
Subject: SNDTCPSPLF
Hello Everyone -
I am trying to send some spooled files with the SNDTCPSPLF command. It is
in a CL that has worked for a while now, but all of a sudden I m getting
this message...
Statement . . . . . . . . . : 8900
Message . . . . : 8900 - SNDTCPSPLF RMTSYS(ACS) PRTQ('linep')
FILE(APR222PR) JOB('795756'/OMNI/COLDPART) SPLNBR(5) TRANSFORM(*YES)
DLTSPLF(*NO)
40 10/09/00 12:41:48 QDCXLATE QSYS 05AF QWPZPDS
QSYS *STMT
To module . . . . . . . . . : QWPZSCP
To procedure . . . . . . . : get_xlate_table
Statement . . . . . . . . . : 25
Message . . . . : Table QMY7BF437 not found.
Cause . . . . . : The table QMY7BF437 does not exist. Recovery . . .
:
Change the table name or library name in the calling program.
Anyone seen this before? Suggestions?
Much appreciated.
Brad McDaniel
Programmer Analyst
Annuity Board of the SBC
(214) 720-6546
------------------------------
Date: Tue, 10 Oct 2000 13:09:34 -0400
From: "Steve Bireley" <sbireley@renex.com>
Subject: SNA over IP
Larry Bolhuis wrote:
>Actually the Anynet trick should work. Anynet uses port 397 UDP and TCP
>so if that's open you should be good to go.
If UDP is required for an Anynet connection, you may still run into
problems
with some ISPs. We found that some ISPs filter UDP packets, preventing any
protocol that uses UDP from working at all.
Steve Bireley
Renex Corporation
www.renex.com
Secure Web to Host Solutions
------------------------------
Date: Tue, 10 Oct 2000 10:08:55 -0700
From: Jim Langston <jimlangston@conexfreight.com>
Subject: ODBC Driver
V3R7M0
I want to set up ODBC between my PC and our AS/400. Our AS/400 is running
TCP/IP with no problems.
When I got to set up the ODBC link I don't see one for the AS/400.
Remembering back I think that
the ODBC driver comes with Client Access, which I don't want to install (I
don't even think I have
V3R7M0 client access here, just V3R1M0).
So, where can I get an ODBC driver for my PC to connect to my AS/400? Free
would be preferable.
Regards,
Jim Langston
------------------------------
Date: Tue, 10 Oct 2000 10:55:37 -0700
From: "Hatzenbeler, Tim" <thatzenbeler@clinitech.net>
Subject: Network Slowness
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
- ------_=_NextPart_001_01C032E3.4BDACA6E
Content-Type: text/plain
I was wondering if someone could list a few places to check on our as/400
to
make sure were getting our full bandwidth.
Right now, if I move files back and forth between our 2 as/400's , which
are
sitting 3 feet apart... The transfer is soooo slow... And it's an
Ethernet
connection... So I was wondering maybe we have a wrong setting or
something... Anybody have any ideas where to look?
thanks, tim
- ------_=_NextPart_001_01C032E3.4BDACA6E
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>Network Slowness</TITLE>
</HEAD>
<BODY>
<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">I was wondering if =
someone could list a few places to check on our as/400 to make sure =
were getting our full bandwidth.</FONT>
</P>
<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Right now, if I move =
files back and forth between our 2 as/400's , which are sitting 3 feet =
apart... The transfer is soooo slow... And it's an Ethernet =
connection... So I was wondering maybe we have a wrong setting or =
something... Anybody have any ideas where to look?</FONT></P>
<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">thanks, =
tim</FONT>
</P>
<BR>
</BODY>
</HTML>
- ------_=_NextPart_001_01C032E3.4BDACA6E--
------------------------------
Date: Tue, 10 Oct 2000 10:54:28 -0700
From: "MCPARTLAND, Stan" <stanley.mcpartland@bently.com>
Subject: RE: Connect to Microsoft SQL Server
Art,
Chris Bipes posted the following information on midrange-l in response to a
similar question about MS Access. I saved the post since I had a potential
requirement to do the same thing. I didn't end up using this technique
since my requirement did not materialize. From the research I did at the
time, you would need to research and configure Distributed Relational
Database Architecture (DRDA) on both servers. The impact to security would
need to be considered since you would be opening up the databases to TCP/IP
access. Documentation on both the IBM and Microsoft sides is light. IBM's
documentation deals with connecting to other IBM databases with just a few
references to non-IBM databases. I didn't find much on the subject from
Microsoft. I expect it would take some trial and error to setup the
connection between the databases. If you use this technique, I would be
interested in hearing the details.
Regards,
Stan McPartland
From Chris' post:
"Using the interactive SQL product you can connect to any defined SQL data
base including Access. The machine you are connecting to must be running
DRDA via TCP/IP. The command to add a relation data base is:
QSYS/ADDRDBDIRE RDB(xxxxxx) RMTLOCNAME('xxx.xxx.xxx.xxx' *IP) PORT(*DRDA)
Then in the SQL use the CONNECT and prompt it."
- -----Original Message-----
From: Art Tostaine, Jr. [mailto:art@link400.com]
Sent: Tuesday, October 10, 2000 8:09 AM
To: midrange-l@midrange.com
Subject: Connect to Microsoft SQL Server
I have a need to insert data into an imaging application that is running
Microsoft SQL Server.
I have searched the archives and deja.com and found messages that say I
need
IBM's datajoiner. The cost is $14,999.
Is there any other way? Both systems will be local to each other and on a
TCP/IP network.
Art Tostaine, Jr.
CCA, Inc.
Jackson, NJ 08527
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
------------------------------
Date: Tue, 10 Oct 2000 14:04:38 -0400
From: Buck Calabro <buck.calabro@aptissoftware.com>
Subject: RE: SNDTCPSPLF
Brad McDaniel wrote:
>I am trying to send some spooled files
>with the SNDTCPSPLF command. It is
>in a CL that has worked for a while now,
>but all of a sudden I m getting this message...
> 40 10/09/00 12:41:48
>QDCXLATE QSYS 05AF QWPZPDS
> To module . . . . . . . . . : QWPZSCP
> To procedure . . . . . . . : get_xlate_table
> Statement . . . . . . . . . : 25
> Message . . . . : Table QMY7BF437 not found.
> Cause . . . . . : The table QMY7BF437 does not exist. Recovery . .
.
My dim memories of this type of message relate to CCSIDs. I believe that
LPR is trying to translate from your CCSID to the CCSID of the far end.
The
table it uses is composed of the code pages ("from" 7BF "to" 437). Having
said that, 7BF seems impossible as a code page. Check for PTFs relating to
code page, CCSID, QWPZPDS and QDCXLATE as well as the message ID of the
error. See if anybody put a PTF on your machine since the last time it
worked.
Buck Calabro
Aptis; Albany, NY
"We are what we repeatedly do.
Excellence, then, is not an act, but a habit." --Aristotle
Billing Concepts Corp., a NASDAQ Listed Company, Symbol: BILL
------------------------------
Date: Tue, 10 Oct 2000 20:34:17 +0200
From: Stefan.Tageson@notes.sema.se
Subject: Re: Network Slowness
Assuming TCP/IP:
1. Check routing info
2. Check MTU size, it should be 1496.
3. CHGTCPA and set a buffersize greater than 8k might improve transfer
speed.
4. If You are at V4R4 or higher and have the possibility to specify TCP/IP
only at the line description, do so.
Best Regards
// Stefan
+>----------------------------------------------------------------------<+
Phone: +46 40 693 3500
Fax: +46 40 693 3600
Mobile: +46 708 51 3543
e-mail: stefan.tageson@notes.sema.se
+>---------------------------------------------------------------------<+
>Right now, if I move files back and forth between our 2 as/400's , which
are sitting 3 feet apart... The transfer is soooo slow... And it's an
Ethernet connection... >So I was wondering maybe we have a wrong setting
or something... Anybody have any ideas where to look?
thanks, tim
------------------------------
Date: Tue, 10 Oct 2000 14:44:36 -0400
From: Debbie Helms <DHelms@Lance.com>
Subject: FDDI
Could anyone enlighten me on theses errors? Where do I go to further
investigate this?
Line LANCEDDI recovered from wrapped configuration at adapter
D45B6E5600.
Line LANCEDDI recovered from wrapped configuration at adapter
D4AC4750E5.
Line LANCEDDI has recovered from a wrapped configuration
Line LANCEDDI in wrapped configuration at adapter D45B6E5600.
Line LANCEDDI in wrapped configuration at adapter D4AC4750E5.
Line LANCEDDI has entered a wrapped configuration
Line LANCEDDI recovered from wrapped configuration at adapter
D45B6E5600.
Line LANCEDDI recovered from wrapped configuration at adapter
D4AC4750E5.
Line LANCEDDI has recovered from a wrapped configuration
------------------------------
Date: Tue, 10 Oct 2000 13:45:26 -0500
From: Chuck Lewis <clewis@iquest.net>
Subject: Wanna get REALLY pissed off ?
- --------------A1B83BEDD15483DC75658307
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Click on this:
http://www.silicon.com/public/door?REQUNIQ=971106147&6004REQEVENT
=&REQINT1=40133&REQSTR1=newsnow
And read on. The REAL pisser part is the "Both Caray and Menzies
highlighted problems users have migrating from the AS/400 platform"
It FIGURES it is on an Oracle slanted site but we have GOT to figure out
how to get in on this "Behind the Scenes" deal if at all possible and
dispell this GARBAGE !
Chuck
- --------------A1B83BEDD15483DC75658307
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Click on this:
<p> <a href="
http://www.silicon.com/public/door?REQUNIQ=971106147&6004REQEVENT
=&REQINT1=40133&REQSTR1=newsnow
">http://www.silicon.com/public/door?REQUNIQ=971106147&6004REQEVENT
=&REQINT1=40133&REQSTR1=newsnow</a>
<p>And read on. The REAL pisser part is the "Both Caray and Menzies
highlighted
problems users have migrating from the AS/400 platform"
<p>It FIGURES it is on an Oracle slanted site but we have GOT to figure
out how to get in on this "Behind the Scenes" deal if at all possible and
dispell this GARBAGE !
<p>Chuck</html>
- --------------A1B83BEDD15483DC75658307--
------------------------------
Date: Tue, 10 Oct 2000 13:44:08 -0500
From: "Anne Lucas/Birmingham/IBM" <alucas@us.ibm.com>
Subject: User Group Conf. Call tonight
You should have received a handout today sent by Melanie .... since I
'messed up the one last night' (technology challenged!).
If you did not get a handout, please email me ASAP. Thank you!
Be sure you have called 800-289-0579 confirmation # 578833 to register!
Thanks!
************
Have a great day!
Anne C. Lucas,
Project Executive - Operations
Worldwide Server Sales
"Passion is the magic that makes impossible-to-meet goals possible."
205/823-4831 T/L 537-9968
800/223-3907 Pager
alucas@us.ibm.com
- ---------------------- Forwarded by Anne Lucas/Birmingham/IBM on
10/10/2000
01:42 PM ---------------------------
Kris Ball <skmug1@pld.com>@midrange.com on 10/10/2000 12:40:31 PM
Please respond to INTERLUG@midrange.com
Sent by: owner-interlug@midrange.com
To: INTERLUG@midrange.com
cc:
Subject: User Group Conf. Call tonight
Anne's original post said we would be receiving a .pdf file (for Drew
Flaada's anouncement presentation tonight) last Wed. or Thurs. I
registered, but I didn't get a .pdf file. I called the registration
number and they said there weren't any handouts they were aware of. Did
anybody else get them?
Don, do you know how we can get handouts to follow along tonight?
Kris Ball
Vice Pres.
SKMUG (Southwest Kansas Midrange Users Group)
+---
| This is the Midrange User Group Leadership Mailing List!
| To submit a new message, send your mail to INTERLUG@midrange.com.
| Questions should be directed to the list owner: Don Rima
<dr2@cssas400.com>
+---
------------------------------
Date: Tue, 10 Oct 2000 13:52:59 -0500
From: Brad McDaniel <BMCDANIEL@ABSBC.ORG>
Subject: RE: SNDTCPSPLF
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
- ------_=_NextPart_001_01C032EB.4F108540
Content-Type: text/plain;
charset="iso-8859-1"
Hmm. Might be. I'll look into it. Thanks.
Any other suggestions are still welcome.
Brad
- -----Original Message-----
From: Neil Palmer [mailto:NeilP@DPSlink.com]
Sent: Tuesday, October 10, 2000 12:03 PM
To: MIDRANGE-L@midrange.com
Subject: Re: SNDTCPSPLF
Could this be your problem ?
Item SA89035
APAR Identifier ...... SA89035 Last Changed..00/10/10
OSP-F/QLICHLIB-MSGCPF2182-T/QSPCRTSP CPF2182 F/QLICHLIB
T/QSPCRTSP WHEN SENDING SPOOLED FILE USING LPR
Symptom ...... MS MSGCPF2182 Status ........... CLOSED PER
Severity ................... 3 Date Closed ......... 00/05/11
Component .......... 5769SS1SP Duplicate of ........
Reported Release ......... 440 Fixed Release ............ 999
Component Name 5769 PRINT/SPOO Special Notice
Current Target Date ..00/05/18 Flags
SCP ...................
Platform ............
Status Detail: SHIPMENT - Packaged solution is available for
shipment.
PE PTF List:
PTF List:
Release 410 : PTF not available yet
Release 420 : PTF not available yet
Release 430 : SF62651 available 00/10/10 (0280 )
Release 440 : SF63673 available 00/09/12 (1000 )
Release 450 : SF62607 available 00/06/16 (0189 )
Parent APAR:
Child APAR list:
ERROR DESCRIPTION:
The sending of spooled files via SNA and TCP are behaving
differently. QSPCRTSP is attempting to change to the library
list of the user BEFORE swapping to the user when doing a
SNDTCPSPLF. The libraries are set to PUBLIC *EXCLUDE on the
customer's system and the user is part of a group profile that
has *USE authority to them. QTCP does not have *USE authority to
the libraries, therefore, CPF2182 'Not authorized to library
xxxxxx.' is issued in the LPD job logs.
LOCAL FIX:
Give QTCP *USE authority to the libraries referenced in CPF2182.
PROBLEM SUMMARY:
When creating spooled files on behalf of another user with the
use of the QSPCRTSP API, MSGCPF2182 could result if the
current user does not have *USE authority to all of the
libraries in the library list of the user that the file is
being spooled under.
PROBLEM CONCLUSION:
An OS/400 system program has been changed to swap to the
profile that the spooled file will be created under, before
changing to that user's library list.
Brad McDaniel <BMCDANIEL@ABSBC.ORG>
Sent by: owner-midrange-l@midrange.com
2000/10/10 11:01
Please respond to MIDRANGE-L
To: "'MIDRANGE-L@midrange.com'" <MIDRANGE-L@midrange.com>
cc:
Subject: SNDTCPSPLF
Hello Everyone -
I am trying to send some spooled files with the SNDTCPSPLF command. It is
in a CL that has worked for a while now, but all of a sudden I m getting
this message...
Statement . . . . . . . . . : 8900
Message . . . . : 8900 - SNDTCPSPLF RMTSYS(ACS) PRTQ('linep')
FILE(APR222PR) JOB('795756'/OMNI/COLDPART) SPLNBR(5) TRANSFORM(*YES)
DLTSPLF(*NO)
40 10/09/00 12:41:48 QDCXLATE QSYS 05AF QWPZPDS
QSYS *STMT
To module . . . . . . . . . : QWPZSCP
To procedure . . . . . . . : get_xlate_table
Statement . . . . . . . . . : 25
Message . . . . : Table QMY7BF437 not found.
Cause . . . . . : The table QMY7BF437 does not exist. Recovery . . .
:
Change the table name or library name in the calling program.
Anyone seen this before? Suggestions?
Much appreciated.
Brad McDaniel
Programmer Analyst
Annuity Board of the SBC
(214) 720-6546
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
- ------_=_NextPart_001_01C032EB.4F108540
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.29">
<TITLE>RE: SNDTCPSPLF</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Hmm. Might be. I'll look into it. =
Thanks.</FONT>
</P>
<P><FONT SIZE=3D2>Any other suggestions are still welcome.</FONT>
</P>
<P><FONT SIZE=3D2>Brad</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Neil Palmer [<A =
HREF=3D"mailto:NeilP@DPSlink.com">mailto:NeilP@DPSlink.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, October 10, 2000 12:03 PM</FONT>
<BR><FONT SIZE=3D2>To: MIDRANGE-L@midrange.com</FONT>
<BR><FONT SIZE=3D2>Subject: Re: SNDTCPSPLF</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Could this be your problem ?</FONT>
</P>
<P><FONT SIZE=3D2>Item SA89035 </FONT>
</P>
<P><FONT SIZE=3D2> APAR Identifier ...... =
SA89035 Last Changed..00/10/10 =
</FONT>
<BR><FONT SIZE=3D2> OSP-F/QLICHLIB-MSGCPF2182-T/QSPCRTSP CPF2182 =
F/QLICHLIB</FONT>
<BR><FONT SIZE=3D2> T/QSPCRTSP WHEN SENDING SPOOLED FILE USING =
LPR</FONT>
<BR><FONT SIZE=3D2> </FONT>
<BR><FONT SIZE=3D2> Symptom ...... MS =
MSGCPF2182 Status ........... =
CLOSED PER</FONT>
<BR><FONT SIZE=3D2> Severity ................... =
3 Date Closed ......... 00/05/11</FONT>
<BR><FONT SIZE=3D2> Component .......... =
5769SS1SP Duplicate of ........</FONT>
<BR><FONT SIZE=3D2> Reported Release ......... =
440 Fixed Release ............ 999</FONT>
<BR><FONT SIZE=3D2> Component Name 5769 =
PRINT/SPOO Special Notice</FONT>
<BR><FONT SIZE=3D2> Current Target Date =
..00/05/18 Flags</FONT>
<BR><FONT SIZE=3D2> SCP ...................</FONT>
<BR><FONT SIZE=3D2> Platform ............</FONT>
<BR><FONT SIZE=3D2> </FONT>
<BR><FONT SIZE=3D2> Status Detail: SHIPMENT - Packaged solution =
is available for</FONT>
<BR><FONT =
SIZE=3D2> &nb=
sp; &nb=
sp; shipment.</FONT>
<BR><FONT SIZE=3D2> </FONT>
<BR><FONT SIZE=3D2> PE PTF List:</FONT>
<BR><FONT SIZE=3D2> </FONT>
<BR><FONT SIZE=3D2> PTF List:</FONT>
<BR><FONT SIZE=3D2> Release 410 : PTF not available =
yet</FONT>
<BR><FONT SIZE=3D2> Release 420 : PTF not available =
yet</FONT>
<BR><FONT SIZE=3D2> Release 430 : SF62651 available =
00/10/10 (0280 )</FONT>
<BR><FONT SIZE=3D2> Release 440 : SF63673 available =
00/09/12 (1000 )</FONT>
<BR><FONT SIZE=3D2> Release 450 : SF62607 available =
00/06/16 (0189 )</FONT>
<BR><FONT SIZE=3D2> </FONT>
<BR><FONT SIZE=3D2> Parent APAR:</FONT>
<BR><FONT SIZE=3D2> Child APAR list:</FONT>
<BR><FONT SIZE=3D2> </FONT>
<BR><FONT SIZE=3D2> </FONT>
<BR><FONT SIZE=3D2> ERROR DESCRIPTION:</FONT>
<BR><FONT SIZE=3D2> The sending of spooled files via SNA and TCP =
are behaving</FONT>
<BR><FONT SIZE=3D2> differently. QSPCRTSP is attempting to =
change to the library</FONT>
<BR><FONT SIZE=3D2> list of the user BEFORE swapping to the user =
when doing a</FONT>
<BR><FONT SIZE=3D2> SNDTCPSPLF. The libraries are set to =
PUBLIC *EXCLUDE on the</FONT>
<BR><FONT SIZE=3D2> customer's system and the user is part of a =
group profile that</FONT>
<BR><FONT SIZE=3D2> has *USE authority to them. QTCP does not =
have *USE authority to</FONT>
<BR><FONT SIZE=3D2> the libraries, therefore, CPF2182 'Not =
authorized to library</FONT>
<BR><FONT SIZE=3D2> xxxxxx.' is issued in the LPD job =
logs.</FONT>
<BR><FONT SIZE=3D2> </FONT>
<BR><FONT SIZE=3D2> LOCAL FIX:</FONT>
<BR><FONT SIZE=3D2> Give QTCP *USE authority to the libraries =
referenced in CPF2182.</FONT>
<BR><FONT SIZE=3D2> </FONT>
<BR><FONT SIZE=3D2> PROBLEM SUMMARY:</FONT>
<BR><FONT SIZE=3D2> When creating spooled files on behalf of =
another user with the</FONT>
<BR><FONT SIZE=3D2> use of the QSPCRTSP API, MSGCPF2182 could =
result if the</FONT>
<BR><FONT SIZE=3D2> current user does not have *USE authority to =
all of the</FONT>
<BR><FONT SIZE=3D2> libraries in the library list of the user =
that the file is</FONT>
<BR><FONT SIZE=3D2> being spooled under.</FONT>
</P>
<P><FONT SIZE=3D2> PROBLEM CONCLUSION:</FONT>
<BR><FONT SIZE=3D2> An OS/400 system program has been changed to =
swap to the</FONT>
<BR><FONT SIZE=3D2> profile that the spooled file will be created =
under, before</FONT>
<BR><FONT SIZE=3D2> changing to that user's library list.</FONT>
</P>
<BR>
<BR>
<BR>
<BR>
<BR>
<P><FONT SIZE=3D2>Brad McDaniel <BMCDANIEL@ABSBC.ORG></FONT>
<BR><FONT SIZE=3D2>Sent by: owner-midrange-l@midrange.com</FONT>
<BR><FONT SIZE=3D2>2000/10/10 11:01</FONT>
<BR><FONT SIZE=3D2>Please respond to MIDRANGE-L</FONT>
</P>
<P><FONT SIZE=3D2> </FONT>
<BR><FONT SIZE=3D2> =
To: "'MIDRANGE-L@midrange.com'" =
<MIDRANGE-L@midrange.com></FONT>
<BR><FONT SIZE=3D2> cc: =
</FONT>
<BR><FONT SIZE=3D2> =
Subject: SNDTCPSPLF</FONT>
</P>
<P><FONT SIZE=3D2>Hello Everyone - </FONT>
<BR><FONT SIZE=3D2>I am trying to send some spooled files with the =
SNDTCPSPLF command. It is </FONT>
<BR><FONT SIZE=3D2>in a CL that has worked for a while now, but all of =
a sudden I m getting </FONT>
<BR><FONT SIZE=3D2>this message...</FONT>
<BR><FONT SIZE=3D2> Statement . . . . . . . . . : =
8900 </FONT>
<BR><FONT SIZE=3D2> Message . . . . : =
8900 - SNDTCPSPLF RMTSYS(ACS) PRTQ('linep') </FONT>
<BR><FONT SIZE=3D2> FILE(APR222PR) =
JOB('795756'/OMNI/COLDPART) SPLNBR(5) TRANSFORM(*YES) =
</FONT>
</P>
<P><FONT SIZE=3D2> DLTSPLF(*NO) </FONT>
<BR><FONT SIZE=3D2>40 10/09/00 =
12:41:48 QDCXLATE =
QSYS =
05AF QWPZPDS </FONT>
<BR><FONT SIZE=3D2>QSYS =
*STMT </FONT>
<BR><FONT SIZE=3D2> To module . . . . . . . . . : =
QWPZSCP </FONT>
<BR><FONT SIZE=3D2> To procedure . . . . . . . =
: get_xlate_table </FONT>
<BR><FONT SIZE=3D2> Statement . . . . . . . . . : =
25 </FONT>
<BR><FONT SIZE=3D2> Message . . . . : Table QMY7BF437 =
not found. </FONT>
<BR><FONT SIZE=3D2> Cause . . . . . : The table =
QMY7BF437 does not exist. Recovery . . . </FONT>
<BR><FONT SIZE=3D2>: </FONT>
<BR><FONT SIZE=3D2> Change the table name or library =
name in the calling program. </FONT>
</P>
<P><FONT SIZE=3D2>Anyone seen this before? Suggestions? </FONT>
<BR><FONT SIZE=3D2>Much appreciated. </FONT>
<BR><FONT SIZE=3D2>Brad McDaniel </FONT>
<BR><FONT SIZE=3D2>Programmer Analyst </FONT>
<BR><FONT SIZE=3D2>Annuity Board of the SBC </FONT>
<BR><FONT SIZE=3D2>(214) 720-6546 </FONT>
</P>
<BR>
<P><FONT SIZE=3D2>+---</FONT>
<BR><FONT SIZE=3D2>| This is the Midrange System Mailing List!</FONT>
<BR><FONT SIZE=3D2>| To submit a new message, send your mail to =
MIDRANGE-L@midrange.com.</FONT>
<BR><FONT SIZE=3D2>| To subscribe to this list send email to =
MIDRANGE-L-SUB@midrange.com.</FONT>
<BR><FONT SIZE=3D2>| To unsubscribe from this list send email to =
MIDRANGE-L-UNSUB@midrange.com.</FONT>
<BR><FONT SIZE=3D2>| Questions should be directed to the list =
owner/operator: david@midrange.com</FONT>
<BR><FONT SIZE=3D2>+---</FONT>
</P>
</BODY>
</HTML>
- ------_=_NextPart_001_01C032EB.4F108540--
------------------------------
Date: Tue, 10 Oct 2000 13:08:17 -0600
From: Scott Mildenberger <Smildenber@Washcorp.com>
Subject: RE: ODBC Driver
The Client Access ODBC driver is a part of Client Access that is provided
free to use. There are other providers of ODBC drivers for the 400 but I
don't know if any are free.
Scott Mildenberger
> -----Original Message-----
> From: Jim Langston [SMTP:jimlangston@conexfreight.com]
> Sent: Tuesday, October 10, 2000 11:09 AM
> To: midrange-l@midrange.com
> Subject: ODBC Driver
>
> V3R7M0
>
> I want to set up ODBC between my PC and our AS/400. Our AS/400 is
running
> TCP/IP with no problems.
>
> When I got to set up the ODBC link I don't see one for the AS/400.
> Remembering back I think that
> the ODBC driver comes with Client Access, which I don't want to install
(I
> don't even think I have
> V3R7M0 client access here, just V3R1M0).
>
> So, where can I get an ODBC driver for my PC to connect to my AS/400?
> Free would be preferable.
>
> Regards,
>
> Jim Langston
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
------------------------------
Date: Tue, 10 Oct 2000 12:40:45 -0700
From: Ted Barry <TBARRY@smtpgate.centralsan.dst.ca.us>
Subject: Re: Wanna get REALLY pissed off ?
Chuck,
These guys obviously don't know what they're talking about. Agreed,
we need to let them know and they should be forced to print a retraction.
Thanks,
Ted
>>> Chuck Lewis <clewis@iquest.net> 10/10/00 11:45am >>>
Click on this:
http://www.silicon.com/public/door?REQUNIQ=971106147&6004REQEVENT
=&REQINT1=40133&REQSTR1=newsnow
And read on. The REAL pisser part is the "Both Caray and Menzies
highlighted problems users have migrating from the AS/400 platform"
It FIGURES it is on an Oracle slanted site but we have GOT to figure out
how to get in on this "Behind the Scenes" deal if at all possible and
dispell this GARBAGE !
Chuck
------------------------------
End of MIDRANGE-L Digest V3 #767
********************************
+---
| This is the Midrange System Digest Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to
MIDRANGE-L-DIGEST-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-DIGEST-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---
As an Amazon Associate we earn from qualifying purchases.
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.
