Connect to AS/400 from a PC and run User Profiles Initial Program
I’d like to be able to have a user connect via FTP, ect. from a PC to our AS/400, login, and have the user profiles inital program run immediately. We’ve tried several options, but the initial program doesn’t run unless a user signs on to a Session. This is not an option. Can you help? [...]
Answer Question
| October 26, 2009 10:19 AM
AS/400, DataCenter, i5, iSeries, OS/400, Programming Languages
I’d like to be able to have a user connect via FTP, ect. from a PC to our AS/400, login, and have the user profiles inital program run immediately. We’ve tried several options, but the initial program doesn’t run unless a user signs on to a Session. This is not an option. Can you help? [...]
Answer Question
| October 26, 2009 10:19 AM
AS/400, DataCenter, i5, iSeries, OS/400, Programming Languages
Changing the statement heap parameter on iSeries
Hi, I would like to know how to change the statement heap parameter DB2 (stmtheap) on the AS/400. I tried the command GET DATABASE CONFIGURATION FOR database-alias (giving alias name as the AS/400 server name) but it returns the error “SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can [...]
Answer Question
| June 9, 2005 6:10 AM
Application software, Availability, Backup & recovery, CIO, Computer Associates, Data center operations, Database Management Systems, DataCenter, DB2, DB2 administration, DB2 Everyplace, DB2 Implementation, Development, E-business, Hardware, IT architecture, Modeling, Operating system platforms, Performance/Tuning, Physical security, Services, Space/structure, Storage, Tech support, Third-party services, UDB for iSeries/i5, Vendors
Hi, I would like to know how to change the statement heap parameter DB2 (stmtheap) on the AS/400. I tried the command GET DATABASE CONFIGURATION FOR database-alias (giving alias name as the AS/400 server name) but it returns the error “SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can [...]
Answer Question
| June 9, 2005 6:10 AM
Application software, Availability, Backup & recovery, CIO, Computer Associates, Data center operations, Database Management Systems, DataCenter, DB2, DB2 administration, DB2 Everyplace, DB2 Implementation, Development, E-business, Hardware, IT architecture, Modeling, Operating system platforms, Performance/Tuning, Physical security, Services, Space/structure, Storage, Tech support, Third-party services, UDB for iSeries/i5, Vendors
Old Risc Box
I have an old risc box 9402-4xx (V3R6)that I am looking to get rid of. Does anyone know how to generate a list of what this box has in it, eg. memory, disk space, etc. Any ideas are greatly appreciated.
Answer Question
| June 8, 2005 3:32 PM
i5, iSeries, OS/400
I have an old risc box 9402-4xx (V3R6)that I am looking to get rid of. Does anyone know how to generate a list of what this box has in it, eg. memory, disk space, etc. Any ideas are greatly appreciated.
Answer Question
| June 8, 2005 3:32 PM
i5, iSeries, OS/400
How to automatically clear the remaining of a numeric input field with pressing field exit
My screen has a input field where the length is 7,0. It has a default value of 50 and the user enter 91 at the beginning of the field and press accept function key. The return value to the program becomes 9100050. Is there any DDS keyword that I can use to avoid this problem? [...]
Answer Question
| October 26, 2009 3:03 PM
RPG
My screen has a input field where the length is 7,0. It has a default value of 50 and the user enter 91 at the beginning of the field and press accept function key. The return value to the program becomes 9100050. Is there any DDS keyword that I can use to avoid this problem? [...]
Answer Question
| October 26, 2009 3:03 PM
RPG
IFS on Iseries
After sharing a folder in the IFS i can access it via the windows network, I can paste a file in the folder but cannot delete it, I get a message “Cannot delete :There has been a sharing violation the source destination file may be in use” I have stoped & started the netserver & [...]
Answer Question
| March 23, 2012 6:18 AM
AS/400, Security management
After sharing a folder in the IFS i can access it via the windows network, I can paste a file in the folder but cannot delete it, I get a message “Cannot delete :There has been a sharing violation the source destination file may be in use” I have stoped & started the netserver & [...]
Answer Question
| March 23, 2012 6:18 AM
AS/400, Security management
Damaged File In Save Operations
I have a file that is damaged, therefore, it will not save during my nightly backups. The file is QASZRAIRD in library QUSRSYS. Does anyone know what this file is used for or how I can find out what this file is used for? Can I delete the file and re-create the file, or will [...]
Answer Question
| June 7, 2005 3:24 PM
Backup & recovery, Hardware, i5, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, System monitoring, tips and tricks, Tools
I have a file that is damaged, therefore, it will not save during my nightly backups. The file is QASZRAIRD in library QUSRSYS. Does anyone know what this file is used for or how I can find out what this file is used for? Can I delete the file and re-create the file, or will [...]
Answer Question
| June 7, 2005 3:24 PM
Backup & recovery, Hardware, i5, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, System monitoring, tips and tricks, Tools
Looking for a new start
Hi! I am a long time AS400 programmer. Because, of the lack of marketing for the AS400–the job opportunities have plumitted. I would like to revamp me career–but, don’t know what direction to go. Can someone stir me in the right direction?
Answer Question
| June 7, 2005 11:33 AM
Career development, J2EE, RPG, VB.NET, Visual Basic
Hi! I am a long time AS400 programmer. Because, of the lack of marketing for the AS400–the job opportunities have plumitted. I would like to revamp me career–but, don’t know what direction to go. Can someone stir me in the right direction?
Answer Question
| June 7, 2005 11:33 AM
Career development, J2EE, RPG, VB.NET, Visual Basic
iseries system management monitor
Hi, I’m looking for a iseries system management monitor tool. I found one at www.tango04.com, Visual Message Center, but my question is; are there other alternatives available? These monitors can run on Windows or Linux platform, a gui would be nice.
Answer Question
| December 10, 2009 8:43 AM
AS/400, Hardware, i5, Integration/Connectivity, iSeries, OS/400, Performance/Tuning, Security, System monitoring, tips and tricks, Tools
Hi, I’m looking for a iseries system management monitor tool. I found one at www.tango04.com, Visual Message Center, but my question is; are there other alternatives available? These monitors can run on Windows or Linux platform, a gui would be nice.
Answer Question
| December 10, 2009 8:43 AM
AS/400, Hardware, i5, Integration/Connectivity, iSeries, OS/400, Performance/Tuning, Security, System monitoring, tips and tricks, Tools
Problem with AS400 Automatic Upgrade from V4R5M0 to V5R2M0, using a Software Installation Tape.
Why does the ‘QUSRSYS’ lib always end up in error during this process? To get round this, we perform a RSTLIB of QUSRSYS manually. Has anyone else had this problem, as its currently stopping us from upgrading our remote V4R5 sites automatically.
Answer Question
| June 8, 2005 7:20 AM
AS/400, Tech support
Why does the ‘QUSRSYS’ lib always end up in error during this process? To get round this, we perform a RSTLIB of QUSRSYS manually. Has anyone else had this problem, as its currently stopping us from upgrading our remote V4R5 sites automatically.
Answer Question
| June 8, 2005 7:20 AM
AS/400, Tech support
i5 520 External tape attachment
Does the IBM 7208-012 external tape attach to the i5 520? If yes, which adapters can be used.
Answer Question
| May 30, 2005 2:43 PM
i5, iSeries, OS/400
Does the IBM 7208-012 external tape attach to the i5 520? If yes, which adapters can be used.
Answer Question
| May 30, 2005 2:43 PM
i5, iSeries, OS/400
Calling External Procedure from Java Web based Application
Below given is a procedure to access a CL Program in iSeries from a Java web based program. create procedure libxxx/proc_name LANGUAGE CL FENCED EXTERNAL NAME ‘libxxx/clprogram’ PARAMETER STYLE GENERAL The external CL program has other calls to Cobol programs in the same library.The procedure is in a different library.The cobol calls does not have [...]
Answer Question
| October 26, 2009 5:09 PM
COBOL, i5, IBM, IBM WebSphere, iSeries, J2EE, Java, OS/400, SQL, UDB for iSeries/i5
Below given is a procedure to access a CL Program in iSeries from a Java web based program. create procedure libxxx/proc_name LANGUAGE CL FENCED EXTERNAL NAME ‘libxxx/clprogram’ PARAMETER STYLE GENERAL The external CL program has other calls to Cobol programs in the same library.The procedure is in a different library.The cobol calls does not have [...]
Answer Question
| October 26, 2009 5:09 PM
COBOL, i5, IBM, IBM WebSphere, iSeries, J2EE, Java, OS/400, SQL, UDB for iSeries/i5
BMP scheduling of IMS and DB2 database access.
Application developers have nearly completed a conversion from IMS to DB2. They have used BMP to leave their test subsystems available to online tranactions. One day BMP users of BMP failed with U3042. This only occured for BMP users testing with IMS & DB2 databases. I am investigating the issue, without much IMS support experience. [...]
Answer Question
| May 27, 2005 1:02 PM
DB2, Instant Messaging, OS/390, UDB for mainframe, z/OS
Application developers have nearly completed a conversion from IMS to DB2. They have used BMP to leave their test subsystems available to online tranactions. One day BMP users of BMP failed with U3042. This only occured for BMP users testing with IMS & DB2 databases. I am investigating the issue, without much IMS support experience. [...]
Answer Question
| May 27, 2005 1:02 PM
DB2, Instant Messaging, OS/390, UDB for mainframe, z/OS
Whats included in 5250 OLTP? Do I have to by OS400 again?
We are in the process of inivesting in new i5 servers, we have old AS400 servers today and licences for serveral OS400 licpgms, but there is one single big post in our offer from BP. The ‘enterprise edition’, when I look into a FAQ about ‘enterprise edition’ I confused. 5722SS1 V5R3 is one of the [...]
Answer Question
| May 27, 2005 10:44 AM
i5, iSeries, OS/400
We are in the process of inivesting in new i5 servers, we have old AS400 servers today and licences for serveral OS400 licpgms, but there is one single big post in our offer from BP. The ‘enterprise edition’, when I look into a FAQ about ‘enterprise edition’ I confused. 5722SS1 V5R3 is one of the [...]
Answer Question
| May 27, 2005 10:44 AM
i5, iSeries, OS/400
Installing PTFs questions and concerns.
I am now responsible for installing PTFs on the as400. I will be performing my first install on June 25th. I have some questions if someone doesn’t mind helping? 1. Documentation says to check the CD to make sure that it works. I put the CD in my CD drive at my local PC and [...]
Answer Question
| May 25, 2005 9:42 AM
Backup & recovery, Hardware, i5, IBM, IBM/Tivoli, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, System monitoring, tips and tricks, Tools
I am now responsible for installing PTFs on the as400. I will be performing my first install on June 25th. I have some questions if someone doesn’t mind helping? 1. Documentation says to check the CD to make sure that it works. I put the CD in my CD drive at my local PC and [...]
Answer Question
| May 25, 2005 9:42 AM
Backup & recovery, Hardware, i5, IBM, IBM/Tivoli, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, System monitoring, tips and tricks, Tools
Calling HTTP/Java from ILE Program
I am trying to find out if it is possible to perform an HTTP/Java call to an external Web Server (Not Webspere) from an AS400 ILE program RPGLE or CLE
Answer Question
| May 26, 2005 4:51 AM
i5, iSeries, OS/400, RPG
I am trying to find out if it is possible to perform an HTTP/Java call to an external Web Server (Not Webspere) from an AS400 ILE program RPGLE or CLE
Answer Question
| May 26, 2005 4:51 AM
i5, iSeries, OS/400, RPG
reusedlt *yes
Hi, Has reusedlt *yes behavior changed with V5R3? When I add a record to a PF that is reusedlt *yes in V5R2 is uses a record that has been deleted, however when i do the same thing on a V5R3 system it adds a new record rather than re-use one. Anyone run into this before? [...]
Answer Question
| November 1, 2011 2:52 PM
Backup & recovery, Data center operations, Data mining/analysis, Data warehousing applications, Database Management Systems, DB2, DB2 administration, DB2 Implementation, Disaster Recovery, Hardware, Help Desk, i5, IBM, iSeries, OS/400, Performance/Tuning, Security management, Software Quality Assurance, System monitoring, Tech support, tips and tricks, Tools
Hi, Has reusedlt *yes behavior changed with V5R3? When I add a record to a PF that is reusedlt *yes in V5R2 is uses a record that has been deleted, however when i do the same thing on a V5R3 system it adds a new record rather than re-use one. Anyone run into this before? [...]
Answer Question
| November 1, 2011 2:52 PM
Backup & recovery, Data center operations, Data mining/analysis, Data warehousing applications, Database Management Systems, DB2, DB2 administration, DB2 Implementation, Disaster Recovery, Hardware, Help Desk, i5, IBM, iSeries, OS/400, Performance/Tuning, Security management, Software Quality Assurance, System monitoring, Tech support, tips and tricks, Tools
Need some performance tuning tips or suggestions.
We currently have a 720-9406 model iSeries AS/400 system. We recently upgraded are OS to version V5R3M0. We are using the system mainly for our payroll processing which occurs weekly, as well as we have the system set up as a web server which we have employees accessing throughout the day. Since the upgrade, our [...]
Answer Question
| October 26, 2009 9:46 AM
Backup & recovery, Hardware, i5, IBM, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, Servers, System monitoring, tips and tricks, Tools, Web services
We currently have a 720-9406 model iSeries AS/400 system. We recently upgraded are OS to version V5R3M0. We are using the system mainly for our payroll processing which occurs weekly, as well as we have the system set up as a web server which we have employees accessing throughout the day. Since the upgrade, our [...]
Answer Question
| October 26, 2009 9:46 AM
Backup & recovery, Hardware, i5, IBM, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, Servers, System monitoring, tips and tricks, Tools, Web services
How To Print A Hardware Configuration List?
Does anyone know of another command to use to print out a hardware configuration list for the AS/400. I have already used the following command: DSPHDWRSC TYPE(*AHW) OUTPUT(*PRINT) Is there anything else that can be used?
Answer Question
| October 25, 2009 9:34 AM
Backup & recovery, Hardware, i5, IBM, IBM/Tivoli, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, System monitoring, tips and tricks, Tools
Does anyone know of another command to use to print out a hardware configuration list for the AS/400. I have already used the following command: DSPHDWRSC TYPE(*AHW) OUTPUT(*PRINT) Is there anything else that can be used?
Answer Question
| October 25, 2009 9:34 AM
Backup & recovery, Hardware, i5, IBM, IBM/Tivoli, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, System monitoring, tips and tricks, Tools
MSACCES to AS400
I am currently working on a project where I need to take files from a MsACCESS and transfer them to the Iseries possibly replacing them on a daily basis. I have been able to export them to the ISERIES manually, via the export on the file menu. I have not been able to find an [...]
Answer Question
| May 27, 2005 8:34 AM
AS/400, Development, RPG, SQL, VB.NET, Visual Basic
I am currently working on a project where I need to take files from a MsACCESS and transfer them to the Iseries possibly replacing them on a daily basis. I have been able to export them to the ISERIES manually, via the export on the file menu. I have not been able to find an [...]
Answer Question
| May 27, 2005 8:34 AM
AS/400, Development, RPG, SQL, VB.NET, Visual Basic
What can cause a journal entry where JOENTT = ‘CR’ (besides CLRPFM)?
I have a problem with an interactive option that unintentionally clears an entire physical file – only very occasionally but catastrophically when it does happen. On the last occasion, the file was journalled and indicates the program responsible. The journal entry has type, JOENTT = ‘CR’. Nowhere does the program do a CLRPFM. It does [...]
Answer Question
| October 24, 2010 5:12 AM
RPG
I have a problem with an interactive option that unintentionally clears an entire physical file – only very occasionally but catastrophically when it does happen. On the last occasion, the file was journalled and indicates the program responsible. The journal entry has type, JOENTT = ‘CR’. Nowhere does the program do a CLRPFM. It does [...]
Answer Question
| October 24, 2010 5:12 AM
RPG
