New to AS400 administration and need some help.
I have two questions here if someone can help. I will appreciate anything you can give. First, I am trying to configure a network printer on the AS400. I did wrkcfgsts, work with description, and copied the printer devices description and modified the printer device with the new info. All I changed was the IP [...]
Answer Question
| April 6, 2009 12:04 PM
Auditing, Availability, Backup & recovery, Capacity planning, DataCenter, Hardware, Help Desk, i5, IBM, Installation, Integration with other platforms, Integration/Connectivity, iSeries, Logical partitions, Mainframe, Microsoft Windows, Networking, Operating systems, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Remote access, Reporting, Security, Security management, Server consolidation, Servers, System monitoring, Tech support, Technical support, tips and tricks, Tools
I have two questions here if someone can help. I will appreciate anything you can give. First, I am trying to configure a network printer on the AS400. I did wrkcfgsts, work with description, and copied the printer devices description and modified the printer device with the new info. All I changed was the IP [...]
Answer Question
| April 6, 2009 12:04 PM
Auditing, Availability, Backup & recovery, Capacity planning, DataCenter, Hardware, Help Desk, i5, IBM, Installation, Integration with other platforms, Integration/Connectivity, iSeries, Logical partitions, Mainframe, Microsoft Windows, Networking, Operating systems, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Remote access, Reporting, Security, Security management, Server consolidation, Servers, System monitoring, Tech support, Technical support, tips and tricks, Tools
OS/400 System Security; Limiting User Capabilities
We have set up our AS/400 user profiles with Limit Capabilities *NO. However, this does not keep them from being able to enter a command on a command line. How do we accomplish this?
Answer Question
| October 21, 2010 10:13 AM
AS/400, DataCenter, Hardware, i5, iSeries, OS/400, Security, Servers, tips and tricks, Tools
We have set up our AS/400 user profiles with Limit Capabilities *NO. However, this does not keep them from being able to enter a command on a command line. How do we accomplish this?
Answer Question
| October 21, 2010 10:13 AM
AS/400, DataCenter, Hardware, i5, iSeries, OS/400, Security, Servers, tips and tricks, Tools
User Id in Pgm DS in case of Scheduled Batch Job.
Hi All. An user’s id can be retrieved inside the pgm from system Data Structure which contains the User Id invoking the pgm. Normally this is passed to a file field before writing/updating the file. If the file is updated by a Batch pgm then the Id of user submitting the job goes to the [...]
Answer Question
| October 21, 2009 3:11 AM
i5, iSeries, OS/400, System monitoring, tips and tricks, Tools
Hi All. An user’s id can be retrieved inside the pgm from system Data Structure which contains the User Id invoking the pgm. Normally this is passed to a file field before writing/updating the file. If the file is updated by a Batch pgm then the Id of user submitting the job goes to the [...]
Answer Question
| October 21, 2009 3:11 AM
i5, iSeries, OS/400, System monitoring, tips and tricks, Tools
I5 HMC Not Saving Scheduled Operations on Reboot
I use our HMC to schedule moves of our tape resource overnight so two of our AS400 LPARS can be backed up with no manual intervention. I schedule this move within HMC configuration then ‘Schedule Operations’. The I/O resource moves have infinte repeats and run quite happily from night to night. However, if I reboot [...]
Answer Question
| April 1, 2005 9:59 AM
Backup & recovery, Hardware, i5, iSeries, Logical partitions, OS/400, tips and tricks, Tools
I use our HMC to schedule moves of our tape resource overnight so two of our AS400 LPARS can be backed up with no manual intervention. I schedule this move within HMC configuration then ‘Schedule Operations’. The I/O resource moves have infinte repeats and run quite happily from night to night. However, if I reboot [...]
Answer Question
| April 1, 2005 9:59 AM
Backup & recovery, Hardware, i5, iSeries, Logical partitions, OS/400, tips and tricks, Tools
Does anyone on your team have an AS400 script handy to purge out oldest members of appended files?
Basically, I’m hoping that somebody out there might already have a script or program that they use to purge out old members that get appended to static physical files on the MC400 (HNNE). I would be much obliged if you could send me the program or provide me a tip on where I can find [...]
Answer Question
| October 20, 2009 2:07 PM
AS/400, Performance/Tuning, tips and tricks, Tools
Basically, I’m hoping that somebody out there might already have a script or program that they use to purge out old members that get appended to static physical files on the MC400 (HNNE). I would be much obliged if you could send me the program or provide me a tip on where I can find [...]
Answer Question
| October 20, 2009 2:07 PM
AS/400, Performance/Tuning, tips and tricks, Tools
Record Blocking Factor
I have found several different equations to calculate the correct blocking factor when utilizing NBRRCDS in a CL to optimize I/O. One stated (128k)/(reclength), another (128k)/(reclength+1), another (1024*256)/(reclength) and still another (131072)/(reclength+1), with different variations in the record length and the additional one-byte. If the total record length of my file is 104 (DSPFD), how [...]
Answer Question
| April 2, 2005 4:59 PM
i5, iSeries, OS/400, Performance/Tuning, RPG, tips and tricks, Tools
I have found several different equations to calculate the correct blocking factor when utilizing NBRRCDS in a CL to optimize I/O. One stated (128k)/(reclength), another (128k)/(reclength+1), another (1024*256)/(reclength) and still another (131072)/(reclength+1), with different variations in the record length and the additional one-byte. If the total record length of my file is 104 (DSPFD), how [...]
Answer Question
| April 2, 2005 4:59 PM
i5, iSeries, OS/400, Performance/Tuning, RPG, tips and tricks, Tools
F22 key on AS/400
Hello everyone, we have a couple of acountants onsite at a clients, and they are using an AS/400, they need to know how to access the F22 key, is this depending on the emulator they are using? or is there a way to access it?
Answer Question
| February 28, 2005 12:45 PM
Database Management Systems, DataCenter, Hardware, i5, iSeries, Networking, OS/400, Servers, tips and tricks, Tools
Hello everyone, we have a couple of acountants onsite at a clients, and they are using an AS/400, they need to know how to access the F22 key, is this depending on the emulator they are using? or is there a way to access it?
Answer Question
| February 28, 2005 12:45 PM
Database Management Systems, DataCenter, Hardware, i5, iSeries, Networking, OS/400, Servers, tips and tricks, Tools
Printing with Axis print server for example 5400.
Hi It’s possible printing directly to Axis print server from OS/400 V510 or V520 or V530 like a printer for example HP5000 with a network card? I configure a HP with a network card this way Criar Descr Disp (Impressora) (CRTDEVPRT) Indique as opc?es, prima Enter. Descric?o de dispositivo . . . . DEVD > [...]
Answer Question
| January 24, 2005 12:19 PM
AS/400, i5, iSeries, OS/400, Printing, tips and tricks, Tools
Hi It’s possible printing directly to Axis print server from OS/400 V510 or V520 or V530 like a printer for example HP5000 with a network card? I configure a HP with a network card this way Criar Descr Disp (Impressora) (CRTDEVPRT) Indique as opc?es, prima Enter. Descric?o de dispositivo . . . . DEVD > [...]
Answer Question
| January 24, 2005 12:19 PM
AS/400, i5, iSeries, OS/400, Printing, tips and tricks, Tools
Deleting journal receivers
HI, When I try to delete a journal receiver that hasn’t been saved, I get the “never fully saved” message even though I’m using DLTOPT(*IGNINQMSG) Does anyone have a piece of code that will get rid of receivers no matter what? E.G. not saved, remote, attached…… Thanks
Answer Question
| October 11, 2010 11:04 AM
Backup & recovery, Database Management Systems, DB2, DB2 administration, Hardware, i5, iSeries, OS/400, Performance/Tuning, Servers, tips and tricks, Tools
HI, When I try to delete a journal receiver that hasn’t been saved, I get the “never fully saved” message even though I’m using DLTOPT(*IGNINQMSG) Does anyone have a piece of code that will get rid of receivers no matter what? E.G. not saved, remote, attached…… Thanks
Answer Question
| October 11, 2010 11:04 AM
Backup & recovery, Database Management Systems, DB2, DB2 administration, Hardware, i5, iSeries, OS/400, Performance/Tuning, Servers, tips and tricks, Tools
Triggers
Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks
Answer Question
| October 19, 2009 2:35 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks
Answer Question
| October 19, 2009 2:35 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
Triggers
Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks
Answer Question
| December 27, 2004 2:35 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks
Answer Question
| December 27, 2004 2:35 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
OS/400 descriptions of files in Library QUSRSYS.
Hi There, Does anyone have descriptions of the files and their contained information for the files in Library QUSRSYS. In particular I am looking for where the “Go Backup” and “Go Cleanup” configurations are stored but explanations of the other files in this library will also be extremly usefull for High Availability purposes. Thanks. Best [...]
Answer Question
| December 6, 2004 9:02 AM
AS/400, Backup & recovery, Hardware, i5, IBM, Installation, iSeries, OS/400, Performance/Tuning, Server consolidation, Servers, tips and tricks, Tools
Hi There, Does anyone have descriptions of the files and their contained information for the files in Library QUSRSYS. In particular I am looking for where the “Go Backup” and “Go Cleanup” configurations are stored but explanations of the other files in this library will also be extremly usefull for High Availability purposes. Thanks. Best [...]
Answer Question
| December 6, 2004 9:02 AM
AS/400, Backup & recovery, Hardware, i5, IBM, Installation, iSeries, OS/400, Performance/Tuning, Server consolidation, Servers, tips and tricks, Tools
Delect members by age using CL
I download a bank file once a day. I want to keep the last two weeks of files stored in members of file ARCHIVE. Typical member names might be 20041109, etc. How can I purge the members that are more than 15 days old using CL? Is there a way to convert a *CHAR variable [...]
Answer Question
| October 19, 2009 11:19 AM
i5, iSeries, OS/400, Programming Languages, tips and tricks, Tools
I download a bank file once a day. I want to keep the last two weeks of files stored in members of file ARCHIVE. Typical member names might be 20041109, etc. How can I purge the members that are more than 15 days old using CL? Is there a way to convert a *CHAR variable [...]
Answer Question
| October 19, 2009 11:19 AM
i5, iSeries, OS/400, Programming Languages, tips and tricks, Tools
Restoring Source Files on the iSeries
We are moving to a new i5/iSeries machine. We will be doing a full backup, then a restore, then a SAVCHGOBJ. However, in the past, when we’ve done a restore of a source file, the existing members get renamed (SRCMBR00001) and the members from the restore get put in correctly. Does anybody know the exact [...]
Answer Question
| March 9, 2005 8:30 AM
Backup & recovery, i5, Installation, iSeries, OS/400, RPG, Server consolidation, tips and tricks, Tools
We are moving to a new i5/iSeries machine. We will be doing a full backup, then a restore, then a SAVCHGOBJ. However, in the past, when we’ve done a restore of a source file, the existing members get renamed (SRCMBR00001) and the members from the restore get put in correctly. Does anybody know the exact [...]
Answer Question
| March 9, 2005 8:30 AM
Backup & recovery, i5, Installation, iSeries, OS/400, RPG, Server consolidation, tips and tricks, Tools
