The iSeries blog - A Search400.com blog

The iSeries blog:

 

A Search400.com blog


The latest iSeries opinions on systems management, programming, Web development, recovery, security and more.

Security breaches: Are you prepared?

Everywhere you look you see stories in the news about security breaches — stolen computers, lost data, bank account information that becomes public knowledge, what’s next? It really makes me wonder if we’re doing enough to secure our data. I recently came across a good article “Finding Needles of Data in an Unstructured Haystack” if security breaches are keeping you up at night, you might want to check it out. It’s a good read.

SOA insights from CIOs and CTOs

Is SOA on the top of your priority list?  You may have heard that “Almost everything you once knew about business computing has changed with SOA.” According to insights from CIOs and CTOs collected by the Object Management Group’s (OMG) SOA Consortium.  

System i printing: Configuring an ASCII printer

If you have a XXXX ASCII printer on your network and you’re wondering how to make this printer available to your iSeries users, check out this new tip by System i printing expert Chip Milosch. Chip does a great job of walking you through the process.

First autonomic DB2 optimization tool for IBM System i

Centerfield Technology, Inc. announced the development of the first autonomic tool designed to optimize DB2 for i5/OS. AutoDBA, the name of the new component, provides expert DB2 advice and options to automatically implement that advice. The first release will focus on fully optimizing database indices (DDS logical files and SQL indices); with the objective of making SQL and RPG programs that process large amounts of data much more efficient. 

IBM to meet upset WDSc Shops half-way on features?

I just came across this article by Timothy Prickett Morgan. It looks like IBM is going to try to appease WDSc shops — although IBM won’t say just how it is going to accomplish that. Any ideas? Or is this just another way to keep the feathers from flying?

So we lost six months worth of work, big deal!

Search400.com member Gary shares his blunder:  

Back in the early days of my IT career our small firm of four people did not have its own hardware, so we did all of our work at our client sites. At one point, we needed to reload all of our software on a customer’s System/36.  Knowing that we had faithfully backed up all of our software on a regular basis, we deleted all of our program libraries and tried to restore from the backup diskettes. We discovered that the diskettes did not contain any of our libraries, only the system library. We tried the previous set of backups. Same results. What we soon discovered was that the command we had been using “BACKUP xxxxxxxx” didn’t take any parameters and was used just to back up the system library. We finally found a set of backups from 6 months prior that contained our libraries. What saved us was the fact that since we didn’t have our own hardware, we always kept a current printed version of the compile listings. We recompiled all of the programs from the backup, printed the compile listings and then four people spent a full week comparing the two compiles for each program by laying them on top of each other at a window and bringing the source current. Needless to say, we never made that mistake again.  

Do you have a blunder to share? 

Where did you say those backup tapes are kept

Search400.com member David shares his blunder:

Years ago, in my first AS/400 job, the company I worked for had only one box to use for both production and development. (I cringe when I think about that, now.)  When we were developing, we would just copy the production data into our personal libraries so that we could do our testing.

So, the pattern went:

- Copy production data to personal library (using CPYF)

- Run my program over the data in my personal library

- Inspect the results and make program changes accordingly

- Clear the file in my personal library (CLRPFM)

- Go back to the first step and start again

As you can probably already imagine, during one testing cycle, I accidentally cleared the PRODUCTION table instead of the copy in my library. When my index finger was a millimeter away from the Enter key, I realized what I was about to do. But, it was too late to stop.Within a couple minutes, the end-users were calling me, asking, “What happened to my pricing quotes?”I turned to my manager (who sat in a desk directly behind me), and I told him what just happened. He smiled, he chucked, and he showed me where the backup tapes were stored.We restored the table’s data from the previous night, but that day’s data was gone.I don’t think we ever told the users why one day’s worth of pricing quotes needed to be re-entered.

Do you have a blunder to share?  

The lights are on, but no one is home

Search400.com member “Bud” shares his blunder:  

While recently putting the latest CUME & Hiper Group on our model 810, I experienced a failure for some PTF’s to apply for iSeries Access.  So, I downloaded what were the missing concurrent PTFs from Fix Central and tried to apply them.  It didn’t work, and at that point I couldn’t figure out what was going on so contacted IBM Support — on Saturday.  The contact guy sorted out what was going on, had me re-apply one of them and bounce the box.  Now, understand that at the time I was doing this I was talking to him (as in not paying attention to what I was doing).  He told me if I had any more issues to call him back.  So, for 45 minutes I’m staring at the front panel and everything looks normal to me (Normal mode: running on B side) except for a blinking light to the immediate right of the start button. 

In my defense, I was handed the job of software administration two years ago and have never performed any manual functions on the box. Anyway, to figure what the blinking light meant, I hunted it down at the infocenter (no mean feat) and read that it meant the “system has power.”  Also, since I’m in a room with lots of little fans spinning in lots of little boxes, the noise level is, well its noisy in there!  I finally caved in and called the guy back.  He said, “Um, your system isn’t powered up.”  But I see an illuminated panel and there’s power to the box.  “Yeah, but that doesn’t mean it’s powered up, it just means there’s power to the box,” he added. I felt like such an idiot.  Then he added, “Don’t feel bad, you wouldn’t believe the number of calls we receive on this.”

Do you have a blunder to share?

Applied Logic Enhances Data and Backup Encryption Solution

Enhancements allow the easy encryption of iSeries save files, libraries, or individual physical files for backup or transport. Applied Logic Corporation, the developer of AS/400 productivity and security software, announces new enhancements to Pro/Encrypt– the software solution for encrypting selected data that was released earlier this year. Without relying on any specialized hardware, Pro/Encrypt allows iSeries or System i data to be easily encrypted and decrypted using Advanced EncryptionStandard (AES) 128, 192 or 256-bit encryption. Strong encryption provided by Pro/Encrypt addresses potential liability issues and meets or exceeds applicable regulatory privacy standards.

Why is everyone taking a break at the same time – Oh no!

Search400.com member Frank shares his blunder:

“I was a newbie contract programmer at an electric company.  My
desk was in their computer room, which had a large glass window.  I could
look out at 30 or so customer service employees diligently working in their
cubicles.  The amount of data that they needed to save on their nightly
backups outgrew their tape drives unattended abilities.  They wanted me to
save half the data on Monday, Wednesday and Friday and the other half on
Tuesday and Thursday.  I was being especially careful, because I had to test
my CL program, which put their system in a restricted state.  After
completing the programming, I was able to relax a little.  The final piece
of the project was to put my CL into the Job Scheduler.  Afterwards, I
looked out the window and noticed one of the employees standing up from his
desk — then a second and a third.  That’s odd, everybody’s taking a break at
the same time?  Starting to feel a little panic, I looked down at my
terminal screen and it was exactly as I had last seen it.  Then it hit me,
I’m at the console!   I just put the system into a restricted state in the
middle of their workday!  I’ll never forget that the default date and time
on the scheduler is the current date and time.”

Do you have a blunder to share?