We have a COBOL application running on power6 , i 570 server with OS as V5R4
We have a COBOL application running on power6 V5R4, will upgrading OS to V6R1 benefit in terms of performance.

Answer Question   |  January 15, 2011  1:09 PM
AS/400, COBOL, V5R4, V6R1

Management Central running but cannot open.
Management Central is running but when I try to open it I get “An unhandled win32 exception occurred in cwbunnav.exe” It opens a Visual Studio Just-In-Time debugger. Selecting Yes to debug doesn’t work because the source is unavailable. Selecting No (and when exiting the debugger), the iNavigator terminates. So far every thing I’ve read leads [...]

Answer Question   |  January 31, 2011  5:36 PM
Debugger, iSeries Access, Management Central, V6R1, Visual Studio

Is message queue QSYSMSG still viable at releases V6R1 and above
With all the new technology is message queue QSYSMSG still viable at releases V6R1 and above

Answer Question   |  January 9, 2011  8:24 PM
iSeries, iSeries message queues, iSeries V6R1, QSYS, V6R1

Edit mask on date field in AS/400
Is there some trick that would allow using an edit mask on a true date field? I need to display a date in *USA format and allow the user to edit the date. If I convert the date to a numeric field, I can use the EDTWRD and EDTMSK keywords to accomplish what I want. [...]

Answer Question   |  January 6, 2011  6:21 PM
AS/400 command functions, AS/400 commands, OS/400, V6R1

List objects owned by named user in iSeries
How can I list all objects on a system owned by named user. (I am trying to track where a certain user has made changes in the past (years ago..), and I want this to be part of the analysis. I would like to have a parameter ‘OWNER’ on the DSPOBJD command, but its not there. System [...]

Answer Question   |  April 28, 2011  7:53 AM
DSPOBJD, IBM, Object authority, System i, V6R1

Find missing numbers with SQL
In a large logfile I have records containing the field INVNO (invoice-number). The lowest and highest values are easy to find, BUT it looks like some numbers in between are not there. Anyone got a trick with SQL, which can tell which numbers are missing within the numberrange (step 1) ?

Answer Question   |  December 14, 2010  2:35 PM
AS/400 SQL, SQL, SQL Server, V6R1

System i Access Windows 7 V6R1 install error 1713
I’m installing System i Access for Windows V6 R1 M0 on a Windows 7 machine and I’m getting the “Error 1713…cannot install one of its required products” error.  I’ve tried deleting the installed objects, cleaning the registry, rebooting and installing.  No Luck. This is the first problem in about 100 identical installs.  What am I [...]

Answer Question   |  July 19, 2011  8:45 PM
Client Access, iSeries error messages, iSeries V6R1, System i, System i Access, V6R1, Windows 7

Tracking IPDS printing on AS400
How do I pass on user information to the printer from the AS/400? That is, if I wanted to embed user and job information on the IPDS job and send it to the printer, how would I go about it? 

Answer Question   |  November 12, 2010  12:27 PM
AS/400, IBM, IPDS, iSeries, V6R1

Why aren’t the Crystal Reports indexes showing since loading V6R1?
I use Crystal reports via ODBC to the iSeries and have for years.  After loading V6R1 when I go in to create a report, the files aren’t showing any indexes like they used to.  The used to show indexes based on the file definitions but now there are no indexes showing. I have even pointed [...]

Answer Question   |  November 8, 2010  6:45 PM
Crystal Reports, iSeries, ODBC, OS/400, V6R1

Storage of AS/400 user profile
when I DSPUSRPRF myprofile,it shows the storage like 16M. After I delete all the objects owned by myprofile (using WRKOBJOWN myprofile to check the objects),it still shows 16M. how can I do to down size the storage of myprofile? many thanks for helping me.

Answer Question   |  October 14, 2010  1:55 PM
AS/400 storage, AS/400 user administration, AS/400 user profiles, V6R1

Does V6R1 Support previous versions
Does V6R1 still support older versions of IBM OS/400. E.g. does it still support IBM System36, IBM System 38, File naming conventions (TU.TABLE),relative files of System36 etc

Answer Question   |  September 14, 2010  2:41 PM
AS/400 interoperability, iSeries interoperability, OS/400, S/36, S38, V6R1

Enherit column attributes when ALTERing column
I have this: 1. A field-reference table (fieldref): CREATE TABLE mylib/fieldref ( A CHAR (10) NOT NULL WITH DEFAULT, B CHAR (10) NOT NULL WITH DEFAULT, C DECIMAL (7 , 5) NOT NULL WITH DEFAULT, PRIMARY KEY (A)) 2. A data table (myfile) created on the basis of the above fieldref table: CREATE TABLE mylib/myfile [...]

Answer Question   |  August 30, 2010  8:21 PM
AS/400 DB2, AS/400 tables, OSV6R1, SQL, V6R1

Will the SQL performance improvements in V6R1 affect QUERY?
Will the SQL performance improvements in V6R1 affect QUERY? Does QUERY use SQL under the hood?

Answer Question   |  September 17, 2010  3:13 PM
i5, SQL performance, SQL queries, SQL Query, V6R1

Problem with iSeries printer output
Hi All, We have installed Iseries Access for Windows V6R1M0. But when we go to printer Output, it’s very slow when we click any file, very slow, it’s seem suspend. Please tell me how to slove that.

Answer Question   |  August 27, 2010  4:35 AM
iSeries Access, iSeries printer output, iSeries printing, iSeries V6R1, V6R1

TCP1A77 error
Hi, i do update my OS40 to V6.1 but since i have problem with my STRTCPSVR command when my system is in restricted stat. i got all the time the msgid TCP1A77 (TCP1A77 STRTCPSVR completed successfully; however errors occurred) so my backup counld’t start without activiting manually the IP interface needed to communicate with the [...]

Answer Question   |  August 15, 2010  6:58 PM
OS/400, OS/400 Upgrades, TCP1A77, V6R1

unlock an IFS file
I have an IFS file that the system thinks is being used by another user. I tried “check in” & RLSIFSLCK to no avail. How can I make this file available to use. As a work-around, I had the user open as read-only and save as another name, but I would like to use the [...]

Answer Question   |  August 6, 2010  5:00 PM
i5/OS, IFS, IFS File Lock, iSeries, Locks, V6R1

IBM Disk Space Report
On the report the total % of disk space is 86% which includes all unused space. Where is the other 14% which totals over 400Gb on our system ? IBM replied that it’s because the data is in use at the time and the data gathering should be run in a dedicated system. I find [...]

Answer Question   |  July 13, 2010  11:40 AM
Disk space, V6R1

Robot/SCHEDULE passing scheduled run date and time
Is there a way to get the [strong]scheduled[/strong] run date and time passed into the called program as parameters.  for example, it is supposed to run at 23:00 on 6/15, but due to a power outage, it is now 01:15 on 6/16.  Is there a way to setup the “Reserved Variables” so that the program receives the [...]

Answer Question   |  September 14, 2011  12:48 PM
iSeries, iSeries V6R1, V6R1

*MGTCOL objects
Can i change a *MGTCOL object into a PF so that later i want to send the data to a text file?

Answer Question   |  June 9, 2010  11:14 AM
AS/400 Management, AS/400 objects, V6R1

Dataarea as a variable
Is it possible to address a dataarea by name from a variable field ? The idea is to keep last used report-no by dept/company in dataareas – one for each dept/company. Multiple dataareas (all *dec 7 0) are needed as report-pgm can print for several different departments/companies.  Dept-id shall be passed as a parm when report-program [...]

Answer Question   |  June 8, 2010  3:27 PM
Data Area, RPGLE, V6R1