HP 3000 Evolution (Order It)

Book review from Alan Yeo's Screenjet.com customer newsletter:

"New HP 3000 Reference Book." Just when you thought that the end must be in sight for new books on the HP 3000. Published just in time for HP World was a new book HP 3000 Evolution. Edited by Bob Green from Robelle, this book is crammed full of new material from many of the leading authorities on the HP 3000, and links to many sources of information. The book has sections on Tuning your HP 3000, Planning a Homesteading Strategy, and a wealth of information on Migration Planning and Techniques.

Another book review from Chuck Ciesinski of Hughes Network Systems writes:

I have read the book, "HP3000 Evolution", which I got at HPWorld 2003 in Atlanta, and I rank it as a must have for every HP 3000 system manager today and beyond October 31st, 2003.

The latest publication from Robelle is HP 3000 Evolution, edited by Bob Green of Robelle, from articles written by Robelle, by The 3000 Newswire, and by experts in the HP 3000 field: Chris Edler, Paul Edwards, Marius Schild, Neil Armstrong, John Burke, Alan Wyman and Alan Heter, Stan Sieler and Gavin Scott, Ken Robertson, Eugene Volokh, Alfredo Rego, Fred White, Steve Hammond, Wayne Boyer, Alan Yeo, Gunnar Fredlund, Michael Marxmeier, Terry O'Brien, Aaron Holmes, Dave Lo, and Glenn Cole.

Order your copy on-line for US$25. All you need is a credit card number. Copies are printed and shipped on demand.

Order Your Copy of "HP 3000 Evolution" Today

Contents, Links and Corrections

Introduction

Migrate, Homestead, or Evolve?

Book site: http://www.robelle.com/books

The 3000 Newswire: http://www.3000newswire.com

Qedit home page: http://www.qedit.com

Suprtool home page: http://www.suprtool.com

Early History of the HP 3000: The Rise, Fall and Rise of the HP 3000

 Birth of IMAGE: http://www.adager.com/TechnicalPapersHTML/BirthOfImage.html 
 Bob Green's 3000 History: http://www.robelle.com/smugbook/classic.html

Deja Vue: The Spectrum Project

(no links)

Alternative Resources for Homesteading

Why Homestead?

 http://www.robelle.com/consultants.html
 http://www.openmpe.org/mpeconsultant.htm
 http://www.adager.com/HpResources8.html

Software Support: Gilles Schipper

Suppliers of MPE Support: http://www.openmpe.org/mpephone.htm

http://www.gsainc.com

Software Support: Allegro Consultants

 http://www.allegro.com

Software Support: Beechglen

http://www.beechglen.com/

Hardware Suppport, Upgrades and Spare Parts

Used equipment: http://www.phoenix3000.com/ Other brokers: http://www.openmpe.org/mpebokers.htm http://www.triolet.com/HPVend/hpvend.html http://www.cypress-tech.com/ http://www.hptraderonline.com http://www.bluelineservices.com/home.htm

Ramusage utility: http://www.allegro.com/software/hp3000/allegro.html#RAMUSAGE http://www.robelle.com/tips/ftp.html

Memory vendors: http://www.triolet.com/HPVend/hpvend.html http://shop.kingston.com/ http://www.icsgroup.com http://www.ebay.com

http://www.pricewatch.com/

Wipedisk utility: http://www.allegro.com/products/hp3000/wipedisk.html

Hardware support: http://www.openmpe.org/mpehardware.htm http://www.triolet.com/HPVend/hpvend213.html#HRDMTC http://atserve.com/ http://www.icsgroup.com/maintenance.htm http://www.terixcomputer.com/

Connecting Modern SCSI Devices to the 3000

http://www.burke-consulting.com Seagate drives: http://www.seagate.com/support/kb/disc/howto/interpret_model.html

SCSI standards: http://www.paralan.com/glos.html http://www.adaptec.com http://www.scsi-planet.com/scsi-definitions/ http://www.granitedigital.com

http://www.compgeeks.com http://www.dirtcheapdrives.com http://www.crossroads.com

Disagreement From Hewlett-Packard:
In reply to the SCSI chapter, Jim Hawkins of HP wrote a column titled "Non-HP disks can prompt risks" in the July 2003 issue of The 3000 Newswire,
His argument is that HP has found many SCSI disk drives to be unusable in the multi-user server environment of MPE, either because they don't fully comply with the SCSI standard or they don't comply with additional requirements that HP makes of suppliers:
"Before HP receives a device from a manufacturer, we provide to them a 'supplementary' HP Parallel SCSI Device Specificiton" (this document is only available to vendors supplying product to HP, so please don't request this document). This specification clearly states which of the myriad SCSI features HP server systems really, truly depend upon.
It seems that this manual is another one that should go on the wish list of OpenMPE for documentation that HP should distribute before 2006.
Jim Hawkins is Lead I/O Engineer in the HP MPE/iX R&D lab and has worked for HP for over 17 years in both the R&D lab and the support organization.

Homesteading By Tax Regulation

(no links)

Homesteading Checklist

An expanded version of this chapter by Paul Edwards is available on our web site as Homesteading: Plan for the Future.

 Hewlett-Packard: http://www.hp.com
 Manuals: http://docs.hp.com
 The 3000 Newswire: http://www.3000newswire.com
 HP3000-L:	listserv@raven.utc.edu
 Jazz: http://jazz.external.hp.com
 INTEREX: http://www.interex.org
 OpenMPE: http://www.openmpe.org
 3rd Party Sites: http://www.robelle.com 
 http://www.adager.com

A 3000 Emulator: Interview with Mark Klein

(no links)

HP 3000 Tune Up

HP 3000 Reference Information

OpenMPE: http://www.openmpe.org 3000 manuals: http://docs.hp.com Most useful 3000 manuals: http://www.burke-consulting.com/indexhpdocs.htm http://www.robelle.com/library/manuals http://www.lund.com/support http://www.adager.com http://www.bardmark.com/site/downloads/downloads.html http://www.interex.org HPWorld proceedings: http://www.interex.org/conference/hpworld2002/proceedings/index.html http://www.interex.org/conference/hpworld2001/proceedings/index.html http://www.interex.org/conference/hpworld2000/proceedings/index.html

http://www.3000newswire.com http://www.3kworld.com MPE/iX System Admin Handbook: http://diercks.net/jon

TurboIMAGE: http://beechglen.com/pub/imagefaq.txt http://www.robelle.com/library/tutorials/pdfs/imgprog.pdf http://www.robelle.com/library/tutorials/pdfs/imgperf.pdf http://www.adager.com/TechnicalPapers.html

3000-L Mailing list: http://raven.utc.edu/archives/hp3000-l.html http://www.3kworld.com/message.asp?appMode=threadList&mbo_PK=318 http://raven.utc.edu/archives/index.html http://www.techgroupmd.com/TGU%20-%20CyberCafe.htm

3000 FAQS http://www.3k.com/faq/hpfaqi.html http://qwebs.qss.com/faq3k.html http://www.robelle.com/library/smugbook

http://jazz.external.hp.com http://jazz.external.hp.com/papers/SolSymposium_03/NetworkingTools.htm http://jazz.external.hp.com/papers/SolSymposium_03/erictools.tar http://www.burke-consulting.com/best_of/best_of_TOC.htm http://www.3000newswire.com/subscribers/TechHeads.html http://allegro.com/papers/learnmpe.html http://www.robelle.com/library http://allegro.com/papers http://www.adager.com/TechnicalPapers.html http://www.interex.org/enterprise/hp3000.html

News: http://www.3000newswire.com http://www.robelle.com http://www.hp3000links.com/whatnew1.htm http://www.3kworld.com http://www.adager.com/OffCampusHP3000.html http://www.robelle.com/support/hp3000.html

Vendor listing: http://www.triolet.com/HPVend/hpvend.html

Using Old Technology for New Problems

 Importing data into Excel: http://www.robelle.com/tips/st-export-excel.html#import

So Your HP 3000 Is Hung. Now What?

 Dump tape:
 http://www.allegro.com/papers/dump.html
 http://jazz.external.hp.com/papers/SolSymposium_03/MPESysAnalysis.htm
 http://docs.hp.com/mpeix/onlinedocs/32650-90901/32650-90901.html

Quick and Dirty Solutions with CI Programming

 http://jazz.external.hp.com/papers/SolSymposium_03/CIProgramming_files/frame.html
 http://jazz.external.hp.com/papers/SolSymposium_03/CIProgramming.ppt
 http://www.robelle.com/ftp/papers/progci.txt
 http://www.adager.com/VeSoft/MpeProgramming.html
 http://www.adager.com/VeSoft/ProgrammingXL.html

Corrections from Jeff Vance, the ultimate export on CI, which are included in the second revised edition:
1. In the section titled "Getting Data into and out of Files", the PRINT command is highlighted as a way of reading records from a file(especially reading past the first record). Although this is correct, I'd like to point out that using a message file can be 4++ times faster. And for larger files, a method using alternate entry points yields to a performance boost of 31 times or better! These IO techniques are described in my CI programming paper on Jazz.
2. Under the "Simulting Arrays" section, there is a CAVEAT USER paragraph which, if I understand the author, is completely incorrect. Interactive vs. scripting CI usage is almost always identical. The type of differences that are visible are cases where the user is prompted to confirm an action when they are interactive, e.g. the PURGEGROUP command, which assumes a "YES" in a batch-like environment. So where the author writes, "This only works within command files. If you try to do this interactively, the expression evaluation on the Setvar command is performed for the part of the command line after the variable name" this is incorrect. Variable arrays can be created interactively, in a batch job, or in a script.
3. As of the MPE/iX 5.5 base release, CI string variables can be up to 1024 characters long, which is greater than the 256 byte limit cited in the article.

File Security: Protection in a High-Risk Environment

 http://jazz.external.hp.com/papers/SolSymposium_03/homestead-security-027-rev2.htm
 http://jazz.external.hp.com/papers/SolSymposium_03/homestead-security-027-rev2.ppt
 http://jazz.external.hp.com/papers/SolSymposium_03/NWSecurity.htm
 http://jazz.external.hp.com/papers/SolSymposium_03/NWSecurity.ppt

Flexing Underused Muscles

 http://www.robelle.com/tips/mpe.html#jobq
 http://www.burke-consulting.com/best_of/best_of_TOC.htm
 http://www.burke-consulting.com/best_of/6.2.htm
 http://www.burke-consulting.com/best_of/6.29.htm
 http://www.robelle.com/tips/remote-dba.html
 ftp://ftp.telamon.com/dist/
 http://jazz.external.hp.com/src/
 http://www.robelle.com/tips/url-wget.html

Do Migrating Secondaries Give You Migraines?

 http://www.adager.com/TechnicalPapers.html
 http://www.robelle.com/smugbook/howmessy.html

Buffing Your IMAGE

 http://www.adager.com/TechnicalPapersHTML/IntegerKeysFinalChapter.html
 http://www.adager.com/TechnicalPapersHTML/ThreeBears.html

Dynamic Dataset Expansion

 http://www.adager.com/TechnicalPapers.html

Keeping HP 3000s on the Road

(no links)

Migrating a 3000 Application

ISV journeys down migration road

 http://www.interex.org/conference/hpworld2002/proceedings

Migration Resources

http://www.3kworld.com/newsroom.asp?sit_PK=67&appmode=itemDetail&news_pk=3856 http://jazz.external.hp.com/src/scripts/siu/ http://jazz.external.hp.com/papers/SolSymposium_03/ssmigperf_kc.htm http://jazz.external.hp.com/papers/SolSymposium_03/ssmigperf_kc.ppt

HP White Paper on TurboIMAGE and databases http://www.hp.com/products1/evolution/e3000/download/5981-3062EN.pdf

HP White Paper on Programming Languages http://www.hp.com/products1/evolution/e3000/download/5981-3061EN.pdf

HP White Paper on Compilers and User Interfaces http://www.hp.com/products1/evolution/e3000/download/5981-3061EN.pdf

HP White Paper on MPE Commands and Networks: http://www.hp.com/products1/evolution/e3000/download/5981-3064EN.pdf

More HP White Papers: http://www.hp.com/products1/evolution/e3000/info_library/whitepapers.html

http://www.hpclients.com/desktv/2698_01-22-02/e3000_transitions_e.htm http://hpmsweb1.com/content/250_257/04-23-02.htm http://hpmsweb1.com/content/310_365/05-21-02.htm http://www.hpbroadband.com/program.cfm?key=e3000pt4 http://www.hpbroadband.com/program.cfm?key=e30005 http://www.hpbroadband.com/program.cfm?key=e3000mod6

Unix Haters Handbook: http://research.microsoft.com/~daniel/unix-haters.html http://safari.oreilly.com/?XmlId=0-596-00330-7 http://www.amazon.com/exec/obidos/ISBN=0201563177 http://www.robelle.com/tips/unix.html http://www.smga3000.com/papers/UnixvMPE.htm http://www.3kworld.com/newsroom.asp?sit_PK=&appmode=itemDetail&news_pk=3979 http://www.3kworld.com/newsroom.asp?sit_PK=&appmode=itemDetail&news_pk=3981 http://www.geek-girl.com/unix.html http://www.geek-girl.com/Unixhelp/ http://www.ugu.com/sui/ugu/warp.ugu http://docs.hp.com/ http://www.robelle.com/abouthpux.html http://hpux.cs.utah.edu/ http://www.faqs.org/faqs/hp/hpux-faq/ http://www.dutchworks.nl/htbin/hpsysadmin http://www.tek-tips.com/gthreadminder.cfm/lev2/3/lev3/20/pid/51 http://www.insecure.org/sploits_hpux.html http://www.software.hp.com/ http://invent9k.external.hp.com/~csy/sysadmin.cgi http://invent9k.external.hp.com/~csy/cmds.cgi http://invent9k.external.hp.com/~csy/intr.cgi http://www.suprtool.com/ux http://www.robelle.com/products/qedit/moreinfo-ux.html http://eloquence.marxmeier.com/ http://www.screenjet.com http://www.adtech.com http://www.denkart.com/vianova/vn3000.htm http://www.transoft.com

A New COBOL Compiler

 KOBOL: http://www.thekompany.com
 Intrins/iX: http://www.allegro.com

COBOL Migration: What You Can Do Now

 COBOL manual: http://www.docs.hp.com

A New User Interface to Replace VPLUS

 http://www.screenjet.com
 White paper: 
 http://207.21.244.161/download_mig.asp?SesEnc=&page=downloadlive

From VPLUS to Web Application

 http://www.ciotech.com

ScreenJet VPLUS to ACUCOBOL-GT and AcuBench

 http://www.screenjet.com

A New Database to Replace IMAGE

 Relational databases: http://www.adager.com/VeSoft/RelationalAndIMAGE.html
 TurboIMAGE manual: http://docs.hp.com/mpeix/onlinedocs/30391-90012/30391-90012.html
 HP COBOL manual: http://docs.hp.com/cgi-bin/doc3k/B3150090013.11820/1
 COBOL data definitions: http://docs.hp.com/cgi-bin/doc3k/B3150090013.11820/52
 Suprtool manuals: http://robelle.com/library/manuals/

Introduction to Eloquence

 Eloquence migration: http://eloquence.marxmeier.com/hp3k/migration.html
 Eloquence: http://eloquence.marxmeier.com/
 Developer: http://www.marxmeier.com

Eloquence: HP 3000 IMAGE Migration

This is a new chapter by Michael Marxmeier. Read the PDF file version.

http://www.marxmeier.com
http://eloquence.marxmeier.com/

The TurboIMAGE DataTypes

(no links)

Quick Start Oracle for the TurboIMAGE Developer

 http://www.disc.com
 Oracle forum/book: http://asktom.oracle.com

Transform TurboIMAGE Data to Oracle

Oracle 7 manuals: http://www.kbs.twi.tudelft.nl/Documentation/Database/Oracle7/DOC/dcommon/oin/ Oracle 8 manuals: http://www-rohan.sdsu.edu/doc/oracle/ Oracle 9 manuals: http://www.dbresources.com/oramanuals.php ( Underground Oracle: http://www.orafaq.com/

Update: Migrating Empty Date Values From TurboIMAGE

When I gave my paper "Transforming TurboIMAGE Databases" at HPWorld in Atlanta, there was a very good question from the audience

"I have fields like SHIPDATE, which begin life with a blank value and are updated when the actual ship date is known. How do I move these datasets into SQL tables, where the SHIPDATE field will presumably be of type 'Date' and where blank will be detected as an invalid value?"

Excellent question! Click the link above for the answer.

SQL Server And TurboIMAGE Data

AcuCOBOL Precompilers: http://www.acucorp.com/Solutions/access3.html http://www.acucorp.com/Solutions/acusql.html

SQL Server Resources: http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp http://www.sqlteam.com http://www.sqldts.com/dblinks.asp?nav=1,2,30,1 http://www.mssqlcity.com/ http://www.sqldts.com/ http://www.sqldts.com/catlist.asp?nav=1,6,6,2 http://www.mssqlcity.com/Links.htm

Consider a Free Open-Source Database

http://www.mysql.com or http://www.sourceforge.net mySQL LOAD_DATA: http://www.mysql.com/doc/L/O/LOAD_DATA.html http://www.postgresql.org http://www.sapdb.org

Converting Multi-Line Notes

Dave Lo: http://davelo.net http://www.interactivetools.com

Introduction to Perl for 3000 Users: http://www.robelle.com/tips/perl.html

Cleaning Your Data

(no links)

A New Operating System to Replace MPE