Search:

Type: Posts; User: CoMaboy

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Try disabling and then re-enabling autoclean in...

    Try disabling and then re-enabling autoclean in the webinterface now that the cleaning tape is in it's slot. Is auto clean disabled on your drives in TSM? Check q dr f=d
  2. I had the same problem with a TS3200 library. If...

    I had the same problem with a TS3200 library. If I remember correctly I resorted to ejecting the magazine and manually placing the cleaning tape in it's dedicated slot.
  3. Replies
    10
    Views
    1,967

    Expire inventory has to run to inactivate and...

    Expire inventory has to run to inactivate and delete the old data. It probably runs daily via some housekeep script but you can run it manually if you want.

    The active policy set is the copy TSM...
  4. Replies
    10
    Views
    1,967

    After changing your standard policy set you need...

    After changing your standard policy set you need to validate and activate it. Expire inventory has to run before you'll see any changes in your storage pools.

    See HELP VALIDATE POLICYSET and HELP...
  5. Replies
    6
    Views
    1,750

    You can't plug the result straight into the recl...

    You can't plug the result straight into the recl stg command but this could work.



    select schedule_name from events where schedule_name='DLY_TASKS' and status='Started' and...
  6. This wil give you minimum, maximum and average...

    This wil give you minimum, maximum and average duration in minutes. Save as a script and run with 3 parameters: (part of) node name, (part of) schedule name and #days. You can use * as a wildcard for...
  7. Replies
    3
    Views
    612

    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...
  8. 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',...
  9. Replies
    4
    Views
    655

    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, -
    ...
  10. Replies
    4
    Views
    655

    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, -
    ...
  11. Replies
    1
    Views
    469

    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
  12. Or you can use show versions show versions...

    Or you can use show versions



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

    by CoMaboy
    Replies
    2
    Views
    461

    Try the second script here...

    Try the second script here.
  14. Replies
    10
    Views
    816

    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)...
  15. Replies
    10
    Views
    816

    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.
  16. Replies
    10
    Views
    816

    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.
  17. 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...
  18. 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...
  19. 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...
  20. Replies
    1
    Views
    421

    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',...
  21. Replies
    6
    Views
    1,017

    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
  22. Replies
    6
    Views
    1,017

    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...
  23. Thread: Archive Stats

    by CoMaboy
    Replies
    2
    Views
    575

    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...
  24. Replies
    2
    Views
    600

    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.
  25. select distinct node_name from occupancy where...

    select distinct node_name from occupancy where stgpool_name='YOUR_STGPOOL_NAME'
  26. Replies
    2
    Views
    762

    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
  27. Replies
    4
    Views
    897

    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...
  28. 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)...
  29. Replies
    2
    Views
    882

    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...
  30. Replies
    2
    Views
    863

    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...
  31. Replies
    12
    Views
    2,618

    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...
  32. Replies
    4
    Views
    1,302

    The status table contains the server name.

    The status table contains the server name.
  33. Replies
    4
    Views
    1,205

    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...
  34. Replies
    4
    Views
    1,205

    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...
  35. Replies
    2
    Views
    948

    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...
  36. Replies
    3
    Views
    1,048

    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 -...
  37. Replies
    12
    Views
    2,618

    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...
  38. Replies
    12
    Views
    2,618

    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' -...
  39. Replies
    12
    Views
    2,618

    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.
  40. Replies
    12
    Views
    2,618

    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...
  41. Replies
    9
    Views
    1,028

    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)
  42. Replies
    9
    Views
    1,138

    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
  43. Replies
    4
    Views
    726

    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...
  44. 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...
  45. 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...
Results 1 to 45 of 63
Page 1 of 2 1 2