Search:

Type: Posts; User: CoMaboy

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    3
    Views
    93

    Alternatively you can use a select on a table...

    Alternatively you can use a select on a table with just one record like DB or OPTIONS.



    /* select an empty string as something from db */
    SELECT '' AS NOME_DA_LIBRARY FROM db
    SELECT...
  2. Sure you can. Give this a go. SELECT - ...

    Sure you can. Give this a go.


    SELECT -
    activity, -
    entity, -
    TRANSLATE('abcde fg:hi:jk', start_time, '_____abcde_fg_hi_jk_______',' ') AS start_time, -
    TRANSLATE('ab cd:ef:gh',...
  3. Replies
    4
    Views
    602

    That can happen when the actual duration for the...

    That can happen when the actual duration for the expiration is less then a minute. Try this instead.


    SELECT -
    DATE(start_time) AS date, -
    TIME(start_time) AS start, -
    ...
  4. Replies
    4
    Views
    602

    This should work SELECT - ...

    This should work



    SELECT -
    DATE(start_time) AS date, -
    TIME(start_time) AS start, -
    TRANSLATE('ab:cd:ef', DIGITS(end_time-start_time), '________abcdefg_____',' ') AS duration, -
    ...
  5. Replies
    1
    Views
    431

    That's no longer a supported option in TSM v6....

    That's no longer a supported option in TSM v6. Remove the offending lines from your dsmserv.opt.

    http://www-01.ibm.com/support/docview.wss?uid=swg1IC63657
  6. Or you can use show versions show versions...

    Or you can use show versions



    show versions your_node * > somefile.txt
  7. Thread: Session Time

    by CoMaboy
    Replies
    2
    Views
    411

    Try the second script here...

    Try the second script here.
  8. Replies
    10
    Views
    737

    Try these two queries, one will show the number...

    Try these two queries, one will show the number of mounts and total time in use per volume, the other per drive.



    SELECT -
    VARCHAR(library_name,10) AS library, -
    VARCHAR(volume_name,10)...
  9. Replies
    10
    Views
    737

    Yeah mount retention is set to 10 minutes....

    Yeah mount retention is set to 10 minutes. Looking at Ed's post again that's not what he wrote but I think that's what was meant.
  10. Replies
    10
    Views
    737

    No, it's a parameter of the tape devclass you...

    No, it's a parameter of the tape devclass you use. Try q devcl your_devcl f=d.
  11. Hi, both baclient and tdp sessions are included...

    Hi, both baclient and tdp sessions are included in either ARCHIVE GB or BACKUP GB total numbers depending on the type of operation. Have a look a the individual records in the summary table and...
  12. So the problem is the decimal overflowing. The...

    So the problem is the decimal overflowing. The maximum value the dec(10,2) can hold is 99999999.99 so just over 95TB. Anything more and it wil overflow throwing an ANR0162W sqlcode 413 sqlstate...
  13. This happens to me occasionally as well when...

    This happens to me occasionally as well when running queries. I think an overflow occurs when casting to dec(10,2). Maybe change it to dec(20,2) and run the select again to see what happens.

    I'm...
  14. Replies
    1
    Views
    398

    Try this. SELECT - process_num, - ...

    Try this.



    SELECT -
    process_num, -
    process, -
    TRANSLATE('abcde fg:hi:jk', start_time, '_____abcde_fg_hi_jk_______',' ') AS start_time, -
    TRANSLATE('ab cd:ef:gh',...
  15. Replies
    6
    Views
    932

    The first script takes one parameter, the second...

    The first script takes one parameter, the second takes three parameters. After saving the script run it from the command line with the necessary parameters.

    eg. RUN EV * * 1
    or RUN EV sql * 7
  16. Replies
    6
    Views
    932

    If what you are looking for is the TSM DBBackup...

    If what you are looking for is the TSM DBBackup then use this script.



    /* DBB - Show TSM DBBackup stats */
    /* Usage: RUN DBB $1 */
    /* $1=#days */
    SELECT -
    VARCHAR(schedule_name,15) AS...
  17. Thread: Archive Stats

    by CoMaboy
    Replies
    2
    Views
    542

    This wil show elapsed time formatted as DD...

    This wil show elapsed time formatted as DD HH:MM:SS.


    SELECT substr(char(start_time),1,19) AS START_TIME,TRANSLATE('ab cd:ef:gh', DIGITS(end_time-start_time), '______abcdefghi_____',' ') AS...
  18. Replies
    2
    Views
    568

    Check the details of the devclass you are sending...

    Check the details of the devclass you are sending the db backups to. Your script probably says Backup DB Devclass=something. Query devclass something f=d should show you the path.
  19. select distinct node_name from occupancy where...

    select distinct node_name from occupancy where stgpool_name='YOUR_STGPOOL_NAME'
  20. Replies
    2
    Views
    742

    It's still set as the copystgpool for one of your...

    It's still set as the copystgpool for one of your primairy pools. run q stg <prim_pool_name> f=d and update accordingly
  21. Replies
    4
    Views
    834

    You can do something like this but be...

    You can do something like this
    <edit>but be careful not to create infinite loops in your script!!!!! you will have to bring your server down if you do. </edit>



    ...
    backup db devcl=lto5 t=f...
  22. I use this script to tell me all I need to know...

    I use this script to tell me all I need to know about my drm tapes. It shows the numbers of hours before pending tapes become available in the last column.


    SELECT -
    VARCHAR(dd.volume_name,8)...
  23. Replies
    2
    Views
    828

    Is this what you are looking for? SELECT -...

    Is this what you are looking for?



    SELECT -
    process_num as PROC_NUM, -
    process, -
    TRANSLATE('ab cd:ef:gh', DIGITS(current_timestamp-start_time), '______abcdefghi_____',' ') as...
  24. Replies
    2
    Views
    816

    put your script in a txt file and define it to...

    put your script in a txt file and define it to the tsm server.


    DEFINE SCRIPT script_name FILE=path_to_file.txt
    To edit your script simply edit the text file, delete your script from server and...
  25. Replies
    12
    Views
    2,533

    I also cheated and added + 1 SECOND to my scripts...

    I also cheated and added + 1 SECOND to my scripts as a workaround for the divide by 0. As for the wrapping of the field names; don't think you can do it just using the admin client. I'd probably just...
  26. Replies
    4
    Views
    1,257

    The status table contains the server name.

    The status table contains the server name.
  27. Replies
    4
    Views
    1,152

    Thx guys, Database is some 30GB atm with...

    Thx guys,


    Database is some 30GB atm with 42TB of data in primary storage. However, the amount of data is expected to increase to 200-250TB over the next year. Can I safely assume that my DB...
  28. Replies
    4
    Views
    1,152

    New server hardware - need advice

    Hi,

    We're about to go shopping for a new tsm server and I was wondering if you guys could give me some input. We're currently running TSM 6.3 on an IBM system x3650 M1 (type 7979) and a TS3200...
  29. Replies
    2
    Views
    920

    assuming you have one set of credentials that...

    assuming you have one set of credentials that works on all servers you could do something like this.



    @ECHO OFF
    TITLE Where's that $!@# tape!

    SET tsm_servers=tsmserver1 tsmserver2...
  30. Replies
    3
    Views
    1,009

    If you want uptime in YY-MM-DD HH:MM:SS, try...

    If you want uptime in YY-MM-DD HH:MM:SS, try this.



    SELECT -
    TRANSLATE('ab-cd-ef gh:ij:kl', DIGITS(current_timestamp-restart_date), '__abcdefghijkl_____',' ') AS yy_mm_dd_hh_mm_ss_uptime -...
  31. Replies
    12
    Views
    2,533

    Hey Maatje :) You can sort the results by the...

    Hey Maatje :)

    You can sort the results by the original column name bytes_received. You don't need to put the column you sort by in the select part. And if you wanted to, you could also display...
  32. Replies
    12
    Views
    2,533

    IF is not an option afaik but you can use...

    IF is not an option afaik but you can use case-when-else-end.



    SELECT -
    CASE -
    WHEN bytes_received>1099511627776 THEN CAST(DEC(bytes_received)/1024/1024/1024/1024 AS DEC(6,2))||' TB' -...
  33. Replies
    12
    Views
    2,533

    translate replaces the characters in the first...

    translate replaces the characters in the first string with characters in the second using the third as a sort of mask. any characters in the third string, not present in the first will be ignored.
  34. Replies
    12
    Views
    2,533

    Or a bit shorter and easier to read... ...

    Or a bit shorter and easier to read...



    select client_name, session_id, state, -
    date(start_time) as "Start Date", -
    time(start_time) as "Start Time", -
    cast(float(bytes_sent/1024/1024) as...
  35. Replies
    9
    Views
    957

    select node_name from nodes where node_name not...

    select node_name from nodes where node_name not in (select varchar(node_name) from nodegroup)
  36. Replies
    9
    Views
    1,103

    this might work, else QUERY VOLUME h00338l3 F=D...

    this might work, else QUERY VOLUME h00338l3 F=D would be usefull.

    MOVE MEDIA h00338l3 STG=* WHEREST=MOUNTABLEN REM=N CHECKL=N
  37. Replies
    4
    Views
    679

    So I did some testing with the last journal. I...

    So I did some testing with the last journal. I found that the baclient is able to delete the file succesfully when I perform a dbcache flush on the domino console prior to archiving the journal. That...
  38. Ok found it! You do need the >=17 after all....

    Ok found it! You do need the >=17 after all. Without it - it seems to give you last period plus everything in the current 24h period. That's why you see it increase with time. Any how, I changed it...
  39. Weird! I notice one script has the OR...

    Weird! I notice one script has the OR (HOUR(current_timestamp)>=17 - where the other has OR (end_time>timestamp(date....
    Fix that first and see what it does. I would say you don't need >=17 but...
  40. hmmm that's strange, shouldn't be possible since...

    hmmm that's strange, shouldn't be possible since the query fetches a 24h period that's always in the past.. Ran it a couple of times here and it seems to work flawlessly. Could you pls run them both...
  41. Here you go SELECT - ...

    Here you go


    SELECT -
    CAST(FLOAT(SUM(bytes))/1024/1024/1024 AS DEC(10,2)) AS total_gb -
    FROM -
    summary -
    WHERE -
    activity NOT IN ('TAPE MOUNT','EXPIRATION') -
    AND...
  42. Something like this perhaps? SELECT - ...

    Something like this perhaps?



    SELECT -
    VARCHAR(activity,20) AS activity, -
    CAST(FLOAT(SUM(bytes))/1024/1024/1024 AS DEC(10,2)) AS gb -
    FROM -
    summary -
    WHERE -
  43. Thread: SQL Quesry

    by CoMaboy
    Replies
    1
    Views
    514

    Changed one of my existing scripts a bit to suit...

    Changed one of my existing scripts a bit to suit your needs. This should do what you want it to.


    SELECT -
    VARCHAR(entity,18) AS "Node", -
    VARCHAR(schedule_name,15) AS "Schedule", -
    CASE -...
  44. Replies
    4
    Views
    679

    Thanks moon-buddy, it's not the active...

    Thanks moon-buddy, it's not the active mailjournal i'm talking abt. I'm looking to archive and delete an old mail journal after domino has rolled over to a new one. So basically it's just a regular...
  45. Replies
    4
    Views
    679

    Archiving mail journal

    Hi guys,

    Not really a tdp question but posting it here hoping a domino admin can help me out. We've got mail journaling set up to periodically rollover to a new journal. Old journal is then...
Results 1 to 45 of 57
Page 1 of 2 1 2