Need support for your remote team? Check out our new promo! Select all Open in new window. IT issues often require a personalized solution. Why EE? Get Access. Log In. Web Dev.
NET App Servers. We help IT Professionals succeed at work. TSM query for getting backups completed for last 10 days. Medium Priority. Last Modified: We have to reschedule some of the clients in the Schedules to balance it.
For this, first i need to work on the trends for backups. I want to know how can i get the duration of the backups completed for the nodes for last 7 days. Thanks virgo. Start Free Trial. View Solution Only. Experts with Gold status have received one of our highest-level Expert Awards, which recognize experts for their valuable contributions.
Most Valuable Expert This award recognizes tech experts who passionately share their knowledge with the community and go the extra mile with helpful contributions.
Top Expert This award recognizes someone who has achieved high tech and professional accomplishments as an expert in a specific topic. Commented: If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful. Click the link above to access ADSM. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts. Forums New posts. What's new New posts.
Log in Register. What's new. New posts. Log in. Please help support our sponsors by considering their products and services. Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.
Thread starter tsmhelum Start date Apr 19, Hi, I am trying to query some files for a point-in-time restore, I have use this command before and it worked however its not working now. Can anyone see where I might be making a error? ORG Member. Apr 19, Apr 20, Also is it possible that the data you are looking for is archived, in this case q arch.
Kishan ADSM. Hi tsmhelum, In your file specification you have spaces that's the reason you are not able to view your output. Below highlighted one.
Back up Tableau Server data
Please let us know your opinion. Hence you need to use double quotes. Thanks gtmukesh, I tried the command but still no results. Hi tsmhelum, The command which brain said is correct. However u said, the same command was worked earlier. In the case TSM server ll not know the files got backed up before 1st feb. Thus it ll not show the files which r all got backed up before 1st feb but files should remains in the tape or disk.
Let us know if any change happen as like tat. Thanks, Sri. You must log in or register to reply here.This system has a server which accepts backups from a client on your desktop and writes these to tape. The server is responsible for scheduling the backups as well as tracking and recovering your files.
The client consists of a service that runs on your client, a graphical user interface and a command line interface. The client service called TSM client scheduler continuously runs on your machine and checks with the server to see when backups are scheduled.
Once added, click the "Save" button. You will want to select your NodeName e. Then select "Change Password". If you do not see your NodeName e. NOTE: The backups schedule is still being finalized. If you run the "query schedule" command, you will see the following error "there are no schedules associated with this node. Remember this password for the next step. After that you can forget it as it will automatically change regularly.
We will keep TSM documentation in this article and update it on a regular basis. Adaptavist Theme Builder 4. Quick Search. Adaptavist Theme Builder.To start a restore you must have administrator privileges to your server or workstation.
Because of the UW-IT production schedule, the best response time and results from Tivoli Storage Manager file restores are from 11ampm daily. Restoring at other times may result in a longer wait for a tape drive to become available. Data Backups and Archives. Pages Blog. Space shortcuts File lists.
Child pages. Data Backups and Archives User Page. Browse pages. A t tachments 6 Page History Scaffolding History. Copy with Scaffolding XML. Jira links. Created by jamiesonlast modified by Brian G Kunst on Nov 03, TSM File Restores. Click on the Restore button. This allows you to see all the versions of your files, not just the most recently backed up. Select the checkbox next to the files and directories you want to restore.
A new window will pop up that allows you to select and alternate destination for your restore. If you wish to restore your data to a location other than the original, click the radio button next to Following Locationthen select an alternate location. To begin the restore, click Restore. The TSM server then mounts the relevant tape cartridge and begin copy your files and folders over to your system. Please note that it takes a few minutes to find and mount your tape before a restore begins.The screen shots and descriptions that follow may refer to older TSM clients, but with the exception of the file specifications the syntax is generic to all platforms.
Please note that it is recommended that sensitive data be sent encrypted.
How to Query Backed up files on TSM database
See further our pages on backup and archive security and how to encrypt files for backup. The TSM command line interface will open in a window on the Windows desktop. This window will be small but you can change its size, colour, or font by right clicking on the icon in the top left corner and selecting [Properties]. You should see a prompt of the form:. Open [Terminal] from [Applications] [Utilities] and type sudo dsmc. You will be prompted for your Mac password then should see a prompt of the form:.
Run dsmc as root from the shell prompt e. The result will be similar to below:. Note that commands and options may be abbreviated to a short form as indicated by capitalisation of words in the syntax entry for a command. Thus, for example, query filespace can be abbreviated to q fi. Options and commands can also be included on the original command line so, using the above example, on a Netware machine you can run load dsmc q fi to just run a query of the current partitions backed up.
Obviously, more complex queries and commands can be similarly run in the same manner. To query your scheduled backup slot enter q sched which is short for query schedule. The output should look similar to that below:.
The order they are displayed above is the order in which these directives are applied by TSM. You will note that the order of the directives at any one level is the opposite of the order in which they appear in the options file. That is, TSM reads the directives listed in options file from the bottom up. The syntax for querying what files you have backed up involves giving a file specification which is necessarily OS specific.
Also, if an incorrect file specification is given it may appear that you have no backups. Note that the Windows client lists the directory in UNC format. This format can also be used for the file specification in the query. Note that file specifications with spaces in them will need to be quoted. By default only the current versions of files are listed. In order to query both current active and previous inactive versions of files, add the -inactive option to the query:.Use this command to display information about files in a storage pool volume, and the names of client files that link to a deduplicated group of files.
Because this command can take a long time to run and the results can be large, consider using the COUNT parameter to limit the number of files displayed. For a server that has clients with Unicode support, you might need to have the server convert the file space name that you enter. For example, you might need to have the server convert the name that you enter from the server's code page to Unicode.
If you do not specify a file space name or specify only a single wildcard character for the name, you can use the CODETYPE parameter to limit the operation to Unicode file spaces or non-Unicode file spaces. The default value is BOTH, which means that the file spaces are included regardless of code page type. Possible values are:. Results of the command include all logical files that make up any aggregate that is on the volume, even if the aggregate is stored on more than this volume.
For aggregates, the query does not determine which logical files are actually stored on the volume for which the query is performed. File space names can be in a different code page or locale than the server. If they are, the names in the Operations Center and the administrative command-line interface might not be displayed correctly. Data is backed up and can be restored normally, but the file space name or file name might be displayed with a combination of invalid characters or blank spaces.
If the file space name is Unicode-enabled, Tivoli Storage Manager converts the name to the server code page for display. The success of the conversion depends on the operating system, the characters in the name, and the server code page.
Conversion can be incomplete if the string includes characters that are not available in the server code page or if the server cannot access system conversion routines. If the conversion is incomplete, the name might contain question marks, blanks, unprintable characters, or ellipses File space names and file names that can be in a different code page or locale than the server do not display correctly in the Operations Center or the administrative command-line interface.
The data itself is backed up and can be restored properly, but the file space or file name might display with a combination of invalid characters or blank spaces. The results of the conversion for characters that are not supported by the current code page depends on the operating system. For names that Tivoli Storage Manager is able to partially convert, you might see question marks??
These characters indicate to the administrator that files do exist. You can use this command to identify files that the server found to be damaged and files that were backed up to a copy storage pool or copied to an active-data pool.
This command is useful when a volume is damaged or before you: Request the server to fix inconsistencies between a volume and the database Move files from one volume to another volume Delete a volume from a storage pool. Note: Files that are cached in a disk volume and that are marked as damaged are not included in the results. Privilege class Any administrator can issue this command. This parameter is optional. You can use wildcard characters to specify this name.
If you do not specify a name, all backup-archive and Tivoli Storage Manager for Space Management clients are included. FIlespace Specifies the file space to query. File space names are case-sensitive.
If you do not specify a file space name, all file spaces are included. COUnt Specifies the number of files to be displayed. You can specify either a positive integer or a negative integer. If you specify a positive integer, nthe first n files are displayed. If you specify a negative integer, -nthe last n files are displayed in reverse order. If you do not specify a value for this parameter, all files are displayed.Hi, Thanks for sharing these valuable info.
This is really short and quick reference material for system admins. I've question - what is the command to find what type of backup is configured for client i. How to check when the last full backup has been taken? Home About Contact Archives. The software enables the user to insert objects not only via backup, but also through space management and archive tools.
It also allows retrieval of the same data via similar restore, recall, and retrieve methods. I would like to discuss about the the best 14 best use-full TSM client commands. In this article we are going to discuss about the following contents with practice examples. Restore files specified in the text file to a different location. A selective backup is commonly used for backing up files which change frequently or in situations where the space available to store backups is limited.
Also called a partial backup. If the file you are restoring no longer resides on your client machine, and you have run an incremental backup since deleting the file, there is no active backup of the file on the server. In this case, use the latest option to restore the most recent backup version. Tivoli Storage Manager restores the latest backup version, whether it is active or inactive.
When restoring a specific path and file, Tivoli Storage Manager recursively restores all sub-directories under that path, and any instances of the specified file that exist under any of those sub-directories. Use the pitdate option with the pittime option to establish a point in time for which you want to display or restore the latest version of your backups. Files that were backed up on or before the date and time you specified, and which were not deleted before the date and time you specified, are processed.
Backup versions that you create after this date and time are ignored. If you omit the delimiter and your specified source is a directory or a file spec with a wildcard, you will receive an error. If the projects directory does not exist, it is created. Anonymous 3 March at Anonymous 25 May at Unknown 20 February at Anonymous 4 March at Social Profiles.