Have you considered dynamic files? Stu Glancy Asset Management Outsourcing, Inc. Senior Analyst/DBA 770-792-3907
> Hi all! > > We have HP unix: > 1) HP-UX l1000 B.11.00 U 9000/800 534706547 unlimited-user license > > 2) UniVerse: > RELLEVEL > 001 X > 002 9.5.2.6 > 003 INFORMATION > 004 INFORMATION.FORMAT > 005 9.5.2.6.r8 > > > 3) GLOBUS banking system G12.2.06 > > ----- > There are some files which are greater 300 Mb and which are still > growing... > We use separation = 8 (the best separation for HP-UX) or = 16 if records > are greater than 4000 bytes. > > If records are less than 4000 it's no problem to use RESIZE operator > but in the case they are greater than 4000 RESIZE takes more than 3 > hours. > How to make RESIZE work faster? > > ----- > Which is the best way to count modulo & separation? > > > Thanks in advance. > Dmitry Zhirov > INTERPROMBANK > Moscow > > твд > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users > -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users