• 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:
  • Automatic email notifications from iSeries

    Nagi needs to write a code on his iSeries 870 to send a notifications to his e-mail, such as server rebooting, jobs not started or need reply, etc. He's a Windows guy, and doesn't know where to start. Can someone help him with the code and possibly send him steps on how to write it and where and...

    MichelleDavidson515 pointsBadges:
  • Convert iSeries spool file to PC data file

    Mario needs to convert an iSeries-AS/400 file to a PC data file. Can anyone advise him? -- Michelle Davidson, editor, Search400.com

    MichelleDavidson515 pointsBadges:
  • Variable length fields in RPG IV

    Ed is wondering, "If you don't yet use free-format RPG, is there a way to utilize variable length fields in RPG IV?" What do you think? Is it possible? -- Michelle Davidson, editor, Search400.com

    MichelleDavidson515 pointsBadges:
  • What is signature checking?

    Nirmala is trying to figure out what signature checking is and when to use it. Can you offer some advice? -- 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.