Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Redirect Spool output

Posted on 2004-04-21
16
Medium Priority
?
1,152 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
[X]
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
  • 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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

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 400 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

WooCommerce is becoming the most powerful e-commerce plugin for Wordpress. And why not. The platform comprises of numerous core plugins that may come in handy, powerful options to make your website development task much easier.
If something goes wrong with Exchange, your IT resources are in trouble.All Exchange server migration processes are not designed to be identical and though migrating email from on-premises Exchange mailbox to Cloud’s Office 365 is relatively simple…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

597 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