Editing Scanco Administration (section)

===Update database after RSQ/ISQ restoration===

If you are restoring RSQ or ISQ files from tape (or other source) it might be preferable to do your analysis without resetting the database info.  

The database is specific to the user.  So, we have to modify the database for <code>microct</code>, and be careful not to modify the <code>calibration</code> (or other users) database.  However, we still need to have permissions from <code>calibration</code> in order to do the modification.

When we restore an ISQ or RSQ to disk, the database needs to be updated to ensure it finds it.  We have to change the database back to say it's on disk.  To do this we need to log in as user <code>calibration</code>.

<pre>
$ set host 0
login as calibXXXX  where XXXX is the scanner id (5019 for VivaCT or 2339 for uCT35) or calib3309 or calib3401 (for the XtremeCT and XtremeCTII system, respectively).
password from Steve

$ @ADISK1:[BONELAB]microct_setup_XXXX.com    ! XXXX=scanner id, sets the logicals to point to bonelab data for SB group
or
$ @ADISK1:[VIVACT]LOGIN.COM  ! sets the logicals to point to microct data for BH group
or
$ @DISK1:[MICROCT]LOGIN.COM ! sets the logicals to point to microct data on the XtremeCT system
or
$ @IDISK1:[XTREMECT2]MICROCT_SETUP.COM ! sets the logicals to point to xtremect2 data on the XtremeCT2 system


$ set proc/priv=bypass      or     $ spb
$ run DISK1:[CALIBRATION.UTIL]UCT_CORRECT_DIR     ! make sure to include the full path to the executable as shown here. 
$ run DISK1:[CALIBRATION.UTIL]UCT_CORRECT_MEAS_DIR.EXE     ! on xtremect2 system, use this program
</pre>

<b>Note:</b> Only change those items which have to be changed (e.g. just hit RETURN for RAW fields if you only want to change the IMA location.  Also, when specifying the directories, use DK0, not DISK2.

<pre>
$ run ut:UCT_CORRECT_DIR.EXE
</pre>

<pre>
Measurement Nr.:         1234
MeasNr.                  1234 
PatientNr:               268
RAW: RAW004
TP0:00001234_RAW
IMA: IMA002
TP0:00001234_IMA
</pre>

<pre>
RAW-Label: [ RAW004 ]

RAW-Dir  : [ TP0:00001234_RAW ]

IMA-Label: [ IMA002 ]   DISK
IMA-Dir  : [ TP0:00001234_IMA ]  DK0:[microct.data.00000456.00001234]

Measurement Nr.:            0
End of program
</pre>

The IMA-label does not matter on disk - but we have to write something to get rid of the IMA002, so 'DISK' makes sense.

Using the standard backup/archiving program, you can archive (MOVE TO) that IMA again to a tape, but use a DIFFERENT TAPE than where the first instance of this scan is on.

Background: Tapes just write file after file, without any directory structure or hierarchy, so the program will always find the first instance (the old dataset) if you try to read it again from that tape.

<b>Note</b> One other option is to change the permissions of UCT_CORRECT_DIR.EXE so that user <code>microct</code> can use it directly.  To do this, log in as users <code>calibration</code> and then:

<pre>
$ set proc/priv=bypass                         ! as user calibration
$ set prot=g:re ut:uct_correct_dir.exe
$ run disk1:[calibration.util]uct_correct_dir  ! as user microct
</pre>


[[Image:Redirect.jpg|15px]] [[#top|''Return to Contents'']] or [[Main_Page|''Return to Main Page'']]