To see what shots have LRD fit runs available:

On the PPPL Linux Cluster, assuming you are properly setup (see below line),
   run dbaccess in idl.

For a single shot:
-----------------

	IDL> print, fitsrun( shot )

For All shots:
-------------

	IDL> dbaccess

Under the "Data Access" menu, select "Set Database"

Enter "code_rundb"

In the "Data Tables" column on the left, select "PLASMAS"

Click the "ALL>" button (or move a subset individually)

Under the "Data Access" menu, select "Contrain Data Set"

Pull down on the top "(Select)" button (under "Build Where Clause:") and select
   "PLAMSMAS.run_type"
   
Leave the pull-down to the right as "=" and type "lrdfit" in the white box
   following that.
   
Optionally, you may constrain the data to certain shot ranges, plasma currents
   etc.  
   
You may also order the rows if you wish (e.g., by shot number or Ip).

Click on the "Select" button at the bottom to get the table.

Note that some fields may be missing, indicated in the resulting 
   table as 1.70000e+38.
   
(the LRDfit code is maintained and run by Jon Menard.)

------------------------------------------------------------------
(when LRDfits or EFITs are run, something must tell the code_rundb database
about them to show up in efitviewer, e.g., 

   IDL> fit_run_loader, shot, tree='LRDFIT04'
)

------------------------------------------------------------------

To be able to run IDL code to access the NSTX MS-SQL databases at PPPL:

Besides doing a "module load nstx/mdsplus" and not subsequently mucking up your
paths, you need a file in your $HOME directory on Linux named with the database
name, and "sybase_login" extention. E.g., the file needed for the code_rundb
database, which contaings EFIT and LRDFIT code run information, is called  
code_rundb.sybase_login. For user bdavis at PPPL it would contain the following
five lines:

sqlnstx:8501
sqlnstx
code_rundb
bdavis
pfcworld

Some of these files have a blank line instead of "sqlnstx:8501". The easiest way
to create these files is to run:

   /p/nstxusr1/util/setup/mkmdsplusdbfile.csh

(this won't replace existing files, so if you have any obsolete references to
 eagle,

   grep -i eagle $HOME/*.sybase_login

 delete those first)
 
 [Direct comments or questions on this page to Bill Davis]