Subject: [os2genau_digest] No. 600
From: Digest <deadmail>
To: "OS/2GenAu Digest"<deadmail>
Date: Thu, 24 Apr 2003 00:04:02 EST-10EDT,10,-1,0,7200,3,-1,0,7200,3600

**************************************************
Wednesday 23 April 2003
 Number  600
**************************************************

Subjects for today
 
1  Re:  DB/2 files : Ed Durrant <edurrant at bigpond dot net dot au>
2  Re:  DB/2 files : Ed Durrant <edurrant at bigpond dot net dot au>
3  Re:  The smoke escaped : Ed Durrant <edurrant at bigpond dot net dot au>
4  Re:  The smoke escaped : Gavin Miller" <drumextreme at impulse dot net dot au>
5  Re:  DB/2 files : Wayne Armstrong" <wdarmst at bacchus dot com dot au>
6  Re:  The smoke escaped : bob <bob at fots dot org dot au>
7  Re:  The smoke escaped : bob <bob at fots dot org dot au>
8   Hlpmgr2.log? : John Angelico" <talldad at kepl dot com dot au>
9  Re:  The smoke escaped : Gavin Miller" <drumextreme at impulse dot net dot au>
10  Re:  The smoke escaped : bob <bob at fots dot org dot au>
11  Re:  The smoke escaped : Voytek Eymont <voytek at sbt dot net dot au>
12  Re:  The smoke escaped : bob <bob at fots dot org dot au>
13  Re:  The smoke escaped : Ed Durrant <edurrant at bigpond dot net dot au>
14  Re:  Hlpmgr2.log? : Ed Durrant <edurrant at bigpond dot net dot au>
15  Re:  The smoke escaped : Ed Durrant <edurrant at bigpond dot net dot au>
16  Re:  The smoke escaped : bob <bob at fots dot org dot au>
17  Re:  Hlpmgr2.log? : bob <bob at fots dot org dot au>
18  Re:  Hlpmgr2.log? : John Angelico" <talldad at kepl dot com dot au>
19  Re:  The smoke escaped : peter" <peterp at tac dot com dot au>

**= Email   1 ==========================**

Date:  Wed, 23 Apr 2003 06:44:00 +1000
From:  Ed Durrant <edurrant at bigpond dot net dot au>
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 <edurrant at bigpond dot net dot au>
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 <edurrant at bigpond dot net dot au>
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" <drumextreme at impulse dot net dot au>
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" <wdarmst at bacchus dot com dot au>
Subject:  Re:  DB/2 files

** Reply to message from Ed Durrant <edurrant at bigpond dot net dot au> 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 <bob at fots dot org dot au>
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 <bob at fots dot org dot au>
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" <talldad at kepl dot com dot au>
Subject:   Hlpmgr2.log?

Hi to my two favourite lists!

Can anyone help me to understand why I have the <subj> 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" <drumextreme at impulse dot net dot au>
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 <bob at fots dot org dot au>
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 <voytek at sbt dot net dot au>
Subject:  Re:  The smoke escaped

** Reply to note from bob <bob at fots dot org dot au> 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 <bob at fots dot org dot au>
Subject:  Re:  The smoke escaped

On Thu, 24 Apr 2003 12:12 am, you wrote:
> ** Reply to note from bob <bob at fots dot org dot au> 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 <edurrant at bigpond dot net dot au>
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 <edurrant at bigpond dot net dot au>
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 <subj> 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 <edurrant at bigpond dot net dot au>
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 <bob at fots dot org dot au>
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 <bob at fots dot org dot au>
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 <subj> 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" <talldad at kepl dot com dot au>
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 <subj> 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" <peterp at tac dot com dot au>
Subject:  Re:  The smoke escaped

** Reply to message from bob <bob at fots dot org dot au> 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
----------------------------------------------------------------------------------