Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Redirect Spool output

Posted on 2004-04-21
16
1,062 Views
Last Modified: 2008-02-07
Hi everyone...I have a scheduled job thats run strmntbrm. The spool files automatically go to an outq named ITPRT1. For the life of me I cannot figure out how the output is being redirected there. I have checked the user profile and job definition to change, but neither of the 2 say they are going to that outq. I even created a new jobd for that job and specified the new outq and still it went to ITPRT1.  Any ideas are greatly appreciated!!
0
Comment
Question by:DavidASolis
  • 6
  • 5
  • 4
  • +1
16 Comments
 
LVL 6

Expert Comment

by:dedy_djajapermana
ID: 10884270
hi there,

The OUTQ of the report you produce is actually determined by the OUTQ value in the user profile.
There are 3 options for the parameter:
OUTQ name: all reports produced by the user will go to this OUTQ
*WRKSTN: the reports produced will go to the OUTQ defined in the device the user's using
*DEV: the reports produced will go to the OUTQ as defined in the PRINTER FILE (or OVRPRTF)
0
 
LVL 27

Expert Comment

by:tliotta
ID: 10884606
DavidASolis:

In general, the system looks in this order: printer file, job description, user profile, workstation description,
and system values.

Of course, if the program in control issues an override (OVRPRTF command or calls various APIs to change the environment or issues CHGJOB or a number of other possibilities), all of those areas can be ignored.

If there's nothing obvious in those elements above, you'll have to review the program code.

Tom
0
 
LVL 1

Expert Comment

by:Helixir
ID: 10890347
For Scheduled Job I usually create a User which has ZPGMR or another outq name that do not redirect to a printer !!

and in the Scheduled I specify in the USER() field my user name.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:DavidASolis
ID: 10923574
Ok guys Ive created a user with outq(email) printer(email). Also I added a jobd that specifies outq(email) and printer(email).

The spoolfiles for this still go to the ITPRT1 outq!!

FYI....this is a scheduled job that was put in place before I arrived. It runs the STRMNTBRM reports for BRMS. It is in the job scheduler.

I saw in the order that tliotta specified...the printerfile is checked first...how do I find out what printerfile is being used for this??

Thanks!!

PS raised points since this is getting on my nerves!!
0
 
LVL 27

Expert Comment

by:tliotta
ID: 10923913
David:

Assuming outq(ITPRT1), then:

 ==>  wrkoutq  ITPRT1

This lists the files spooled to that outq. Next to the spooled file you're interested in, type option 8=Attributes. Page down to the second page and look for [Device file]. The device file is what you're after.

If your assistance level for WRKOUTQ is 'basic', you won't have option 8 available. If so, you can press F21=Select assistance level, and change your level to 'intermediate'. Option 8 should then appear.

Tom
0
 
LVL 6

Expert Comment

by:dedy_djajapermana
ID: 10924564
hi David,

On the particular job schedule entry (I presume it's standard job scheduler from WRKJOBSCDE), what is the parameter value for USER and JOBD parameter? you should change it there.
0
 

Author Comment

by:DavidASolis
ID: 10926964
I checked the print and it specifies *JOB for the printer and outq parameters....I have that set to outq(EMAIL). The parameter for both user and jobd for the scheduled job are EMAIL, which i created a user and a jobd specifying outq(email)

Any idea what could be overriding these???
0
 

Author Comment

by:DavidASolis
ID: 10926990
F?YI, while the job is running the run attributes state "Printer Device: EMAIL" and "Default Output Queue: EMAIL", yet they are still being routed to ITPRT1 for some reason
0
 
LVL 6

Expert Comment

by:dedy_djajapermana
ID: 10927081
please check the printer file (same name as the spooled file name).
e.g., for QP1AVER report, the printer file should be QP1AVER in library QBRM.
CHGPRTF QBRM/QP1AVER then press F4, then see the value of PRINTER (press F12 after finish).

In my system the value is *JOB, it may different in yours.
                          Change Printer File (CHGPRTF)

 Type choices, press Enter.

 File . . . . . . . . . . . . . . > QP1AVER       Name, generic*, *ALL
   Library  . . . . . . . . . . . >   QBRM        Name, *LIBL, *ALL, *ALLUSR...
 Device:
   Printer  . . . . . . . . . . .   *JOB          Name, *SAME, *JOB, *SYSVAL
0
 

Author Comment

by:DavidASolis
ID: 10928962
The printer files say *JOB in those fields...I meant to say that in the previous post but didnt realize I didnt put the word "file" there...
0
 
LVL 27

Expert Comment

by:tliotta
ID: 10933506
Note that spooled file name and printer file name are not necessarily the same. (Very likely they're the same, but that's only by default.) Example is a program compile listing -- spooled file name will be the name of the program but printer file name will probably be QSYSPRT. For DDS compiles, printer file name is probably QPDDSSRC; etc.

While the likelihood might be small, you should always start by verifying that spooled file and printer file names are the same. If they are not, it almost guarantees that an override was in effect. Unfortunately, that fact that they're the same does not guarantee that an override was _not_ in effect.

Always verify first.

In any case, if all attributes seem correct while the job runs but the result does not match those attributes, then you're back to an override, or perhaps something like CHGSPLFA after the spooled file is created. You'll have to look at the source code to see if OVRPRTF is run near the beginning or CHGSPLFA is run towards the end.

Ideally, you'll have system auditing enabled with QAUDLVL set to include *SPLFDTA and *PRTDTA. That way, we could track PO and SF entries to see exactly what happened to the spooled files. The entries would tell you where to look.

Tom
0
 
LVL 6

Expert Comment

by:dedy_djajapermana
ID: 10934722
hi Tom,

Thanks. I'm referring to BRMS reports. Each report has its own PRTF in BRMS.
0
 
LVL 27

Accepted Solution

by:
tliotta earned 100 total points
ID: 10943246
Dedy:

True, but if the job includes an OVRPRTF before the STRMNTBRM, anything that can be overridden is in question, including printer file name.

...Unless the actual scheduled command is STRMNTBRM rather than a call to a program that runs STRMNTBRM. If STRMNTBRM itself is scheduled, then I'd be looking at BRMS configurations to see if there are options to specify outqs for different users, different reports, etc.

I don't have a BRMS setup at the moment unfortunately, so I can't look deeper.

All of this is purely to guarantee that spooled file and printer file names match. As I said, most likely they do, but why not look?

Tom
0
 

Author Comment

by:DavidASolis
ID: 10955048
All the spool and printer file names match....I'll look closely at the BRMS setup and report back...thanks
0
 
LVL 6

Expert Comment

by:dedy_djajapermana
ID: 10955494
i mean what's the value of DEV in the printer file (checking one is enough), it should be *JOB
then do a CHGPRF JOBD(*LIBL/EMAIL) OUTQ(*LIBL/EMAIL)
then do an interactive STRMNTBRM
what's the result?
0
 

Author Comment

by:DavidASolis
ID: 11052686
Answer ended up being the system policy in BRMS..   Thanks a million guys!!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
php iseries 3 229
Close Open files in Library 7 258
Create AS400 Logical File 5 89
AS400 procedure issuing command ldap_search_st receives RETURN CODE 81 (0x51) for some user 2 97
Is your phone running out of space to hold pictures?  This article will show you quick tips on how to solve this problem.
Learn how to PXE Boot both BIOS & UEFI machines with DHCP Policies and Custom Vendor Classes
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question