Telnet and OS400
Hava a client who is telnet-ing to a 170 box (V4R3m0) over the internet. They are having disconnect problems at random times and different locations. From my office, I have no problems – it stays up forever. From other locations, it could disconnect after 5 minutes or 2 hours. I set the system value QINACTITV [...]
Answer Question
| October 26, 2010 12:47 PM
AS/400, i5, iSeries, OS/400
Hava a client who is telnet-ing to a 170 box (V4R3m0) over the internet. They are having disconnect problems at random times and different locations. From my office, I have no problems – it stays up forever. From other locations, it could disconnect after 5 minutes or 2 hours. I set the system value QINACTITV [...]
Answer Question
| October 26, 2010 12:47 PM
AS/400, i5, iSeries, OS/400
Arpeggio data access is not showing the files on the librarie
I’m trying to download a text file from the Os400 with arpeggio but it doesn’t show the available files in the librarie, I already tried everything I know But still doesn’t work. Can someone help me please?
Answer Question
| June 2, 2005 2:27 PM
i5, iSeries, OS/400
I’m trying to download a text file from the Os400 with arpeggio but it doesn’t show the available files in the librarie, I already tried everything I know But still doesn’t work. Can someone help me please?
Answer Question
| June 2, 2005 2:27 PM
i5, iSeries, OS/400
Problems Deleting a file in IFS directory?
I have look all over the internet and found a couple of useful tips. I tried them all and this file refuses to delete. The file is in /qdls/hdrpprt/ and is named ~$100028.htm This file is definately corrupt. I have tried the following 1-I installed PTF MF34337 with no help 2-RMVLNK OBJLNK(‘/qdls/hdrpprt/~$100028.HTM’) 3-WRKFLR to check [...]
Answer Question
| October 24, 2010 10:32 AM
Hardware, i5, iSeries, OS/400, Servers
I have look all over the internet and found a couple of useful tips. I tried them all and this file refuses to delete. The file is in /qdls/hdrpprt/ and is named ~$100028.htm This file is definately corrupt. I have tried the following 1-I installed PTF MF34337 with no help 2-RMVLNK OBJLNK(‘/qdls/hdrpprt/~$100028.HTM’) 3-WRKFLR to check [...]
Answer Question
| October 24, 2010 10:32 AM
Hardware, i5, iSeries, OS/400, Servers
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
CPIB687 conflicting announcement for domain
In Qsysopr we get a CPIB687 message reason code 3. It references a conflict announcement for the domain that it is in along with our AS400. WE know how to disable the master browser settings on windows clients. This is a MAC client and we do not know how to disable it. IBM set we [...]
Answer Question
| October 23, 2009 8:19 AM
i5, Integration/Connectivity, iSeries, OS/400, PC/Windows Connectivity
In Qsysopr we get a CPIB687 message reason code 3. It references a conflict announcement for the domain that it is in along with our AS400. WE know how to disable the master browser settings on windows clients. This is a MAC client and we do not know how to disable it. IBM set we [...]
Answer Question
| October 23, 2009 8:19 AM
i5, Integration/Connectivity, iSeries, OS/400, PC/Windows Connectivity
AS400e
We have an AS400e 600 (S20 2166), however, it does not start up properly, the IPL panel lights up, but the rest of the system does not seem to power on, any ideas where we have gone wrong?
Answer Question
| April 8, 2005 2:54 PM
i5, iSeries, OS/400, Servers
We have an AS400e 600 (S20 2166), however, it does not start up properly, the IPL panel lights up, but the rest of the system does not seem to power on, any ideas where we have gone wrong?
Answer Question
| April 8, 2005 2:54 PM
i5, iSeries, OS/400, Servers
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
Win98 clients cannot connect to ISeries file share
I have created some Windows shares on our AS/400. I have also set permissions appropriately (to give specific users rights to specific share(s)). Here is what I have found: 1. All of my Windows XP machines have no problem mapping drives to the appropriate share(s). 2. SOME of my Windows 9x machines can connect to [...]
Answer Question
| April 8, 2005 11:37 AM
AS/400, Help Desk, i5, Integration/Connectivity, iSeries, OS/400, PC/Windows Connectivity, Tech support
I have created some Windows shares on our AS/400. I have also set permissions appropriately (to give specific users rights to specific share(s)). Here is what I have found: 1. All of my Windows XP machines have no problem mapping drives to the appropriate share(s). 2. SOME of my Windows 9x machines can connect to [...]
Answer Question
| April 8, 2005 11:37 AM
AS/400, Help Desk, i5, Integration/Connectivity, iSeries, OS/400, PC/Windows Connectivity, Tech support
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
SQL Statement
Column qualifier or table SLGRREP undefined. update yyyyy/slf1rep set F1_CAP_AT_END = ‘C’ where (xxxxx/slgrrep.grbss || ‘ ‘ || xxxxx/slgrrep.grggr) = in (select yyyyy/slf1rep.f1BSS || ‘ ‘ || yyyyy/slf1rep.F1GGR from xxxxx/slgrrep, yyyyy/slf1rep, xxxxx/slsyrep where SLF1REP.F1_END_DATE > SLSYREP.SY_PROCESSING_DATE and SLGRREP.GR_LOAN_TYPE = ‘abcd’ and F1_TYPE_OF_DEFER_FORB between ‘z01′ and ‘z99′ and F1_ACTIVE_INACTIVE_STS = ‘A’ and F1_CAP_AT_END = ‘ ‘ [...]
Answer Question
| October 20, 2009 4:27 PM
i5, iSeries, OS/400
Column qualifier or table SLGRREP undefined. update yyyyy/slf1rep set F1_CAP_AT_END = ‘C’ where (xxxxx/slgrrep.grbss || ‘ ‘ || xxxxx/slgrrep.grggr) = in (select yyyyy/slf1rep.f1BSS || ‘ ‘ || yyyyy/slf1rep.F1GGR from xxxxx/slgrrep, yyyyy/slf1rep, xxxxx/slsyrep where SLF1REP.F1_END_DATE > SLSYREP.SY_PROCESSING_DATE and SLGRREP.GR_LOAN_TYPE = ‘abcd’ and F1_TYPE_OF_DEFER_FORB between ‘z01′ and ‘z99′ and F1_ACTIVE_INACTIVE_STS = ‘A’ and F1_CAP_AT_END = ‘ ‘ [...]
Answer Question
| October 20, 2009 4:27 PM
i5, iSeries, OS/400
How can I automatically refresh my screen?
I have a basic RPG program that writes and displays a subfile. I would like to have it automatically refresh every 5mins. Can anyone give me an example of how to acomplish this? Once it displays for 5mins I want the program to exicute from the begining. Please Help.
Answer Question
| February 11, 2005 10:41 AM
i5, iSeries, OS/400
I have a basic RPG program that writes and displays a subfile. I would like to have it automatically refresh every 5mins. Can anyone give me an example of how to acomplish this? Once it displays for 5mins I want the program to exicute from the begining. Please Help.
Answer Question
| February 11, 2005 10:41 AM
i5, iSeries, OS/400
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
SQL joining tables across multiple AS/400′s
I would like to execute the following query. The problem is that the Table INVMST is on a different AS/400 than table CHURDLES. INSERT INTO IDEASLNT/SHURDLES SELECT I.IDEPT, I.ISDEPT, I.ICLAS, I.iSCLAS, I.ISTYL#,I.ASNUM, CONCAT(CONCAT(Digits(I.IDept), ‘-’), Digits(I.ISDEPT)), CONCAT(CONCAT(Digits(I.ASNUM), ‘-’), I.ISTYL#), Max(C.Best), Max(C.MetStdTo), Max(C.MetStdFrm), Max(C.BelowStd), Max(C.WOS), Max(C.UBest), Max(C.UMetStdTo), Max(C.UMetStdFrm), Max(C.UBelowStd) FROM INVMST I, CHURDLES C WHERE I.IDEPT = [...]
Answer Question
| January 18, 2005 12:19 PM
AS/400, i5, iSeries, OS/400, UDB for iSeries/i5
I would like to execute the following query. The problem is that the Table INVMST is on a different AS/400 than table CHURDLES. INSERT INTO IDEASLNT/SHURDLES SELECT I.IDEPT, I.ISDEPT, I.ICLAS, I.iSCLAS, I.ISTYL#,I.ASNUM, CONCAT(CONCAT(Digits(I.IDept), ‘-’), Digits(I.ISDEPT)), CONCAT(CONCAT(Digits(I.ASNUM), ‘-’), I.ISTYL#), Max(C.Best), Max(C.MetStdTo), Max(C.MetStdFrm), Max(C.BelowStd), Max(C.WOS), Max(C.UBest), Max(C.UMetStdTo), Max(C.UMetStdFrm), Max(C.UBelowStd) FROM INVMST I, CHURDLES C WHERE I.IDEPT = [...]
Answer Question
| January 18, 2005 12:19 PM
AS/400, i5, iSeries, OS/400, UDB for iSeries/i5
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
Determining Object Lock Status
One of our applications obtains exclusive locks on user-specific data areas. The application is being changed to use shared read locks instead. The problem is that a separate application was reading through a list of these data areas and counting which ones it was unable to obtain its own exclusive lock for in order to [...]
Answer Question
| January 18, 2005 1:25 PM
i5, iSeries, OS/400
One of our applications obtains exclusive locks on user-specific data areas. The application is being changed to use shared read locks instead. The problem is that a separate application was reading through a list of these data areas and counting which ones it was unable to obtain its own exclusive lock for in order to [...]
Answer Question
| January 18, 2005 1:25 PM
i5, iSeries, OS/400
iSeries Graphical System Debugger
Hello! Can anyone help me with iSeries Graphical System Debugger? I did install Graphical Debugger according to iSeries News (September 2004 issue) article “Introduction to the iSeries Graphical System Debugger” by Vadim Berestetsky and Cary Bates with no problems. When I start debugger (with java -cp tes.jar;jt400.jar;jhall.jar utilities.DebugMgr command in command prompt on my workstation) [...]
Answer Question
| February 1, 2005 10:59 AM
AS/400, Hardware, Help Desk, i5, iSeries, OS/400, PC/Windows Connectivity, Servers, Tech support
Hello! Can anyone help me with iSeries Graphical System Debugger? I did install Graphical Debugger according to iSeries News (September 2004 issue) article “Introduction to the iSeries Graphical System Debugger” by Vadim Berestetsky and Cary Bates with no problems. When I start debugger (with java -cp tes.jar;jt400.jar;jhall.jar utilities.DebugMgr command in command prompt on my workstation) [...]
Answer Question
| February 1, 2005 10:59 AM
AS/400, Hardware, Help Desk, i5, iSeries, OS/400, PC/Windows Connectivity, Servers, Tech support
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
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
