Solid software
for HP Servers
Robelle Headlines   July 2005

Highlights from our recent on-line customer news. The links
and full articles are available at www.robelle.com/news

Whats Up DOCumentation


HP3000-L: Last PA-RISC Chip

The result of the genius of PA-RISC is still with us as the last PA-RISC chip just debuted and marks the end of an era that will be talked about for years to come... by Eric Sand. Click link above for a story on the last chip.

HP 3000 Community Booth at HP World

Once again we are helping with an HP 3000 Community booth at the HP World in San Francisco, Aug 14-18. The expo booth provides a place for 3000 users to rest their feet, chat with other 3000 sites, and use the Internet with their laptops.

Staying, Migrating and Surviving

More on IMAGE Logging

Last time we talked about the basics of enabling and using transaction logging with TurboIMAGE. Ths time we examine logging from data protection point of view, examining the issue of "broken chains" and logical data consistency. Click the link above for the full article.

Catchlog

Catchlog is a utility program from the Jazz web site that reports from TurboIMAGE log files. From this 3000-L posting.

Ron Ranieri and Ecometry Consulting

"Ron Ranieri is pleased to announce his relocation to Asheville, NC and the formation of RJR Consulting Group. Ron was the Founder of Ransoft Corp, an Ecometry Alliance Member since 1994. The Ransoft team proposed, designed, and implemented hundreds of successful solutions for a majority of Ecometry Users." Ron writes that "It seems that a majority of the larger Ecometry clients have pushed back the migration to open-systems. ... Ecometry has announced that they will continue to support customers on MPE through 2008, that changed from the original 2006 deadline."

Qedit Tips

Converting a Quad Script to Qedit

If you are moving from MPE to HP-UX, you may find yourself looking for a replacement for the Quad editor on MPE. For example, here is a question received by technical support:

I have just one last job that I need to convert from Quad to Qedit, and I'm having a little trouble. I'm going to paste the code for quad and explain what it's doing and hopefully you can send me back some working Qedit code.

:DATA !quad
t dmovltag
d a i :-:(25/25)
c 16/25 t : -1000: a
c 26/27 t :GL: a
c 36/39 t :PTFE: a
c 40/55 t :OVERLIMIT CHARGE: a
k dmvsaovl
e

 

We will start with the delete line. The code deletes all instances of "-' in column 25/25. It only deletes the '-'. The next set of changes appears to be adding verbage to the columns specified. The verbage is in between ':' and ':'. Let me know if you can help me with this. Thanks.

 

Answer: Most Quad jobs can be converted to Qedit, and this one is no exception. Here is the same task done in Qedit:

 
qedit
t dmovltag
c 25/25 "" "-"(25/25)
c 16/25 : -1000: @
c 26/27 :GL: @
c 36/39 :PTFE: @
c 40/55 :OVERLIMIT CHARGE: @
k dmvsaovl
e
 

Notice that the text, keep and exit commands are identical. The c (change) command is almost the same (remove the "t:" and change the "a" to "@" --all lines). The only tricky bit is the d (delete with column option), which is converted to a change command in Qedit (c 25/25 "" "-"(25/25) removes column 25 in all lines that have a dash in column 25 -- if you want remove column 25 in all lines, use c 25/25 "" @).

 

Suprtool Tips

Here Comes Suprtool Version 4.9

Suprtool provides fast access to your data on the HP e3000 and HP-UX. With Suprtool, you can perform many necessary DP functions easily, with just a few simple commands. We are getting ready to release a production update to Suprtool, so we thought it would be good to review the changes.

Suprtool users will receive version 4.9 on their regular anniversary date, but the changes are also available in a pre-release version 4.8.12 if you would like to try them right now.

For Both the MPE Version 4.9 and the HP-UX Version 4.9:

 

$Clean Function and Clean Command. These now have the ability to replace a character to be cleaned with null or nothing. If you set the cleanchar as being:

 

>set cleanchar "<null>"
 

Suprtool will remove the character specified in the clean command and effectively shift the text to the left and blank out the portion at the end.

 

$Number Function. The $number had a bug whereby it would add on two zeroes and or bad data if the input number did not have a decimal point. We have fixed the bug so that the number function no longer adds the two digits on the end in error. However, some users worked around this issue by doing the following:

>extract target=$truncate($number(conv-field)/ 100)
 

Since some users, used this work around, the fix to the $number function will then return incorrect results. Therefore, we added the set numbug command to have Suprtool revert from the correct behaviour to continue to have the bug. By default, Suprtool will just convert the number and not add on the data at the end, however, if you have used the work around then you can add the command:

 
>set numbug on

 

to the script directly or globally in your suprmgr file.

 

Suprtool 4.9 for HP-UX - the following apply only to HP-UX:

 

Oracle Integers

 

Suprtool by default maps certain numeric fields into packed-decimal data types when they have more than one decimal place:

 

Precision

Decimal Places

Suprtool Data-Type

None

Any

8-byte IEEE

1-4

Zero

2-byte Integer

5-9

Zero

4-byte Integer

1-9

Non-zero

Packed-decimal

10-27

Any

Packed-decimal

28-38

Any

8-byte IEEE

 

The new setting, Set Oracle Integer On, changes the Suprtool format from packed-decimal to Integer based on the size of the Number:

 

Precision

Decimal Places

Suprtool Data-Type

1-4

Any

2-byte Integer

5-9

Any

4-byte Integer

10-27

Any

8-byte Integer

 

Output=input

 

Suprtool now supports the Output=input command, whereby Suprtool sorts a file onto itself. This is one of the last features of MPE Suprtool that was missing in HP-UX Suprtool. It allows you to sort a large file without requiring the disk space for both an input and output copy at the same time.

 

Oracle Dynamic Load

 

We have further revised the Oracle Dynamic Load to do the following:
1) Attempt to load libclntsh.sl using the dynamic path.
2) Attempt to load libclntsh.so using the dynamic path feature.
3) Manually load $ORACLE_HOME/lib32/libclntsh.sl

 

Suprtool now dynamically loads all of the Oracle routines that it needs at startup. This insures that Suprtool is using calls only for your version of Oracle and provides a more stable environment.

 

If Suprtool fails to load the Oracle library, you will see the message:

 

Warning: Your oracle library could not be loaded.
 

This means that any reference to Oracle calls will not function. If you do not have the Oracle option enabled in Suprtool you will not see the errors.

 

Eloquence Dynamic Load

 

Previously, Suprtool would attempt to load the Eloquence libraries and report an error message if the libraries were not loaded. This is no longer the default behaviour. Suprtool will try to load the libraries function, however Suprtool will not report an error by default. To check if your libraries were loaded you can run Suprtool with the -lw option:

./suprtool lw
 

Oracle Connections. Due to changes in Oracle Security, we have re-written all of the code to connect to databases to use more up to date OCI functions. By default, Suprtool will now use this new method of connecting. This version also improves the parsing of the open command, allowing for 30 characters each for the username, password and dbname. This also allows for connection to databases on other servers.

 

>Open Oracle username/password@dbname
 

Set Oracle OpenFix On. Set Oracle OpenFix forces Suprtool to use the olog call, when connecting to Oracle databases. This option should no longer be necessary, now that the default is to use the new connection method.

Set Oracle OpenOld On Set Oracle OpenOld forces Suprtool to use the orlon call, when connecting to Oracle databases. This should only be used if connection to Oracle 7 databases.

 

Table Command. The Table command is now capable of reading files greater than 4Gb. The MPE version of Suprtool already does this.

 

Bugs Corrected in Suprtool 4.9. On HP-UX, Table was not releasing memory-mapped space properly. This may have been the cause behind a number of weird problems over the last couple of years. Suprlink's Join command would not build the output file large enough if the input file flimit was significantly smaller than the Link file. This was only on MPE, since there is not such thing as a file limit on HP-UX.