We are trying to access a database on our old system using QUERY and it is asking for a password. I have done a LISTF ,-3 on the database, but there is no lockword listed (which I assumed would be the password). Where do I find the password assigned to a database?
John Burke replied
Assuming you do not have access to the original schema and you want to know what the password is, not just access the database, then sign on as the creator in the group with the database, run DBUTIL.PUB.SYS and issue the command SHOW databasename PASSWORDS.
Mike Church and Joseph Dolliver added
If you just want to access the database, log on to the system as the database creator and, when asked for password, put in a “;” semicolon and hit return.
Why is my system clock running slow? Our HP 3000 loses about one minute per day.
Bob J. replies
One possibility was addressed by a firmware update. HP's text from a CPU firmware (41.33) update mentions:
“System clock (software maintained) loses time. The time loss occurs randomly and may result in large losses over a relatively short time period. Occurrences of the above problem have only been reported against the HP 3000 979KS/x00 (Mohawk) systems. Software applications that perform frequent calling of a PDC routine, PDC_CHASSIS, affect the amount of time lost by the system clock. Your hardware support company should be happy to update for you.”
[Editor's note: as this question was posed a few years ago, today's hardware support company will be an independent one. We've always recommended Pivital Solutions.]
Tongue firmly in cheek, Wirt Atmar noted
My first guess would be relativistic time dilation effects as viewed by an observer at a distance due to the fact that you’re now migrating off of the HP 3000 at an ever accelerating rate. My second guess, although it’s less likely, would be that your machine has found out that it’s about ready to be abandoned and is so depressed that it simply can no longer work at normal speed. We’ve certainly kept this information from our HP 3000s. There’s just no reason that they need to know this kind of thing at the moment.
And in the same vein, Bernie Sherrard added this, referring to HP's promised end of 3000 support on Dec. 31, 2006
Look at the bright side. At a loss of one minute per day, you won’t get to 12/31/2006, until 2 AM on 1/2/2007. So, you will get 26 hours of support beyond everyone else.