January 2006

• January 31, 2006 31 Jan'06

  iSeries upgrades embrace Windows

  As part of a major revamp of the iSeries -- which includes a name change to the System i5 -- IBM is making it easier to integrate the iSeries platform with Windows. A smart move by Big Blue, say analysts, suggesting that anything that brings the ...  Continue Reading

• January 30, 2006 30 Jan'06

  IBM names new iSeries marketing VP

  IBM taps its SMB chief Elaine Lennox to replace Peter Bingaman. The leadership change comes at crucial juncture, but execs voice confidence.  Continue Reading

• January 30, 2006 30 Jan'06

  Preparing for an iSeries upgrade

  This guide describes how to prepare for an iSeries upgrade. Whether you're upgrading from V4R2 to V4R5 or to V5R4, the information in this guide may be useful to help you avoid some common upgrade-related issues.  Continue Reading

• January 30, 2006 30 Jan'06

  Open-list API provides crucial information on activation groups -- part 2

  One of the many Open List APIs gives programs the ability to determine which activation groups are active in the job and allows the program to retrieve the activation groups' attributes. It can also provide the same information on activation...  Continue Reading

• January 27, 2006 27 Jan'06

  Answer and delete in the QSYSOPR message queue

  One Search400.com member writes, "What controls a user's ability to be allowed to answer and (especially) delete messages in the QSYSOPR message queue? How can we restrict them?" Security expert Carol Woodbury explains.  Continue Reading

• January 27, 2006 27 Jan'06

  Retrieve SQL (RTVSQL) source statement

  Search400.com member Jean-Paul Lamontre discusses the SQL Visual Explain tool, which comes with iSeries Navigator. Jean-Paul finds this tool very handy to improve the performance of SQL statements. In this tip he shares why he feels it would be ...  Continue Reading

• January 27, 2006 27 Jan'06

  Profile without ALLOBJ authority to view joblog

  One Search400.com member asks, "We have the need to allow a support profile that does not have *ALLOBJ authority to view a production user profile's joblog. We have found the way to address this via Skyview/Ops Navigator/Host Applications/Customize...  Continue Reading

• January 25, 2006 25 Jan'06

  Working with ODBC and dates

  One Search400.com member writes, "I use Business Objects and Viewpoint to access DB2/400 via ODBC. Since the new year some PTF's were applied (I don't know which ones) and now any SQL that converts strings to dates fails. The iSeries is managed ...  Continue Reading

• January 25, 2006 25 Jan'06

  Run command on a PC

  One Search400.com member writes, "I want to start a .Wav file from my iSeries. It works with the STRPCCMD but the length of the parameter is limited to 123, which is too small. Are there any alternatives?" PC/Windows connectivity expert Shahar Mor ...  Continue Reading

• January 25, 2006 25 Jan'06

  iSeries marketing exec resigns

  Peter Bingaman, marketing vice president for the iSeries, resigned from his position last week. Hailed as a marketing hero, Bingaman had been instrumental in the iSeries' marketing makeover.  Continue Reading

• January 23, 2006 23 Jan'06

  Keeping programmers honest -- part 1

  If you are like most iSeries security officers, you probably cut your teeth in the IT field by doing some programming. It might even be that you still get involved in programming and your role as security officer is a part-time role. So, you have ...  Continue Reading

• January 22, 2006 22 Jan'06

  How to compare spooled files

  Search400.com member Phillip Smith provides his methond to compare spooled files  Continue Reading

• January 20, 2006 20 Jan'06

  What is a Decimal Data Error?

  One Search400.com member writes, "Can you please tell me what a Decimal Data error is, and what is the scenario in which it is received?" Search400.com's application development expert John Blenkinsop explains.  Continue Reading

• January 20, 2006 20 Jan'06

  Working with the SAVSYS command

  We have an old model F35 AS/400. I have been advised to do a SAVSYS. Do I need to shut down the sub-systems prior to doing save system?  Continue Reading

• January 20, 2006 20 Jan'06

  Oracle further unwraps Fusion, nips at SAP

  Oracle Corp. executives said the company is at the halfway point in building a services-enabled Fusion application suite as the battle of words between Oracle and SAP continues.  Continue Reading

• January 19, 2006 19 Jan'06

  Command to manage longer addresses

  One user wirtes, "I am working with an iSeries application that uses the commands: strpccmd/strpco to redirect the user to a Web page on a local server. I would like the application to redirect to a different Web page but the address is too long ...  Continue Reading

• January 19, 2006 19 Jan'06

  CPF3291 error on a rstlib command

  On a rstlib command (from a sav lib created tape) I get a CPF3291 error when the restore is to a second library (development restore of production data). All of the data and logical files are contained in the same directory, though the logicals ...  Continue Reading

• January 19, 2006 19 Jan'06

  Who signed on to the production system?

  One Search400.com member writes, "I want to know who signs on to our production system during non-supported hours and report on this (for SOX reasons).Simply manually scanning through the History log is not enough any longer. How can I automate this...  Continue Reading

• January 19, 2006 19 Jan'06

  Problems with print screen function on iSeries CA since upgrade

  One Search400.com user writes, "I am having an issue using the print screen function on iSeries Client Access since we upgraded it to 5.7." iSeries printing/output expert Chip Milosch offers some advice.  Continue Reading

• January 19, 2006 19 Jan'06

  Finding users with passwords the same as the profile

  One Search400.com member writes, "We have eight iSeries systems, with the same user ID's on them, plus our clients user ID's. We need to check to see if user profiles are EQ to user passwords. Would IBM API's QSYRUPWD and qsycupwd be used for this...  Continue Reading