IBM added a feature with V2R1M0 that allows the reusing of deleted records in a physical file without a reorganization. Unfortunately, they have put a restriction on this new feature that renders it virtually worthless. You cannot have a file reuse deleted records if the file has any logicals over it that specify FIFO or LIFO ordering for duplicate keys, or if the physical file has a FIFO or LIFO duplicate key ordering.
Since duplicate key ordering requires you to have FIFO or LIFO ordering, the only files available that would allow the reuse of deleted records are those with only unique keys. In my experience, that is not very many files.
Editor's Note: Unique keys cannot be used with most logical files, since you have an almost complete assurance that there will be duplicate keys. Therefore, you cannot reuse deleted records in any physical files that have logical files built on top. How many files is that?
Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.
IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn:
LATEST COMMENTS
MC Press Online