Using cmd line and DSMADMC

[dwjongbloed]

I am trying to use CMD line and DSMADMC to do a select to an outfile. In my select I have a "like" condition. I know the TSM DB isn't a SQL DB. How do I do a like condition. What I have is: "select * from contents where node_name='XXXXXXX' and filespace_name='/vol/COMMON' AND file_name like '%.dbf'"



Any help with the like statement would be greatly appreciated.

Thanks

 

[BBB]

Your command may run for a very long time if you have a big db.

Replace file_name with ll_name, that's the correct column name. LL name is low level name, ie the filename. THere is a hl_name which is high level name, ie the subdirectory underneath the filespace. You have to be careful where you put /'s as they have to be exactly correct. eg. i *think* the hl_name is /sub/dir/ whereas the filespace name is /filespace/name

The quoted strings are case sensitive, so nodename must be in allcaps, the filespacename and ll_name must be as they were on the system you backed up.