FHG Volume: 13 Archives - Page 6 of 7

Bringing Home The Data

April 3, 2013 Michael Sansoterra

In IBM i 7.1 Technology Refresh 4 (TR4), IBM gave SQL developers the ability to insert data into a local database table from a remote DB2 for i database table within the comfort of a single SQL statement. (See my article Copy Data From A Remote DB2 Database Using DB2 For i 7.1 for more info).

With Technology Refresh 5, specifically DB2 for i Group PTF Level 18 or later, you can dynamically create a local table and insert data into it directly from a remote DB2 for i database query using the CREATE TABLE … AS statement.

Recall that

…

Using Incremental IFS Backup To Speed Up Backup Time

March 20, 2013 Hey, Joe

Is there a trick to speeding up AS/400 Integrated File System (IFS) nightly backups? My nightly backups run over 300 minutes and 120 of those minutes are tied to the IFS backup, so it runs into production hours. Here’s the Save (SAV) command I’m using to backup the IFS.

SAV DEV('/QSYS.LIB/TAP01.DEVD') OBJ(('/*') + 
('/QSYS.LIB' *OMIT) ('/QDLS' *OMIT)) + 
SAVACT(*SYNC) ENDOPT(*UNLOAD) + 
UPDHST(*YES) DTACPR(*DEV)

— C

To cut down on IFS backup times, you can modify your backups to perform a full IFS backup once a week and an incremental backup the other nights of the week. Here’s how this works.

…

Tips For Using RDP’s DDS Designer

March 20, 2013 Susan Gantner

In my Guru tip on the DDS Designer in Rational Developer for Power Systems, I showed you the basics of using the DDS Designer to create or maintain screens. A few changes have been made to the DDS Design tool in recent releases of RDP, and I’ve also had a bit more experience with it. So I decided it was time for an update on the topic.

The most obvious change that has happened in recent releases is that the DDS Design perspective can now automatically be opened on a double-click of a DSPF or PRTF source member. You

…

Using SQL Joins With Tree Structures

March 20, 2013 Ted Holt

Note: The code accompanying this article is available for download here.

The reason tree structures are important to me is not that they are so numerous, but that I use them every day. I don’t write programs to process tree structures every day, but many of the programs I have written still run every day. For that reason, I must know fast ways to extract data from tree structures. One such method is the SQL join.

This article is a rewrite of the topic “Efficient Database Retrieval” from my article Recursion and the Alternatives, which I wrote eight

…

Admin Alert: A Checklist For Moving Power i Partitions To A Different Location

March 6, 2013 Joe Hertvik

With corporate buy-outs, company spin-offs, and moving Power i servers to a centralized data center or a managed server provider, many shops are finding that they need to move their Power i partitions to a different network or a cloud provider. To that end, here’s a checklist I put together to help ensure that your Power i partitions can function without issue in a new environment.

Why We Move

There are many reasons you might need a playbook for moving a Power i partition from one location and network to another. Some of the more common situations include:

Company sale

…

When Who Did What

March 6, 2013 Ted Holt

When you create a new database table (physical file), you should include those columns (fields) that are fully functionally dependent on the key fields. I would like to mention some additional columns that you might like to include also.

The columns to which I refer are ones that store creation and change data. For example, you may want to be able to tell who inserted a row (added a record) and who last changed it. Such information may allow you to give a quick answer to a user’s conundrum.

Look at this simple CREATE TABLE statement. Notice the last six

…

Journal Forensics 101

March 6, 2013 Steven Wolk

Note: The code accompanying this article is available for download here.

A good friend of mine, who also happens to be president of our local user’s group, had been encouraging me to present a session at one of their meetings. I resisted for some time, but finally decided this was an exciting prospect. The topic I would choose became clear to me almost immediately. We use journaling in my shop for so many purposes that we simply couldn’t survive without it. I’ve always been very interested in journaling, especially in applications of the technology to forensics and recovery.

It’s

…

Getting Short-Term Maintenance For Your Power i Machine

February 20, 2013 Hey, Joe

I purchased a three-year maintenance contract when I bought my Power7 machine in 2010. The contract runs out in May but I need extended maintenance through July when I’m installing a new machine and returning the old machine to the leasing company. How do I extend my hardware/software maintenance for only two months without having to buy a one-year maintenance contract?

–Jean

This is a fairly common situation and one that IBM provides an out for in their maintenance contracts. Here’s how you can sign a one- or multi-year maintenance contract for your existing machine and then cancel the contract

…

New CL String-Handling Functions

February 20, 2013 Ted Holt

Note: The document accompanying this article is available for download here.

I love it when IBM enhances CL. When I hear of a new feature, my first thought is, “What can I do with this?” My mind has been spinning since Guy Vig first told me about CL’s new string-handling functions a few weeks ago. Let me tell you about these functions and some of the uses for them that have already occurred to me.

First, here are a few facts you need to be aware of:

IBM delivered the new functions in two PTFs: SI49061 and SI48166.

…

Stored Procedure Parameter Defaults And Named Arguments In DB2 For i

February 20, 2013 Michael Sansoterra

Starting with IBM i 7.1 Technology Refresh 5, DB2 for i stored procedure parameters support a default value, and the CALL statement supports named arguments. (DB2 for i Group PTF Level 18 or higher provides this new functionality). These simple and related enhancements can have surprising benefits for code comprehension and code maintenance.

Let’s look at creating a procedure with one or more parameters having a default value:

CREATE PROCEDURE DEV.CREATE_ORDER (
IN @CUSTOMER_ID INT,
IN @ORDER_DATE DATE DEFAULT CURRENT_DATE,
IN @ORDER_ID INTEGER DEFAULT (NEXT VALUE for DATALIB.ORDER_ID_SEQUENCE) ,
IN @ORDER_SOURCE VARCHAR(10) DEFAULT 'WEB') 
LANGUAGE SQL
BEGIN
…
END

…

Previous Articles Next Articles

Search for:

Content archive

The Four Hundred
Four Hundred Stuff
Four Hundred Guru

Content archive

Recent Posts

Subscribe

Pages

Search