newlands, graham

Hi,

I know most of the people on this list are active on most of the ingres
forums and are very well experienced in ingres especially the likes of
Karl and Marty :-)

Well just to let you know hot of the press is that I've discovered a bug
with ingres on the Windows platform, that I'd like to share. It's to do
with the checkpoint template and CA have acknowledged this as of
yesterday.

You will notice a line in the checkpoint template file :
$II_SYSTEM\ingres\files\cktmpl.def that reads :

WDDD: echo deleting files in location "%D" & del /Q "%D\*.*"

The above command is executed by ingres when doing the "rollfowarddb"
and the idea is that ingres deletes any files in each data location
before restoring the files from the checkpoint. *** this does not
happen ***

The fix we have put in is to have the following in the
$II_SYSTEM\ingres\files\ckcopyd.bat script for the rollforwarddb :

REM delete the necessary files in the location before doing the restore
excluding the .cnf, .rfc and .ali files

REM as these are automatically handled by ingres. IMPORTANT if all files
are selected for deletion

REM in the location then the rollforward will fail as ingres first
renames aaaaaaaa.cnf to

REM aaaaaaaa.rfc so removing any of these files via script will cause
issues with the rollforward

del /Q "%1\*.t*"


************** note the above goes in the section labelled "perform a
full restore" **************

We have also changed the cktmpl.def to simply have :

WDDD: echo deleting files in location "%D"


*** PLEASE NOTE THAT YOU WILL HAVE TO MODIFY YOUR ckcopyt.bat AS WELL IF
YOU ROLLFORWARD DIRECT FROM TAPE ***


Hope this helps anyone running ingres on windows and CA were amazed as I
was that nobody had reported this sooner !!!


Best Regards

Graham T Newlands
IT Consultant
Fujitsu Australia

Address:
Lvl 20, 222 Exhibition St, Melbourne, VIC 3000
Tel:
+61 3 9657 8705
Mobile:
0404 003 104
Fax:
+61 3 9664 6570
Email:
graham.newlands@au.fujitsu.com
Web site:
http://au.fujitsu.com


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@au.fujitsu.com