• How to restore files to a different library

    Recently this user wrote the editors at Search400.com with this question: "I'm trying to restore files (which are currently journeyed) to a different library, but I don't want them to be journaled, as I'm just using them for testing. Once I've restored them, I have to stop the journalling for each...

    MichelleDavidson515 pointsBadges:
  • Download Spool file to Excel Format

    Hi Guys, Do you have any idea how to download the Spool Files(WRKSPLF with PRTF) to Microsoft Excel?   Thanks Mickey

    SoulReaper20 pointsBadges:
  • Access LDA for job waiting on a JOBQ

    Is there a way to access the LDA for a job that is waiting in the JOBQ? I want to write a program to monitor jobs in a JOBQ and move them to other JOBQs based on information that is in the LDA.

    DaveMi0 pointsBadges:
  • tape backup and system save

    My recent attempt to run a system save with "Go Save" and option 21 did nothing after about an hour the system unlocked and I had to IPL to allow other users to access the server. Could this be a problem of using a tape that was not initialized?. If so what is a command to initialize a tape? We...

    Clwaid25 pointsBadges:
  • how to find out jbcpu of individual object or users

    i want to take a report for the usage of each project and each user in the server. so please help me to take the report.

    Velans0 pointsBadges:
  • ODBC Request from iSeries to Excel

    I am trying to use an ODBC DSN I have created, that uses the iSeries Access for Windows Driver, to download data from a file in QUSRSYS, to Excel. I have to download from QUSRSYS because the file is IBM supplied. Note: QUSRSYS appears in QSYSLIBL system value. The problem I have is that unless I...

    PaulThomas0 pointsBadges:
  • Validity Checking Program – RSTLIB

    I'm trying to write a vality checking program for RSTLIB. Having problems identifying and declaring all of the parameters for the RSTLIB command. I have read somewhere there are hidden parameters that complicate the process. Has anyone ever done this or can someone point me in a direction for...

    S510lka0 pointsBadges:
  • Stream Files (STMF)

    We have three Stream files that I need to copy into standard ISeries database files used in our ERP system. I found the 'CPYFRMSTMF' command, but this cmd seems to allow copies only to other Stream type files with directories.(QSYS.LIB) Does anyone know how to copy a stream file into an actual...

    Jallison0 pointsBadges:
  • Officevision

    I recently move over to another machine and still at 4.5. I am now having problems with Officevision. Not all the items I had before are there. I am also having problem with data transfer.

    deputy825 pointsBadges:
  • Need help using RUNRMTCMD

    Greg is experimenting with the RUNRMTCMD on the AS/400 from a command line. He writes, "Can I run a VRPG exe on my local PC from the AS/400? If so, how? I keep getting a message CPE3447 'A remote host did not respond within the timeout period'. First, where can I get my local PC name? Second, how...

    MichelleDavidson515 pointsBadges:
  • Summer to winter time

    We are running 8 AS400's with Os400/V5.3. These machines run 24/7. At the end of this month, the clocks go back an hour to winter time. Is there a way that l can automate the clock setting (in-flight) without destroying the time-stamping on these machines or do l have to stop each AS400, wait one...

    Pricei0 pointsBadges:

    I am in the process of doing a system migration from a V5R2 Production Box, to a V5R3 "Soon To Be" Production Box. My question is, "Is there a tool (or program) that I can run, which will compare Cmd parameters for CHGCMDDFT, CHGCMD commands between the 2 systems ? I need to be able to ensure that...

    Zenmaster235 pointsBadges:
  • Object Connect

    Is anyone currently using object connect to move objects between partitions? I am running v5r3 and need to find a way around given the user *allobj to use the savrstobj command.

    Mstallings0 pointsBadges:
  • Trouble Editing Data on iSeries from Web Application

    Hello. I'm having a problem editing data in a database file on my AS400. I have an application server set up on the same machine and I've created a data source to access the files in my library. The provider is "DB2 for OS400 V5R1 JDBC Provider", the database name is "*LOCAL" and the library name...

    Cmorre0 pointsBadges:
  • CUM PTF apply

    The last two times I applied a CUM, the IPL did not complete because of false hardware errors. I was told by IBM that the microcode must have "gotten confused". I had to manual IPL from the B side which worked fine, then reIPL unattended to actually get the PTFs to apply. There was never any...

    Pat470 pointsBadges:
  • Microsoft ASP(iSerios Access ODBC) list all libraries for a particular user within AS400

    how do i list all the libraries that a user has access to. the user will be login in thru a ASP (iSerios Access ODBC Driver). Is there a "table" i can "SELECT" from and/or a "command" that i can execute. and subsequently i only want to display all the "tables" that the users has created in those...

    Rafael5830 pointsBadges:
  • Triggers and commitment control

    We are having problems finding a way to get trigger programs included in the needed commitment control boundary. The process starts with a JDBC connection to the 400, and via Java executing processes (SQL) that make changes to the DB files. The files are triggered, and any of the files the trigger...

    BoomerSooner0 pointsBadges:
  • Check Connection established on a TCP port from a program?

    Is there any way to get the status of a TCP port within a program? We need to monitor a specific port to ensure that a communications link is established, and then send a page to the analyst on call when the communications link goes down. I can view the information with NETSTAT 3 (WRKTCPSTS *CNN),...

    Tagrove0 pointsBadges:
  • HTTP Server config

    Cannot get iSeries Tasks Page in browser with -> http://xxx.xxx.xxx.xxx:2001 Have run STRTCPSVR SERVER(*HTTP) HTTPSVR(*ADMIN) from command line. Viewed the process thru WRKACTJOB - the job ends after few seconds. OS version V5R1, please help.

    ObjectAuthority0 pointsBadges:
  • Best way to clean out iSeries before selling

    Deb and her group are installing a new iSeries. Before selling the old one, they would like to remove software and programs from from it. What is the best way to do that? -- Michelle Davidson, editor, Search400.com

    MichelleDavidson515 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.