ODBC problem Changing Structure Table
I have a client program conncected via odbc to AS400, I defined a structure table (DDS) in the AS400 that the client program use, then I had to change the length of numeric field (3 to 8) but the client program not recognized. What I have to do?

Answer Question   |  March 31, 2012  5:18 PM
DDS, ODBC, V5R3

How to come up with storage statistics on iSeries 820
Sir: As per requirement again from our 3rd party vendor in assessing our prod iseries 820 for system performance fine-tuning:      “System storage information – Size and percentage allotted to SIBS and other system, usage, backup in the prod server.”       The main concern of the 3rd party vendor is on SIBS (Silverlake banking application) [...]

Answer Question   |  March 31, 2012  7:05 AM
iSeries, iSeries 820, iSeries Storage, V5R3

Complete installation of Function Availability in iSeries Navigator
Sir :        How do i complete the installation of additional FUNCTION AVAILABILITY under MANAGEMENT CENTRAL in iSeries Navigator since the function i need like MONITORS (i need this for the statistics) is labeled as NOT INSTALLED. This is also noticeable in My Connections where under a specific IP Connection (e.g. 192.102.10.10), other FUNCTIONS like WORK [...]

Answer Question   |  March 31, 2012  1:42 PM
iSeries 820, iSeries Navigator, V5R3

Hold parameter in batch job
why should we give the hold paramater (*yes) in a batch job? please let me the what is a a batch job?

Answer Question   |  March 31, 2012  4:32 AM
AS/400 batch jobs, AS/400 Parameters, V5R3

Modify QINACTITV to a limited number of users
Sir, how do you configure a limited number of users where the objective is that the session of these users will not automatically sign-off. Because the way i understand it, this is done using WRKSYSVAL SYSVAL(QINACTITV) but this approach will affect all users and this is not what i intend to do. i only want [...]

Answer Question   |  March 31, 2012  10:08 AM
iSeries, QINACTITV, V5R3, WRKSYSVAL

COBOL/400 subfile single page load(page by page load)
Hi! can any one give me sample code of cobol/400 program which loads a subfile records page by page. My problem here is I am able to code page by page records loading from a PF but when the Subfile is dispalyed it is not properly displaying the pages. Fro example after loading and displaying [...]

Answer Question   |  March 31, 2012  8:10 AM
COBOL, COBOL/400, iSeries, Subfile, V5R3

Automatic Storage Overflow MCH4299
Recently when running the daily backup I began getting an MCH4299 error, “One of the automatic storage stacks X’00000001′ for the thread has overflowed or a storage access beyond the maximum size of a teraspace automatic storage stack was attempted.” This particular server is v5r3. Can anyone tell me what may have caused this to [...]

Answer Question   |  March 31, 2012  2:17 PM
AS/400, AS/400 backup, AS/400 errors, V5R3

Deleting the physical files without deleting logical files
Hi, Can anybody tell me how to delete the physical file(PF-DTA) without deleting its dependent files (LF). Actually we are having Mimix running in our live and DR system, in the DR I want to delet PF only and resync with the live.

Answer Question   |  April 4, 2012  10:16 AM
AS400 file changes, Logical Files, MIMIX on iSeries, Physical Files, V5R3

Restore System 38 file to iSeries V5R3
I’ve been trying to restore a file from our old system. The backup was taken by reel tape then migrated to another media format (e.g. 3590) now I am trying to restore the file, unfortunately I cannot. What command should I use to restore? Screenshot from DISPLAY TAPE                     File       Block   Recg  Record  Block   File        [...]

Answer Question   |  June 13, 2011  8:13 AM
iSeries, iSeries Access, iSeries data center, V5R3

AS400 – Sysopr MSG ” CHG0064″
Message ID “CHG0064″ Message   “Please mount the tape from Account Reconcilemnet Services”  ( G C)  &n Recovery. . . . :   Enter ‘G’ when ready or ‘C’ to cancel.   What it means and what steps should be taken? Thanks.  

Answer Question   |  May 23, 2011  6:20 AM
AS/400, iSeries, QSYSOPR Message, V5R3

Resolving group profile and user profile in iSeries folder
We encountered a problem during our end of day batch processing. by the way to give a short background, we have an i-series model 820 running on V5R3 OS. Going back, during our end of day batch, there was an error and the details “Not authorized to access document LMAS0513.TXT in folder LNDOWN”. The immediate [...]

Answer Question   |  May 23, 2011  9:51 AM
Batch jobs, GPRPRF, iSeries, USRPRF, V5R3, WRKFLR

How to know MIMIX current version?
I am working on V5R3, how to know my current MIMIX version?

Answer Question   |  April 8, 2011  8:10 AM
AS/400 High Availability, AS/400 MIMIX, MIMIX, V5R3

STRPCO can’t recognize batch commands
Hi, I have this program in CL using STRPCO to call a batch file on my PC, but when the CL program with strpco starts to call the batch file the dos black screen shows an error message saying “choice” command is unrecognizable, but when i manually execute it by double clicking the batch file [...]

Answer Question   |  March 29, 2011  8:34 AM
Batch jobs, CL programs, STRPCO, V5R3

How do I create iSeries group profile?
i have a dilemma, im using iseries model 820 w/ OS V5R3 and i am tasked to create a group profile for 6 users and then enroll this newly created group profile to objects where this 6 users have *allobj access. Our security administrator will remove the *ALLOBJ in the userprofile of this 6 users. [...]

Answer Question   |  March 23, 2011  11:21 AM
iSeries 820, iSeries group profile, iSeries User Profiles, V5R3

Is there any conflict if create 2 different unit in as400 with the same objects and same ownership.
Is there any conflict if create 2 different unit in as400 with the same objects and same ownership. Are the LF’s will the PF’s dependencies (the LF) will not mixed?

Answer Question   |  March 18, 2011  6:06 AM
AS/400 administration, Logical Files, Physical Files, V5R3

Can’t close or clear file in iSeries V5R3
Generally we create a file in QTemp when returning data for a stored procedure. The cursor is left open so the data can be accessed. I neglected to copy the file to qtemp and now on our test system, I can’t close the file, I can’t clear the file. I’ve deleted each of the records [...]

Answer Question   |  March 10, 2011  7:09 PM
iSeries, Stored Procedures, V5R3

Can wrkrmtwtr command be used on V6R1?
can wrkrmtwtr command be used on V6R1?  would I download the savf that was created for V5R3, or is there a new one?

Answer Question   |  March 8, 2011  2:48 PM
iSeries Commands, V5R3, V6R1, WRKRMTWTR

Create output queue: LPT1_TEXT
Hi, we have same problem as Mark and after applying the parameter you gave in Crtoutq we have successfully print using DLINK. Just wanted to ask how you came up with LPT1_TEXT value, are there any values except LPT1_TEXT? Thanks man you’re good.

Answer Question   |  March 3, 2011  4:00 AM
AS/400 queue, CRTOUTQ, V5R3

New IBM monitors not created
I’m trying to create a message monitor, setup works fine with no errors but when I click the OK button the monitor isn’t listed in the window. I don’t see the monitor anywhere, I don’t get any messages, and there isn’t anything in the joblog that even hints at an issue. I also tried a [...]

Answer Question   |  June 23, 2011  4:10 PM
IBM, Management Central, Monitors, V5R3

iSeries 9406-800 and V6R1
We have a 9406-800 currently running V5R3 and we want to upgrade to V6R1.    First of all is the ox compatible with V6R1?   Secondly what kind of issues do I need to be aware of before I take on the upgrade?

Answer Question   |  April 5, 2011  7:25 PM
iSeries, iSeries Upgrades, V5R3, V6R1