An output queue can be created in a library on an ASP or iASP. However, when using the WRKSPLF command you may not see the spool files that exist on the ASP/iASP unless you first set the iASP group using the command SETASPGRP (ASP/iASP Name).
Note to programmers: If you do programming with some iSeries APIs that retrieve information about spool files, it is not always necessary to specify the ASP/iASP name (unless, of course, you wish to). For example the API QUSLSPL will retrieve a list of spool files on *SYSBAS and on all available ASPs/iASPs without the need to use SETASPGRP; similarly QUSRSPLA will also retrieve spool file attributes without the need to use SETASPGRP.
Disclaimer:Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility in your own environment. Please review and test thoroughly before implementing. © Copyright 2009, Vision Solutions, Inc. All rights reserved. Vision Solutions develops and sells iSeries high availability and AIX replication and clustering solutions. IBM, System i, iSeries, and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.
5/29/09 Working with Spool files on System ASPs or iASPs
5/19/09 How to see scheduled jobs in order of submission
When doing various system maintenance and management functions it is sometimes necessary to hold jobs on the Job Scheduler. Instead of using the command WRKJOBSCDE, which presents jobs alphabetically by name, use the command WRKJOBSCDE SEQ(*DATETIME). This will present the list of jobs in the order they are to be submitted, allowing you to quickly find those scheduled jobs that will occur during the timeframe of your system maintenance and management tasks.
Disclaimer:Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility in your own environment. Please review and test thoroughly before implementing. © Copyright 2009, Vision Solutions, Inc. All rights reserved. Vision Solutions develops and sells iSeries high availability and AIX replication and clustering solutions. IBM, System i, iSeries, and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.
5/8/09 How to execute a command on a remote system using FTP
Simply type the command as you normally would, but have it preceded by "QUOTE RCMD"
For example:
QUOTE RCMD CHKOBJ OBJ(QGPL) OBJTYPE(*LIB)
QUOTE RCMD CALL PGM(Yourpgm/Yourlib) PARM(Parms)
Disclaimer:Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility in your own environment. Please review and test thoroughly before implementing. © Copyright 2009, Vision Solutions, Inc. All rights reserved. Vision Solutions develops and sells iSeries high availability and AIX replication and clustering solutions. IBM, System i, iSeries, and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.
4/27/09 - How to delete a specifc relative record if the file is keyed
You can delete a specific relative record number when a file is keyed and the UPDDTA command can’t do it. Simply use normal OS/400 SQL and run the following:
delete from LIBRARY/FILENAME A where RRN(A) = 3
The above example deletes RRN number 3. Just replace LIBRARY and FILENAME with library and file names the ‘A’ after file name is needed. Then change the 3 at the end to be the actual RRN number you want to delete.
You may want to use a ‘select’ statement first to ensure you have the right record, here’s an example of that:
select * from LIBRARY/FILENAME A where RRN(A) = 3
Disclaimer:Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility in your own environment. Please review and test thoroughly before implementing. © Copyright 2009, Vision Solutions, Inc. All rights reserved. Vision Solutions develops and sells iSeries high availability and AIX replication and clustering solutions. IBM, System i, iSeries, and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.
4/17/09 - How to view the contents of user spaces
You can easily display contents of a *USRSPC by using the EDTF command. Here is a sample syntax:
EDTF STMF('qsys.lib/yourlib.lib/yourusrspc.usrspc')
Disclaimer:Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility in your own environment. Please review and test thoroughly before implementing. © Copyright 2009, Vision Solutions, Inc. All rights reserved. Vision Solutions develops and sells iSeries high availability and AIX replication and clustering solutions. IBM, System i, iSeries, and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.
4/06/09 - The menu of menus
Don't remember what a menu is called?
Why not use the "menu of menus?"
The WRKMNU command will display menus alphabetically. They can be displayed by library and/or generically. You can even create a new menu, change an existing one or delete it right from the screen.
Disclaimer:Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility in your own environment. Please review and test thoroughly before implementing. © Copyright 2009, Vision Solutions, Inc. All rights reserved. IBM, System i, iSeries, and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.
03/25/09 Using the Save While Active command within IBM's BRMS backup management software
The following example is for an SAP application environment that is using an iSeries high availability software product, which is typically used for disaster recovery purposes. Because of this, the tape backup is performed on the replication target (backup) system.
The data library for the SAP environment is being saved with the Save While Active command:
Display Backup Control Group Entries S102XXXX
Group . . . . . . . . . . : R3PRDDATA
Default activity . . . . : *BKUPCY
Text . . . . . . . . . . : Save of R3PRDDATA - High Availability End and Start
Auxiliary Weekly Retain Save SWA
Backup List Storage Activity Object While Message
Seq Items Type Pool Device SMTWTFS Detail Active Queue
10 *EXIT *DFTACT
20 *EXIT *DFTACT
30 R3PRDDATA *SYSBAS *DFTACT *ERR *YES *LIB
The first user exit point in the BRMS Control Group ends the replication data group target processes:
User Exit Maintenance S102XXXX
Type command, press Enter.
Sequence number . . . . . . . : 10
Where used . . . . . . . . . : *EXIT
Weekly activity . . . . . . . : *DFTACT SMTWTFS
Command . . . . . . . . . . . . ENDDG DGDFN(R3PRD) PRC(*ALLTGT) ENDOPT(*CNTRLD) WAIT(500) TIMOUTOPT(*ENDIMMED)
The second user exit point uses the BRMS MONSWABRM process that watches for the Save While Active checkpoint message. Once the checkpoint message is received, the replication data group target side processes are restarted:
User Exit Maintenance S102XXXX
Type command, press Enter.
Sequence number . . . . . . . : 20
Where used . . . . . . . . . : *EXIT
Weekly activity . . . . . . . : *DFTACT SMTWTFS
Command . . . . . . . . . . . . MONSWABRM LIB(R3PRDDATA) CMD(STRDG DGDFN(R3PRD)) WAITMSG(7200)
Disclaimer:
Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility in your own environment. Please review and test thoroughly before implementing. © Copyright 2009, Vision Solutions, Inc. All rights reserved. IBM, System i, iSeries, and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.
