• IBM.Data.DB2

    Could anyone please tell me what is the difference between IBM.data.db2 and IBM.Data.DB2.iSeries. In my understanding .iSeries is specific to Windows and iSeries DB2 whereas IBM.Data.DB2 is for other series of DB2 as well. In other words IBM.Data.DB2.iSeries is a subset of IBM.Data.DB2. Is my...

    smrksrpqr5 pointsBadges:
  • Is RPG quicker than SQL to update ALL records

    We update a few fields in every record on a file with over 13 million records. Masking a copy of production data on a performance test environment. It is run on a two processor 595 box under OS7.1. The job runs for about 36 hours. If I wrote an RPG program, I would open the file non-keyed to...

    ShadowProgrammer15 pointsBadges:
  • Exit a macro from inside a macro (iSeries AS/400)

    How do I exit a macro while it is running if it runs into an error in iSeries AS/400? I have script that checks to see if the cursor is in a specific position and if it isn't I have a message box pop up telling the user to stop the macro, but how do I have it just exit instead?

    jasunderland15 pointsBadges:
  • Performance issue if we have server with disks of varying capacity on iSeries server

    Will there be performance issue if we have server with disks of varying capacity on iSeries server?

    JohnsonMumbai1,480 pointsBadges:
  • QDBFSTCCOL JOB IBM I

    My iSeries is 8202-E4C i/OS v6r1 , I found job QDBFSTCCOL CPU% is 84%. Why occupy large resource? May i adjust any factory to limit it? FY! QDBFSTCCOL SYSTEM VALUE The Allow background database statistics collection system value is also known as QDBFSTCCOL. You can use this system value to specify...

    lance2221357270 pointsBadges:
  • Command prompt values/keywords

    When I press F4 on a command, the parms appear but with the keywords displayed (not the values allowed) and I have to use F11 to display the parm values. How do I change the default so the values appear when the command is prompted.

    CoderHal380 pointsBadges:
  • FTP iSeries File as PC ANSI

    How to FTP an ISeries File to a non iSeries client so that the sent file is in PC ANSI format.

    joelkoper5 pointsBadges:
  • iSeries COBOL Programming

    I need to learn all features of programming COBOL in iSeries (compile, set up data file, run job, create report, modify test data file.........), from which web site can I quickly learn? Is there any tutor available out there? Thanks a lot for your info.

    ccy5015 pointsBadges:
  • Data masking for iSeries and SQL server

    My team is searching for a data masking solution that would work for both iSeries IBM DB2 and SQL Server. Any recommendations of vendors?

    DaneTestManagement5 pointsBadges:
  • List of companies migrated from iSeries to some other platform

    Hi all, Can someone have list of some major companies which migrated from iSeries to any other platform? Regards,

    hunshabbir72,900 pointsBadges:
  • IBM i cannot add new drives to RAID 6

    I'm adding 6 new drives of the same make/model into my IBM i V7R1. When I try to start RAID 6 parity, it will only provide me with the option for RAID 5. Why won't it allow RAID 6?

    jpanzenhagen95 pointsBadges:
  • CPYTOIMPF error when copying PF to stream file on iSeries

    I'm encountering an error while copying a PF to a stream file on iSeries if the stream file reside on a IFS link with 'NFS' as root directory. Below is the scenario where I'm getting this error. Used the below command: CpytoImpf Fromfile(Qtemp/CsvHeading) Tostmf(&CsvFile) Mbropt(*Replace)...

    HemanthD5 pointsBadges:
  • iSeries (OS/400) Library Permissions Access

    If a library containing programs has CHANGE or ALL access, does it imply that the program objects within it can be "replaced" with updated versions? If public access on the program objects contained within the library had PUBLIC authority of "Exclude", would that prevent the objects from being...

    Danmillin5 pointsBadges:
  • How to Rate Limit incoming SMTP connection on iSeries?

    We have an SMTP server that gets into trouble quite often. Incoming SMTP connections (usual suspects are Microsoft mail servers) are usually multiple connections from the same foreign SMTP server (usually Microsoft Office 365 servers). Trouble is for every SMTP connection a new job (QTSMTPSRVP) is...

    GazzaRoo225 pointsBadges:
  • ATTN key program – AS/400 – QSECOFR – Program that adopt authority

    Scenario: let's say I have a user that has authority to a PGM that adopts QSECOFR authority. If that user has limited capability set to *NO or *YES, what is the link with the ATTN Key PGM value? From an IT/Security audit perspective, how do the limit capability value and ATTN key PGM value (in the...

    aldc123100 pointsBadges:
  • SQL/400: Access to only SELECT statement

    I need to provide access to only SQL Select command in iSeries to user, is there a way to do it? User should be able to take F4 in the interactive SQL session. More specifically I will be providing a menu option to user like SQL SELECT, once user select it he should be directed to SQL interactive...

  • Create iSeries PF with multiple record formats

    How can I create an iseries PF with multiple record formats

    aderene185 pointsBadges:
  • iSeries file purge

    What is the best method to use in order to delete multiple old files at one time?

    pincknc5 pointsBadges:
  • iSeries flash backup cant start flash environment

    The iSeries flash backup won't start the flash environment cause of an IO error. What can I look for?

    UByankees5 pointsBadges:
  • GO DISKTASKS on iSeries

    I am trying to get disk information on a V6R1M0 iSeries utilizing GO DISKTASKS. When I try to run it using *CURRENT date & time, nothing happens. I set it up to get submitted weekly and nothing happens either. The existing information collected shows from Feb 2016. I have used this command for...

    NormS316920 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following