From: Digest To: "OS/2GenAu Digest" Date: Thu, 24 Apr 2003 00:04:02 EST-10EDT,10,-1,0,7200,3,-1,0,7200,3600 Subject: [os2genau_digest] No. 600 Reply-To: X-List-Unsubscribe: www.os2site.com/list/ ************************************************** Wednesday 23 April 2003 Number 600 ************************************************** Subjects for today 1 Re: DB/2 files : Ed Durrant 2 Re: DB/2 files : Ed Durrant 3 Re: The smoke escaped : Ed Durrant 4 Re: The smoke escaped : Gavin Miller" 5 Re: DB/2 files : Wayne Armstrong" 6 Re: The smoke escaped : bob 7 Re: The smoke escaped : bob 8 Hlpmgr2.log? : John Angelico" 9 Re: The smoke escaped : Gavin Miller" 10 Re: The smoke escaped : bob 11 Re: The smoke escaped : Voytek Eymont 12 Re: The smoke escaped : bob 13 Re: The smoke escaped : Ed Durrant 14 Re: Hlpmgr2.log? : Ed Durrant 15 Re: The smoke escaped : Ed Durrant 16 Re: The smoke escaped : bob 17 Re: Hlpmgr2.log? : bob 18 Re: Hlpmgr2.log? : John Angelico" 19 Re: The smoke escaped : peter" **= Email 1 ==========================** Date: Wed, 23 Apr 2003 06:44:00 +1000 From: Ed Durrant Subject: Re: DB/2 files Thanks Chris, We ended up doing the export / import method as I was suspecious that there may be some problem with a straight copy. Both machines use the same name (I'm moving everthing to a temporary system, then wiping and rebuilding the original system, going to WSeB CP2 FP3 from basic Warp Server, adding RAM and 100Mb/s NIC and then transferring everything back). We're presently at the import of exported data on the temporary machine stage at the moment. I was hoping then to image this machines partitions up and then transfer them back onto the production system. If I could do this step without export/import it would have saved some time. Cheers/2 Ed. "Chris Graham [WarpSpeed]" wrote: > On Mon, 21 Apr 2003 21:48:56 +1000 (EST), John Angelico wrote: > > >On Mon, 21 Apr 2003 19:47:02 +1000, Ed Durrant wrote: > > > >>Can anyone tell me if it's possible to simply copy a complete OS/2 DB2 > >>(v 5.x) database from one machine to another without having to export > >>(or backup) and re-import the data ? > >> > >>Avoiding the export/import step will save me quite some time as we're > >>talking of around 10-12 GB of data ! > > DEFINATELY NOT! > > NEITHER WILL A BACKUP/RESTORE. > > DB2 embeds the machine name into several places within the code. > > Just export it and be done with it. Do it in IFX format and it it > relatively quick. > > The fastest way is to import the data with no indexes/keys, then recreate > the keys&indexes once the data is in the DB. > > >Several considerations: > >Export/import is not required but backup/restore advisable because copy may > >copy additional unnecessary files, and the process is risky unless you are > >sure about all of DB/2's references including possible internal references. > > > >Try copying a small database file by file. If that works then try the > >larger one. But beware that it may fail although NOT necessarily > >immediately. Therefore, I would recommend backup/restore: the resulting > >backup file will compress well. > > > >The other alternative is to simply reference the database across the > >network. Is this possible? If so, all copying and backing up/restoring is > >avoided, at the cost of slight performance loss across the network. > > In simple words: If it is worth doing, then it is worth doing properly. > > -Chris > > WarpSpeed Computers - The Graham Utilities for OS/2. > Voice: +61-3-9307-0611 PO Box 212 FidoNet: 3:632/344 > FAX: +61-3-9307-0633 Brunswick Internet: chrisg at warpspeed dot com dot au > BBS: +61-3-9307-0644 VIC 3056 CompuServe: 100250,1645 > 300-28,800 N,8,1 ANSI Australia Web Page: > http://www.warpspeed dot com dot au > > ---------------------------------------------------------------------------------- **= Email 2 ==========================** Date: Wed, 23 Apr 2003 06:46:42 +1000 From: Ed Durrant Subject: Re: DB/2 files The tables are between 1 and 3 GB in size, we have basically exported every table in two parts, even with this, the log files fill. As I said, we're going to need to clear the log files between each table import. Ed. "Chris Graham [WarpSpeed]" wrote: > Drop the commit count to something a little more reasonble. I had to work > with about 6Gb of data and it wasn't that bad. Simply do a table at a > time. > > Just make sure that you run RUNSTATS on the tables once complete. It > should run like a cut cat. > ---------------------------------------------------------------------------------- **= Email 3 ==========================** Date: Wed, 23 Apr 2003 06:51:58 +1000 From: Ed Durrant Subject: Re: The smoke escaped Unfortunately finding (I presume 56k ?) external serial, no-win modems is a hunt around today. If you live in the Sydney area, I'd suggest you try the Sunday computer market at North Rocks AMP shopping centre as there are usually a few external modems there. Otherwise, you'll need to go store to store in your search. "some" Win modems, using specific Lucent chipsets do have drivers for OS/2 and OS/2 does theoretically support USB modems (if you are paying for Software Choice or have bought eCS to get the drivers). I have never used a USB modem however. Cheers/2 Ed. bob wrote: > The smoke escaped from my modem wall plug so I'm back to using the ol' 14.4 > :(. > > Anyone have a pointer to a good deal on a serial (not USB) external non > win-modem? Something that I can stuff on top on the gateway box in the > cupboard and forget about? > > thnx. > > -- > Like the ski resort of girls looking for husbands and husbands looking > for girls, the situation is not as symmetrical as it might seem. > -- Alan McKay > > ---------------------------------------------------------------------------------- **= Email 4 ==========================** Date: Wed, 23 Apr 2003 08:12:08 +1000 (EST) From: "Gavin Miller" Subject: Re: The smoke escaped Try Dick Smith. I bought a Spirit Magnum 56K data/fax for $98. Works a treat although don't expect the default init string to work. Cheers G ---------------------------------------------------------------------------------- **= Email 5 ==========================** Date: Wed, 23 Apr 2003 08:22:08 +1000 From: "Wayne Armstrong" Subject: Re: DB/2 files ** Reply to message from Ed Durrant on Wed, 23 Apr 2003 06:46:42 +1000 Hi, the commitcount is an option on the import startment, basically, db2 import from fred.ixf of ixf commitcount 100000 insert into bacchus.test. This gets db2 too commit changes after commitcount rows have been inserted which frees up the logs. Bigger commitcounts run faster. Smaller commitcounts need less logs. The database backup and restore would also work for you (assuming the same codepage is set in config.sys). You will take a db2backup before you destroy the old machine anyway (just in case) won't you ? The advantage of a backup/restore scenario is :- All view's, triggers, functions etc come along with it which they don't with an export and import and it's a lot quicker. You may need to do a redirected restore if you want to change the containerspace layout on the target machine. Here is a script I use regularly to recreate a clients db2 database on our test machine. (Note I'm renaming the database in the restore also from horudb to hornil) db2 restore database horudb from j:\ to i: into hornil newlogpath i:\hornillogs redirect db2 set tablespace containers for 0 using (path "i:\hornil0") db2 set tablespace containers for 1 using (path "i:\hornil1") db2 set tablespace containers for 2 using (path "i:\hornil2") db2 restore db horudb continue db2 rollforward database hornil stop You can allways clean up the database on the new faster machine by running reorgs and runstats once it's over there. Reorging large tables will take about as long as importing em :). Regards, Wayne Wayne Armstrong, Bacchus Management Systems http://www.bacchus dot com dot au > The tables are between 1 and 3 GB in size, we have basically exported every table in two > parts, even with this, the log files fill. As I said, we're going to need to clear the log > files between each table import. > > Ed. > > "Chris Graham [WarpSpeed]" wrote: > > > Drop the commit count to something a little more reasonble. I had to work > > with about 6Gb of data and it wasn't that bad. Simply do a table at a > > time. > > > > Just make sure that you run RUNSTATS on the tables once complete. It > > should run like a cut cat. > > > > ---------------------------------------------------------------------------------- **= Email 6 ==========================** Date: Wed, 23 Apr 2003 08:58:14 +0800 From: bob Subject: Re: The smoke escaped On Wed, 23 Apr 2003 06:12 am, you wrote: > Try Dick Smith. I bought a Spirit Magnum 56K data/fax for $98. Works a > treat although don't expect the default init string to work. Hmm... Spirit Magnim appears to be $88 at the moment at DSE. Thanks for the pointer, I wouldnt have thought of DSE otherwiae. What init string do you use then? > Cheers > G -- Death, when unnecessary, is a tragic thing. -- Flint, "Requiem for Methuselah", stardate 5843.7 ---------------------------------------------------------------------------------- **= Email 7 ==========================** Date: Wed, 23 Apr 2003 09:06:22 +0800 From: bob Subject: Re: The smoke escaped On Wed, 23 Apr 2003 04:51 am, you wrote: > Unfortunately finding (I presume 56k ?) external serial, no-win modems is > a hunt around today. As I am finding :) > If you live in the Sydney area, I'd suggest you try the Sunday computer > market at North Rocks AMP shopping centre as there are usually a few > external modems there. Otherwise, you'll need to go store to store in > your search. Perth, should be similar somewhere around though. If nothing else there is always "the quoka" - like the trading post > "some" Win modems, using specific Lucent chipsets do have drivers for > OS/2 and OS/2 does theoretically support USB modems (if you are paying > for Software Choice or have bought eCS to get the drivers). I have never > used a USB modem however. Given the gateway's lacklustre specs I would prefer to have CPU cycles devoted to doing gateway stuff, not having to push bits down the serial :) USB? We don' need no USB! In fact... We don' got no USB! :) > Cheers/2 Thanks for the feedback. > Ed. -- Support your right to arm bears!! ---------------------------------------------------------------------------------- **= Email 8 ==========================** Date: Wed, 23 Apr 2003 12:34:53 +1000 (EST) From: "John Angelico" Subject: Hlpmgr2.log? Hi to my two favourite lists! Can anyone help me to understand why I have the file at 105Mb(!!) in the root of my boot drive? It grows steadily and has now consumed all the free space on C: I have moved it temporarily to another drive but I can't open it with a text editor to view its contents either - probably too big. Furthermore, can anyone who knows, help me to switch it off without damaging something else, please? Best regards John Angelico OS/2 SIG talldad at melbpc dot org dot au or talldad at kepl dot com dot au -------------------------------------- PMTagline v1.50 - Copyright, 1996-1997, Stephen Berg and John Angelico .... Do not disturb. Already disturbed enough. ---------------------------------------------------------------------------------- **= Email 9 ==========================** Date: Wed, 23 Apr 2003 15:29:52 +1000 (EST) From: "Gavin Miller" Subject: Re: The smoke escaped On Wed, 23 Apr 2003 08:58:14 +0800, bob wrote: >What init string do you use then? Simple little ATX3L1 which I'm pretty sure breaks a few Aust. telcomunication codes but throwing anything else in seemed to prevent dialing. The default string from the Windows driver didn't work with DOIP and I don't have Injoy to test it other wise. Cheers G ---------------------------------------------------------------------------------- **= Email 10 ==========================** Date: Wed, 23 Apr 2003 13:51:28 +0800 From: bob Subject: Re: The smoke escaped On Wed, 23 Apr 2003 01:29 pm, you wrote: > On Wed, 23 Apr 2003 08:58:14 +0800, bob wrote: > >What init string do you use then? > > Simple little ATX3L1 which I'm pretty sure breaks a few Aust. > telcomunication codes but throwing anything else in seemed to prevent > dialing. > > The default string from the Windows driver didn't work with DOIP and I > don't have Injoy to test it other wise. Amazing the number of modems that need X3 in .au - even the ones built (haha) in .au. I've found a really good deal on a netcomm MEGA-I 2003 ($85) so I think I've found what I'm looking for. Thanks for the advice all :). > Cheers > G -- When I left you, I was but the pupil. Now, I am the master. - Darth Vader ---------------------------------------------------------------------------------- **= Email 11 ==========================** Date: Wed, 23 Apr 2003 16:12:52 From: Voytek Eymont Subject: Re: The smoke escaped ** Reply to note from bob Wed, 23 Apr 2003 13:51:28 +0800 > Amazing the number of modems that need X3 in .au - even the ones built > (haha) in .au. the trick is, of course, to set them to country=australia, though, that seems to be different from modem to modem how to achieve Voytek Eymont ---------------------------------------------------------------------------------- **= Email 12 ==========================** Date: Wed, 23 Apr 2003 14:19:56 +0800 From: bob Subject: Re: The smoke escaped On Thu, 24 Apr 2003 12:12 am, you wrote: > ** Reply to note from bob Wed, 23 Apr 2003 13:51:28 > +0800 > > > Amazing the number of modems that need X3 in .au - even the ones built > > (haha) in .au. > > the trick is, of course, to set them to country=australia, though, that > seems to be different from modem to modem how to achieve I thought setting X3 _was_ setting country=australia :) > Voytek Eymont -- Misery no longer loves company. Nowadays it insists on it. -- Russell Baker ---------------------------------------------------------------------------------- **= Email 13 ==========================** Date: Wed, 23 Apr 2003 16:55:35 +1000 From: Ed Durrant Subject: Re: The smoke escaped Or Harvey Norman (if they're in your state). I was in the one in Chatswoord (NSW) today and they have a couple that look as if they could be "real" (ie non-Win) modems. Ed. Gavin Miller wrote: > Try Dick Smith. I bought a Spirit Magnum 56K data/fax for $98. Works a treat although > don't expect the default init string to work. > > Cheers > G > > Gavin Miller wrote: > Try Dick Smith. I bought a Spirit Magnum 56K data/fax for $98. Works a treat although > don't expect the default init string to work. > > Cheers > G > > ---------------------------------------------------------------------------------- **= Email 14 ==========================** Date: Wed, 23 Apr 2003 16:57:53 +1000 From: Ed Durrant Subject: Re: Hlpmgr2.log? Not part of a standard OS/2 build - it must be from some other application you have installed (perhaps a compiler ?). Ed. John Angelico wrote: > Hi to my two favourite lists! > > Can anyone help me to understand why I have the file at 105Mb(!!) in > the root of my boot drive? > > It grows steadily and has now consumed all the free space on C: > > I have moved it temporarily to another drive but I can't open it with a > text editor to view its contents either - probably too big. > > Furthermore, can anyone who knows, help me to switch it off without > damaging something else, please? > > Best regards > John Angelico > OS/2 SIG > talldad at melbpc dot org dot au or talldad at kepl dot com dot au > -------------------------------------- > > PMTagline v1.50 - Copyright, 1996-1997, Stephen Berg and John Angelico > ... Do not disturb. Already disturbed enough. > ---------------------------------------------------------------------------------- **= Email 15 ==========================** Date: Wed, 23 Apr 2003 16:59:01 +1000 From: Ed Durrant Subject: Re: The smoke escaped Strip the init strings from the windows "driver" file. - windows modem drivers are not real drivers, rather setup.ini type flat files. Ed. bob wrote: > On Wed, 23 Apr 2003 06:12 am, you wrote: > > Try Dick Smith. I bought a Spirit Magnum 56K data/fax for $98. Works a > > treat although don't expect the default init string to work. > > Hmm... Spirit Magnim appears to be $88 at the moment at DSE. Thanks for the > pointer, I wouldnt have thought of DSE otherwiae. > > What init string do you use then? > > > Cheers > > G > > -- > Death, when unnecessary, is a tragic thing. > -- Flint, "Requiem for Methuselah", stardate 5843.7 > > ---------------------------------------------------------------------------------- **= Email 16 ==========================** Date: Wed, 23 Apr 2003 15:04:08 +0800 From: bob Subject: Re: The smoke escaped On Wed, 23 Apr 2003 02:59 pm, you wrote: > Strip the init strings from the windows "driver" file. - windows modem > drivers are not real drivers, rather setup.ini type flat files. Well... depending if they're win-modems or not :). In general I find that X3 is usually about all thats needed to add to an init to get a modem to work ok. Further effort than that is dependent on how bad the copper to the exchange is. > Ed. -- <<<<< EVACUATION ROUTE <<<<< ---------------------------------------------------------------------------------- **= Email 17 ==========================** Date: Wed, 23 Apr 2003 15:25:43 +0800 From: bob Subject: Re: Hlpmgr2.log? On Wed, 23 Apr 2003 10:34 am, you wrote: > Hi to my two favourite lists! > > Can anyone help me to understand why I have the file at 105Mb(!!) > in the root of my boot drive? It would appear to be part of NewView. From the .os2ecs dot net site... NewView version 2.3.19 By Aaron Lawrence - Posted on 04-23-2003 NewView now completely* replaces the OS/2 help system, including application online help (helpmgr.dll). When you press F1 in an application, you will now get NewView and you can as usual, select and copy from the window. If you have problems with the online help mode, please supply the hlpmgr2.log from your boot drive (e.g. c:\hlpmgr2.log). There are known problems with the OS/2 master help index and tutorial (see readme.txt). .... No idea why its so big though. Maybe the readme... :) What version are you using? http://hobbes.nmsu.edu/pub/os2/apps/misc/newview2_3_19.zip seems to be the latest. History says stuff about fixing mem leaks... > It grows steadily and has now consumed all the free space on C: > > I have moved it temporarily to another drive but I can't open it with a > text editor to view its contents either - probably too big. > > Furthermore, can anyone who knows, help me to switch it off without > damaging something else, please? > > > Best regards > John Angelico -- He who renders warfare fatal to all engaged in it will be the greatest benefactor the world has yet known. -- Sir Richard Burton ---------------------------------------------------------------------------------- **= Email 18 ==========================** Date: Wed, 23 Apr 2003 17:27:10 +1000 (EST) From: "John Angelico" Subject: Re: Hlpmgr2.log? On Wed, 23 Apr 2003 16:57:53 +1000, Ed Durrant wrote: Hi Ed. >Not part of a standard OS/2 build - it must be from some other application you have >installed (perhaps a compiler ?). Yes, thanks. Has meantime been identified on the POSSI list as part of NewView, the replacement for View.exe. I will write the author about it, but I also have a new version to install, so hopefully he is aware of its behaviour and can fix it. Best regards John Angelico OS/2 SIG talldad at melbpc dot org dot au or talldad at kepl dot com dot au ____________________________________________ >Ed. > >John Angelico wrote: > >> Hi to my two favourite lists! >> >> Can anyone help me to understand why I have the file at 105Mb(!!) in >> the root of my boot drive? >> >> It grows steadily and has now consumed all the free space on C: ---------------------------------------------------------------------------------- **= Email 19 ==========================** Date: Wed, 23 Apr 2003 18:20:39 +1000 From: "peter" Subject: Re: The smoke escaped ** Reply to message from bob on Tue, 22 Apr 2003 19:45:34 +0800 Hi, I have a Jetstream v.3 external modem from Maestro. No problems, simple to use with Injoy. Best of all made in Australia. If memory serves $148 in Dick Smith, but try http://www.maestro dot com dot au Regards, Peter Pigott created with Polarbar Mailer v.124c (build 1476), using IBM Java V.1.3.1 on eComStation v. 1.03 18:20:38 23 Apr 2003 ----------------------------------------------------------------------------------