| Author |
Message
|
| jeevan |
 Posted: Mon Sep 18, 2006 4:44 pm Post subject: Automating Windows activities |
 |
|
Grand Master
Joined: 12 Nov 2005
Posts: 1432
|
Is there a way to automate Windwos activities? For example, we have to create the datasource for the database. Instead doing this manually every time, can not we write a script ( I do not have any idea just curious) like:
ControlPanel->AdministrativeTools->DataSource->createdatasourcename DSN ( just a wild idea) |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Mon Sep 18, 2006 7:07 pm Post subject: Re: Automating Windows activities |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi jeevan,
| jeevan wrote: |
| ControlPanel->AdministrativeTools->DataSource->createdatasourcename DSN ( just a wild idea) |
Not this way....but I suppose you could do it from command line...look for ODBC creation from db2 command prompt...then envelope it into a bat.
Regards. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon Sep 18, 2006 7:52 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Or have the windows admin deploy it remotely to x many pcs at once...
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| wschutz |
| Posted: Tue Sep 19, 2006 2:12 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
|
| Back to top |
|
|
| jeevan |
| Posted: Tue Sep 19, 2006 3:02 am Post subject: |
|
|
Grand Master
Joined: 12 Nov 2005
Posts: 1432
|
| Thank you very much for your valuable ideas and suggestions. |
|
| Back to top |
|
|
| ak |
| Posted: Mon Sep 25, 2006 2:15 am Post subject: |
|
|
Apprentice
Joined: 07 Aug 2006
Posts: 48
Location: England
|
Let say db2 database name is WBRKDB and user is db2admin
C:\> db2 create database WBRKDB;
C:\> db2 grant all to db2admin;
Also do this
ControlPanel ->Adminstrative tools -> Data Source(ODBC)->System DSN
- Add database(WBRKDB) to the list. |
|
| Back to top |
|
|
|
|
