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 for 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

}}