"Digit grouping" in SELECT statement

2002-11-26 Thread Christian Sandfeld
Does anybody know how to set digit grouping in a SELECT statement? I run the following select statement: SELECT node_name,sum(PHYSICAL_MB) as MB FROM OCCUPANCY WHERE stgpool_name='TAPEPOOL' GROUP BY node_name ORDER BY MB DESC The output returned looks like this: NODE_NAME

Perl scripts utilizing dsmadmc.exe on WIN32 platform

2002-11-26 Thread Christian Sandfeld
Hi list, I'm currently toying a bit with some perl scripts for automating checkin, labeling etc. by graping request ID's etc. on the Windows platform - utilizing the dsmadmc.exe tool. I am however finding myself getting stuck from time to time, and was wondering if anyone could provide some exampl

Re: BRMS and TDP for Domino on AS/400

2002-12-04 Thread Christian Sandfeld
/service/brms/adsmtips.htm Also have a look at the "readme.api" file provided with the TSM API. Kind regards, Christian Sandfeld |-+---> | | Henrry Aranda | | | | | | S

SELECT statement to determine if any drives available

2002-12-19 Thread Christian Sandfeld
Hi list, Does anybody know of a SELECT statement that will show if any drives are available for use (not in use by another process or session)? I need this for scripting purposes as I have only two drives in my library, and while doing reclamation both drives are in use. Kind regards, Christia

Re: SELECT statement to determine if any drives available

2002-12-19 Thread Christian Sandfeld
Cheers guys, I'll look into those posibilities :-) /Christian |-+---> | | David E Ehresman| | | | | | Sent by: "ADSM: | | | Dist Stor | | | Manager"| |

"size estimate exceeded" when "cache migrated files" is enabled

2003-01-02 Thread Christian Sandfeld
Hi list, First, a happy new your to you all! Just before christmas we changed our setup a bit to facilitate backup of a Domino server running on AS/400, utilizing BRMS and the TSM API as the backup client. We have verified that BRMS can contact the TSM server, and also verified that backup runs a

Re: "size estimate exceeded" when "cache migrated files" is enabled

2003-01-03 Thread Christian Sandfeld
Richard, Thomas and Steve, Thank you for your answers - they give me some things to look for and some stuff to try. Kind regards, Christian

How do I specify the nodename and password that STRMNTBRMS should use?

2003-01-06 Thread Christian Sandfeld
Hi list, As mentioned in an earlier post, we recently introduced a setup where backup of our Domino data on our AS400 / iSeries server is done through the use of BRMS in combination with the TSM API in order to store the backup data on out TSM server. In BRMS you specify the nodename and password