Hello,

this might help:

http://community.ingres.com/forum/co...-def-file.html


Jürgen



-------- Original-Nachricht --------
Betreff: [Info-Ingres] Compressed checkpoints under Windows?
Datum: Mon, 3 May 2010 02:07:48 -0700 (PDT)
Von: Gerhard Hofmann <ghof050472 (AT) googlemail (DOT) com>
Antwort an: Ingres and related product discussion forum
<info-ingres (AT) kettleriverconsulting (DOT) com>
Organisation: http://groups.google.com
An: info-ingres (AT) kettleriverconsulting (DOT) com
Newsgruppen: comp.databases.ingres



Hello,
is this possible? How would I have to tweak the cktmpl.def file? Which
compressing programm could be used (7-zip, RAR etc.)?

Regards
Gerhard
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

I agree this is very simple and nifty trick (especially in the Oracle
scenario)....It's always the simple things that work best and then you
think "how didn't I think of that".

We use the tinkering of the cktmpl.def with winzip command line add-on.
This works very well but as someone else mentioned no matter what method
you use test the checkpoint AND the rollforward...


Graham Newlands
Ingres A/P DBA

Fujitsu Australia Limited
825 Bourke Street, Docklands VIC 3008, Australia
graham.newlands (AT) au (DOT) fujitsu.com
au.fujitsu.com

Please consider the environment before printing this email

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Gerhard Hofmann
Sent: Thursday, 6 May 2010 6:43 AM
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: Re: [Info-Ingres] Compressed checkpoints under Windows?

On 5 Mai, 18:06, Ingres Forums <info-ing... (AT) kettleriverconsulting (DOT) com>
wrote:
A very good idea, thanks for this. I activated the NTFS on-the-fly-
compression for II_CHECKPOINT folder and its subfolders and played a
little bit around with it. Execution times for ckpdb and rollforwarddb
are roughly the same and disk space saving in II_CHECPOINT is about 75
percent, very nice...
And best of all, no need to tweak the cktmpl.def file which could easily
"break" something.

Juergen, Dejan, Thomas, Mike, thanks for your various hints!

Regards
Gerhard
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres



This is an email from Fujitsu Australia Limited, ABN 19 001 011 427. It is confidential to the ordinary user of the email address
to which it was addressed and may contain copyright and/or legally privileged information. No one else may read, print, store, copy
or forward all or any of it or its attachments. If you receive this email in error, please return to sender. Thank you.

If you do not wish to receive commercial email messages from Fujitsu Australia Limited, please email unsubscribe (AT) au (DOT) fujitsu.com