Hi Hans Chr.

Did you try using the * (wildcard) character? 

   TDPSQLC RESTORE * FULL

The User's Guide shows * as a valid "dbname":

   
http://www.ibm.com/support/knowledgecenter/SSTFZR_7.1.4/db.sql/dps_ref_cmd_restoresyn.html


Thank you,

Del

----------------------------------------------------


"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 03/16/2016 
11:18:47 AM:

> From: Hans Christian Riksheim <bullhcr AT GMAIL DOT COM>
> To: ADSM-L AT VM.MARIST DOT EDU
> Date: 03/16/2016 11:19 AM
> Subject: MSSQL, restore all DBs in an instance
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> 
> We are doing a DR test and will restore a full instance of MSSQL, almost 
a
> hundred databases
> 
> From the manual I am not sure if this is possible with a single command.
> Anyone?
> 
> Hans Chr.
>