Check UDT_SPLIT_POLICY in the current release notes. It avoids an unneeded split if a record is re-written and has not changed size. It may apply to your situation.
Regards JayJay Sent from my iPad On 12 Jul 2013, at 17:51, Susan Lynch <[email protected]> wrote: > Cindy, when some of our customers began having problems with dynamic > files, I spent several months working after hours experimenting with > dynamic files and doing hex dumps to see what precisely was happening. > > I would be glad to provide you with a copy of the documentation that I > wrote up for our clients as a result of that research, if you contact me > offline. > > Unfortunately, there is no one-size-fits-all response to your question - > you will need to look at your record sizes and block sizes, but my > write-up will give you the under-the-hood version of how it all works, and > you can do the analysis from there. > > Susan Lynch > [email protected] > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Cinda Goff > Sent: Friday, July 12, 2013 12:35 PM > To: [email protected] > Subject: [U2] UniData Dynamic File Splitting Question > > I work with the North Carolina Community College System which supports the > 58 NC colleges. We have an unusual dynamic file issue at a couple of the > colleges and am hoping someone could provide some insight/direction. > > OS - Solaris 10 > UniData version 7.2.5 (have upgraded a couple of times in the past from > 6.1 and 7.1) Colleges have been running Ellucian's Colleague software > since 2001 > > The problems do not seem to be occurring in all dynamic files but where > there are issues, there are more than 100 files affected. From timestamps > in some of the files, we can see that this has been going on for several > years but we are unaware of the issue until the files have split into so > many parts that the application can no longer open enough files to > read/write the files. Database tools do not show these files as > undersized or in overflow2. Guide will show you the many parts if you > know what to look for but it is not obvious that the file is fragmented. > > When we found the issue at the first college we opened a call with > Ellucian and was told to resize the files. We had a call to Rocket > opened and unfortunately didn't get much further. The Rocket support > analyst looked at udtdiags for us and did not find anything out of the > ordinary. Rocket identified a couple of potential dynamic file issues at > our UniData version and suggested that we upgraded to UniData 7.3. One > of the identified issues seemed to apply but it did not explain all > issues. We are looking at the UniData upgrade but we likely will still > need to address the current file issues. > > We started resizing files and the files were compressed as expected but > soon began splitting again. To 'fix' the files now, we are manually > recreating the files, copying data to new files, renaming everything and > rebuilding any indices. Long and tedious process but the file seem to > behave better, at least so far. > > Below is a listing of one of the main application files and all its parts. > Many of the files have many more parts that the listing below. The > splitting occurs with dat, over and idx with files some files having many > of one part while other have many of all. If anyone has any insight into > how/why the files split this way and suggestion on how to correct and > prevent it in the future, I would very much like to hear your ideas. > > Thanks for your input and suggestions. > Cinda Goff > > sun2:/datatel/coll18/production/apphome/DATA/DATA_P/PERSON>165-$ ls -al > total 533958 > drwxrwx--- 2 datatel users 1536 Jun 26 12:42 . > drwxrwx--- 269 datatel users 13824 Feb 18 10:24 .. > -rw-rw---- 1 datatel users 6292480 Jul 1 12:57 dat001 > -rw-rw---- 1 datatel users 152743936 Jul 1 12:56 idx001 > -rw-rw-rw- 1 gmoore users 4096 Aug 12 2011 idx002 > -rw-rw-rw- 1 gmoore users 4096 Aug 12 2011 idx003 > -rw-rw-rw- 1 ijackson users 4096 Aug 12 2011 idx004 > -rw-rw-rw- 1 gmoore users 4096 Aug 12 2011 idx005 > -rw-rw-rw- 1 sbarnes users 4096 Aug 12 2011 idx006 > -rw-rw-rw- 1 whardwic users 4096 Nov 5 2011 idx007 > -rw-rw-rw- 1 jjacobs users 4096 Nov 5 2011 idx008 > -rw-rw-rw- 1 jlevister users 4096 Nov 5 2011 idx009 > -rw-rw-rw- 1 rcox users 4096 Nov 5 2011 idx010 > -rw-rw-rw- 1 gmoore users 4096 Nov 5 2011 idx011 > -rw-rw-rw- 1 jjacobs users 4096 Nov 5 2011 idx012 > -rw-rw-rw- 1 tbozeman users 4096 Nov 5 2011 idx013 > -rw-rw-rw- 1 pperry users 4096 Nov 5 2011 idx014 > -rw-rw-rw- 1 kconner users 4096 Nov 5 2011 idx015 > -rw-rw-rw- 1 pperry users 4096 Nov 5 2011 idx016 > -rw-rw-rw- 1 gmoore users 4096 Nov 5 2011 idx017 > -rw-rw-rw- 1 sbarnes users 4096 Nov 5 2011 idx018 > -rw-rw-rw- 1 jjacobs users 4096 Nov 5 2011 idx019 > -rw-rw---- 1 datatel users 113200128 Jul 1 12:57 over001 > -rw-rw---- 1 whardwic users 19456 Jun 20 08:26 over002 > -rw-rw---- 1 ijackson users 18432 May 16 08:04 over003 > -rw-rw---- 1 gmoore users 18432 May 14 12:09 over004 > -rw-rw---- 1 sbarnes users 17408 Jun 4 19:03 over005 > -rw-rw---- 1 llowry users 18432 Feb 1 13:01 over006 > -rw-rw---- 1 dmiadmin users 17408 Jun 20 08:26 over007 > -rw-rw---- 1 gmoore users 24576 Jun 28 07:31 over008 > -rw-rw---- 1 gmoore users 18432 Mar 14 09:10 over009 > -rw-rw---- 1 gmoore users 21504 May 25 06:15 over010 > -rw-rw---- 1 gmoore users 18432 Jun 22 12:43 over011 > -rw-rw---- 1 ijackson users 19456 Jun 4 20:05 over012 > -rw-rw---- 1 sbarnes users 19456 Jun 17 14:47 over013 > -rw-rw---- 1 bsampson users 19456 May 26 06:11 over014 > -rw-rw---- 1 gmoore users 23552 Jun 25 06:15 over015 > -rw-rw---- 1 plocklea users 21504 Jun 24 16:22 over016 > -rw-rw---- 1 gmoore users 19456 Jan 31 11:31 over017 > -rw-rw---- 1 gmoore users 22528 Jun 6 12:15 over018 > -rw-rw---- 1 sbarnes users 19456 Jun 26 06:15 over019 > -rw-rw---- 1 llowry users 21504 Jun 20 08:26 over020 > -rw-rw---- 1 pperry users 21504 Jul 1 10:27 over021 > -rw-rw---- 1 sbarnes users 19456 Jun 20 15:34 over022 > -rw-rw---- 1 ebarton users 17408 Jun 20 08:26 over023 > -rw-rw---- 1 pperry users 19456 May 26 06:09 over024 > -rw-rw---- 1 mhester users 20480 Jun 12 15:07 over025 > -rw-rw---- 1 pperry users 18432 May 20 12:20 over026 > -rw-rw---- 1 pperry users 18432 May 6 13:24 over027 > -rw-rw---- 1 jhickman users 19456 May 31 12:15 over028 > -rw-rw---- 1 mhester users 18432 Jun 26 06:15 over029 > -rw-rw---- 1 tbozeman users 19456 May 31 12:15 over030 > -rw-rw---- 1 whardwic users 20480 Aug 8 2012 over031 > -rw-rw---- 1 dbrooks users 21504 May 31 12:15 over032 > -rw-rw---- 1 sbarnes users 21504 May 25 06:14 over033 > -rw-rw---- 1 kconner users 20480 May 26 06:14 over034 > -rw-rw---- 1 gmoore users 22528 May 26 06:14 over035 > -rw-rw---- 1 whardwic users 19456 Jun 20 08:26 over036 > -rw-rw---- 1 sbarnes users 23552 Jun 20 08:26 over037 > -rw-rw---- 1 mchavis users 20480 Jun 12 15:06 over038 > -rw-rw---- 1 sbarnes users 17408 Jun 20 16:28 over039 > -rw-rw---- 1 suchavis users 20480 Jun 17 13:23 over040 > -rw-rw---- 1 bj0663827 users 20480 Jun 27 06:15 over041 > -rw-rw---- 1 bj0663827 users 17408 Apr 9 11:11 over042 > -rw-rw---- 1 tsampson users 21504 Jun 3 15:54 over043 > -rw-rw---- 1 whardwic users 19456 Jun 20 12:47 over044 > -rw-rw---- 1 sbarnes users 21504 Jun 26 12:42 over045 > sun2:/datatel/coll18/production/apphome/DATA/DATA_P/PERSON>166-$ > > -------------------------------------------------- > Cinda Goff > N.C. Community College System > Database Administrator > 919 807-7060 > vRoom Link: > https://sas.elluminate.com/m.jnlp?password=M.BDCC127B096D131E11EAC16A0F947 > 3&sid=2008362 > > E-mail correspondence to and from this address may be subject to the North > Carolina Public Records Law and shall be disclosed to third parties when > required by the statutes. (NCGS.Ch.132) > > > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
