The 2MASS ingest is the slowest of the bunch: most of the time is spent parsing the free-form catalog files. We need to use the special 'load2mass' command to upload 2MASS data. I ran four separate instances of this command on ipp000, each updating a separate region of the sky (this should be Dec-bands because of the way 2MASS data is stored). Here is an example for dividing the load across 4 roughly equal area patches:

load2mass -D CATDIR catdir.2mass -v -replace -region 0.0 360.0 -90.0 -30.0
load2mass -D CATDIR catdir.2mass -v -replace -region 0.0 360.0 -30.0   0.0
load2mass -D CATDIR catdir.2mass -v -replace -region 0.0 360.0   0.0 +30.0
load2mass -D CATDIR catdir.2mass -v -replace -region 0.0 360.0 +30.0 +90.0

The -replace flag means that only a single 2MASS measurement per filter is associated with each object. The -v flag increases the verbosity.

Next, add in the USNO-B data. Here are the commands loading the full sky in one pass for each filter:

addstar -D CATDIR 2mass/catdir.merge -cat USNOB -photcode USNO_BLUE -replace -v
addstar -D CATDIR 2mass/catdir.merge -cat USNOB -photcode USNO_RED  -replace -v
addstar -D CATDIR 2mass/catdir.merge -cat USNOB -photcode USNO_N    -replace -v

To add SDSS: download drObj files, e.g.:

awk -F, '{if (FNR==1&&match($0,"run")) next; run=$1; rerun=$2; camcol=$3; field=$4; com=sprintf("wget -nv http://das.sdss.org/imaging/%d/%d/dr/%d/drObj-%06d-%d-%d-%04d.fit",run,rerun,camcol,run,camcol,rerun,field); system(com)}' file.csv

where file.csv contains run,camcol,rerun,field and run:

addstar -D CATDIR $CatDir -D CAMERA sdssmosaic drObj...fit