Page 1 of 1

State File Demystified

Posted: Fri Jul 26, 2013 4:04 pm
by rameshrr3
The State file is a binary data file that stores an uint32 or uint64 value depending on your operating system. in a 64 bit platform , it stores an uint64 value in each 8 byte block of data per node. To read current values of a surrogate key state file , you can use the unix command od -xc <state File name> or use a sequential file , whose schema has a single uint 64 column [BigInt unsigned , unbounded, Data format=binary, field width = 8] , with Format property record type as implicit , you can see the currently stored values using view data. Not sure if this will help anybody or can be of much use , but my attempt to demystify those mysterious state files and their 'garbage' data.

Posted: Sat Jul 27, 2013 11:45 am
by jerome_rajan
Great! :D Going to try it first thing when I reach office. Thanks for sharing.

Posted: Sat Jul 27, 2013 3:52 pm
by ray.wurlod
It seems you have set up your state file with a block size of 1.