I did a select from the volumes table and noticed that there's a pending
date on almost all my tape volumes!  Beginning with the first tape that has
a status of pending to the end of the list, all have a pending_date whether
or not the status is pending.  In fact, the pending_date is repeated on all
non-pending tapes following it until it reaches another that is pending,
then that date is used for the next ones, etc.  If I do a q vol f=d, these
tapes do not have a pending date.

So, is this a bug I should turn in or is it something I don't understand?

Here's a sample of the output:

VOLUME_NAME     STATUS  PENDING_DATE
R00213                  FILLING
R00219                  FULL
R00220          FILLING
R00221                  FILLING
R00222          PENDING 1998-12-01 08:06:54.000000
R00223          FULL            1998-12-01 08:06:54.000000
R00229          FULL            1998-12-01 08:06:54.000000
R00232          PENDING 1998-12-01 15:30:18.000000
R00233          FULL            1998-12-01 15:30:18.000000
R00234          FULL            1998-12-01 15:30:18.000000
R00235          PENDING 1998-12-01 14:29:05.000000
R00236          FULL            1998-12-01 14:29:05.000000
R00237          FULL            1998-12-01 14:29:05.000000
R00239          EMPTY           1998-12-01 14:29:05.000000

> -----Original Message-----
> From: Magura, Curtis [SMTP:curtis.magura AT LMCO DOT COM]
> Sent: Wednesday, October 14, 1998 12:51 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: odbc access to server
>
> Tina,
>
>    Add the following to your autoexec.bat. At least it fixed it for me on
> WIN95.....
>
> REM For ADSM ODBC Support - Added 06/29/98
> SET DSMG_DIR=C:\WIN32APP\IBM\ADSM\ODBC\ADSM
>
> Curt Magura
> Lockheed Martin Mission Systems
> 301-240-6305
>
> -----Original Message-----
> From: Hilton Tina [mailto:HiltonT AT TCE DOT COM]
> Sent: Wednesday, October 14, 1998 12:50 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: odbc access to server
>
>
> I'm trying to set up the ODBC connection so I can look at my database
> information via MS Query or MS Access.  All our clients are AIX and our
> server(v3.1.12) is AIX (v4.2).
>
> On my PC (Windows 95) I have installed the Admin client and ODBC driver.
> When I try to select the data source from MS Query, I get this message:
>
>         ADSM:  The message repository cannot be found!  Please ensure you
> have defined environment variable DSMG_DIR pointing to the directory that
> message repository resides.  Driver's SQLAllocHandle on SQL_HANDLE_ENV
> failed.
>
> I can't find anything about DSMG_DIR and where to set it on my PC.  Does
> anybody out there know what to do?  The only references I can find for it
> is
> in regards to OS/2.
>
> Any help will be appreciated.
>
>
> Tina Hilton
> Thomson Consumer Electronics
> Systems Software
> 317-587-4292
> hiltont AT tce DOT com