• 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:
  • Processor Cards for iSeries 9406 model 520

    How many processor cards does a iSeries type 9406 model 520 have?

    TNS1223155 pointsBadges:
  • FTP from IFS to iSeries database line: Line break not recognized

    I am trying to FTP from IFS to a iSeries database file. The file gets transferred but the end of line is not getting recognized so only one record is created in the receiving file.

    ptrabe5 pointsBadges:
  • 21 SAVE IFS & DLO

    I am processing on an i5, 520, V6R1M0. How are the IFS & DLO folders being saved using 21 SAVE? Upgrading to a Power 8 and we want to be sure all information is backed up and properly restored to the new iSeries.

    NormS316920 pointsBadges:
  • Uninstall MIMIX from iSeries

    I need to know the specific steps required to remove my MIMIX environments.  We have 6 MIMIX pairs, currently remote journaling to another system and are moving into a flash scenario. Eliminating MIMIX entirely. Thank you.

    maroche15 pointsBadges:
  • Determine if secondary language is installed correctly on iSeries (AS/400)

    After much searching, I have determined that the simple answer is no where to be found. I'm trying to determine how to trouble shoot when adding QSYS2924 to the library list doesn't work, what might be the problem. I have a client that has at least attempted to install English as the secondary...

    cooldht50 pointsBadges:
  • Give iSeries profile access to only one object

    I know there are ways to lock down an object but is there a way to lock down a user profile so that it can access only one object?

    Camgin90 pointsBadges:
  • iSeries FTP: No response from remote host all connection closed

    In iSeries RTP wen giving put command, I'm getting this error: No response from remote host all connection closed. What should I do?

    whirlpool5 pointsBadges:
  • Maximum size of iSeries logical file

    What is the maximum size that a logical file may reach on an iSeries before is causes program access application to halt (...go boom!...bring a casino floor down...)?

    WundersW5 pointsBadges:
  • RSA & SHA-2

    We have a 'partner' who has, without notice, disabled SHA-1 & insists we now use SHA-2 for our sFTP transfers. Does anyone have any suggestions on setting up SHA-2 on the System i & tying it to RSA?

    Splat11,175 pointsBadges:
  • SQL Select for Multi Format File

    I need to select and update fields in an iSeries file with multiple formats. How do I specify the member I want to work with?

    Roycer775 pointsBadges:
  • iSeries SQL0904 Resource limit exceeded

    I have written RPG/ILE stored procedures to validate and write data to various physical files with data extracted from MSSQL tables using SSIS and MS Visual Studio 2013 and utilizing the Native OLE DBIBM DB2 for i IBMDA400 OLE DB Provider. My problem the extract job fails when trying to import...

    JustJamesG5 pointsBadges:
  • Emailing BRMS reports automatically

    I have three iSeries that use BRMS, two of the systems have Help Systems Robot applications - which I use to send BRMS reports daily. The third system doesn't have Help Systems Robot installed. Is it possible to have BRMS send the daily BRMS reports to a user through e-mail or is that pretty much a...

    JMatthews5020 pointsBadges:
  • CWBDB0036 / SQL0204 Error when using data transfer to IBMi

    A single user gets the error; CWBDB0036 - Server returned SQL error SQL0204 - "filename" in *CURLIB type *FILE not found. We recently upgraded our OS to V7R1 and since the upgrade we have a user that is unable to run a .dtt to transfer a .csv into an existing file / member on the 400. I even...

    MWeales25 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