I raised a case with IBM when I tracked down our crash to a file not
converting properly when we moved from AIX to W2K3.  This file had a
trigger, which we had removed, but even so it did not convert completely.
The result was an unpredictable crash of the session which took a long time
to track down.
 
I am advised by IBM support that currently there is not a way to move
UniVerse files, with Triggers, to another Machine Class as fnuxi does not
support SQL tables.  They do not regard this as being a bug.
 
The application of a Trigger to a standard UniVerse file turns this into a
pseudo SQL Table with a SICA block within the file's header, to store the
trigger information.  The CREATE/DROP TRIGGER commands are updating the
uv/SQL/CATALOG/UV_TABLES and UV_USERS files.
 
They have provided me with a workaround to clear the sica pointer from the
file header, which will allow me to make the changes when moving between
machine classes.
 
I am going to request an enhancement to make this available to other users
without them needing to write additional hacks to get around this situation.
 
This is the second time we have had to move between machine classes within 3
years.  It happens - we need to be able to handle it simply without the
aggravation it has caused us.
 
At the very minimum IBM need to cover this in their documentation.  If they
have I didn't find it.
 
UniVerse 10.1 on Windows 2003
 
Sara Burns
 
Sara Burns (SEB) 
Development Team Leader

Public Trust 
Phone: +64 (04) 474-3841 (DDI) 

Mobile: 027 457 5974
< <mailto:[EMAIL PROTECTED]> mailto:[EMAIL PROTECTED]>

Information contained in this communication is confidential. If you are not
the intended recipient the information should not be used, disclosed, copied
or commercialised. The information is not necessarily the views nor the
official communication of Public Trust. No guarantee or representation is
made that the communication is free of errors, virus or interference.

 
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Reply via email to