Jump to content


Photo
- - - - -

Pro-Isam Temporary Table

Pro-Isam Purging

6 replies to this topic

#1 sharky7

sharky7

    Member

  • Members
  • PipPip
  • 10 posts
  • Gender:Male

Posted 04 September 2014 - 02:10 PM

Hello everyone.

 

It's been a while since I messed with Pro-Isam files. My goal here is to purge all the records contained in this temporary file. At the same time maintain all the page sizing of the file. As you can see below, the file has grew to about 135MB. It's been years since this was purge.

 

cs_temp.pro Sep 03 20:09 3072 201326592 135853056 67        639259

 

What is the best way of doing this?

 

Thanks in advance.

 

Sonny



#2 Ross Bevin

Ross Bevin

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 226 posts
  • Gender:Male
  • Location:Manzanillo, Colima, Mexico

Posted 04 September 2014 - 03:32 PM

Hi Sonny,

 

What version are you on? We are on 7.1 so utility .exe's and maximum file sizes may be different.

 

1. You can iscr.exe the file with the desired page size. 7.1 has a max file size of 1.9 GB by using r-16000.

2. Write an update to delete all the records. If you want to reclaim white space use ispack.exe.

 

Regards

Ross



#3 sharky7

sharky7

    Member

  • Members
  • PipPip
  • 10 posts
  • Gender:Male

Posted 04 September 2014 - 04:41 PM

Ross, we are on version 4.6. Yeah I know. Very old.

 

Can I just delete the file from Unix and then do iscr?

 

What are the switches/option to re-size page for iscr?

 

Hi Sonny,

 

What version are you on? We are on 7.1 so utility .exe's and maximum file sizes may be different.

 

1. You can iscr.exe the file with the desired page size. 7.1 has a max file size of 1.9 GB by using r-16000.

2. Write an update to delete all the records. If you want to reclaim white space use ispack.exe.

 

Regards

Ross



#4 Ross Bevin

Ross Bevin

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 226 posts
  • Gender:Male
  • Location:Manzanillo, Colima, Mexico

Posted 04 September 2014 - 11:05 PM

Hi Sonny,

 

I have a 5.5 manual but no 4.6.

 

You can try this.

 

iscr -k<key size> -r3000 <full path and file name>

 

Regards

Ross

 

PS: Take a backup first.



#5 Wim Soutendijk

Wim Soutendijk

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 211 posts
  • Gender:Male
  • Location:Netherlands

Posted 05 September 2014 - 07:03 AM

If I remember correctly, iscr -e will clear the file but keep the original key and record sizes



#6 sharky7

sharky7

    Member

  • Members
  • PipPip
  • 10 posts
  • Gender:Male

Posted 05 September 2014 - 12:49 PM

I will definitely try this and will let you know.

 

Thanks Wim!

 

 

If I remember correctly, iscr -e will clear the file but keep the original key and record sizes



#7 DARREN

DARREN

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 396 posts
  • Gender:Male
  • Location:Florida,USA

Posted 05 September 2014 - 01:32 PM

Wim is correct in that an iscr -e (for empty) will clear the files and retain they key/page length size.

 

If you were to migrate to a higher version of PROIV then you could use memory files. They are not physical and are automatically cleaned (memory returned) when the session ends.


Things should be made as simple as possible, but not simpler



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users