Try issuing the command QUERY OCCUPANCY CPRS01. This will show you how much
storage the Oracle backups are occupying on ADSM.

SQL-BackTrack does not report filespace information for databases, which is why
you see the "0.0" values.

Andy Raibeck
ADSM Level 2 Support

 ADSM-L AT VM.MARIST DOT EDU
 02-17-98 03:07 PM
Please respond to ADSM-L AT VM.MARIST DOT EDU @ internet

To: ADSM-L AT VM.MARIST DOT EDU @ internet
cc:
Subject: SQL-Backtrack/w Oracle, all indication are good but no data

We have and AIX server ver 4.2, ADSM server ver 3.1.0.1,
SQL BackTrack ver 2.3.1.5  and ADSM OBSI ver 2.2.1.
We, have completion with no error from the Oracle logs but no data
comes out in the files list. Hence no backup...
Help, help, help!!!

From the "q files"
CPRS01                         /BACKTRACK: SQL-BACK API:BACKT      0.0
0.0
                                tmp-contro  TRACK    RACK

                                l-dir

CPRS01                         /BACKTRACK: SQL-BACK API:BACKT      0.0
0.0
                                profiles    TRACK    RACK

CPRS01                         /BACKTRACK: SQL-BACK API:BACKT      0.0
0.0
                                prd1        TRACK    RACK


q files cprs01 f=d

                       Node Name: CPRS01
                  Filespace Name: /BACKTRACK:tmp-control-dir
                        Platform: SQL-BACKTRACK
                  Filespace Type: API:BACKTRACK
                   Capacity (MB): 0.0
                        Pct Util: 0.0
     Last Backup Start Date/Time:
  Days Since Last Backup Started:
Last Backup Completion Date/Time:
Days Since Last Backup Completed:

                       Node Name: CPRS01
                  Filespace Name: /BACKTRACK:profiles
                        Platform: SQL-BACKTRACK
                  Filespace Type: API:BACKTRACK
                   Capacity (MB): 0.0
                        Pct Util: 0.0
     Last Backup Start Date/Time:
  Days Since Last Backup Started:
Last Backup Completion Date/Time:
Days Since Last Backup Completed:

                       Node Name: CPRS01
                  Filespace Name: /BACKTRACK:prd1
                        Platform: SQL-BACKTRACK
                  Filespace Type: API:BACKTRACK
                   Capacity (MB): 0.0
                        Pct Util: 0.0
     Last Backup Start Date/Time:
  Days Since Last Backup Started:
Last Backup Completion Date/Time:
Days Since Last Backup Completed:

{ rest of info snipped }