DB2 install

5 messages Options
Embed this post
Permalink
cyberlot

DB2 install

Reply Threaded More More options
Print post
Permalink
Not sure if I mentioned this one, it is installed and running, not sure
how we should handle administration/setup of dbs for users and such.
GavinZend

Re: DB2 install

Reply Threaded More More options
Print post
Permalink
I'm hoping our DB2 expert, Salvador, will volunteer ... :)

Richard Thomas wrote:
> Not sure if I mentioned this one, it is installed and running, not
> sure how we should handle administration/setup of dbs for users and such.
--
Cheers,
Gavin

Which ZF List?
=================
Everything, except the topics below: [hidden email]

Authorization, Authentication, ACL, Access Control, Session Management
[hidden email]

Tests, Caching, Configuration, Environment, Logging
[hidden email]

All things related to databases
[hidden email]

Documentation, Translations, Wiki Manual / Tutorials
[hidden email]

Internationalization & Localization, Dates, Calendar, Currency, Measure
[hidden email]

Mail, MIME, PDF, Search, data formats (JSON, ...)
[hidden email]

MVC, Controller, Router, Views, Zend_Request*
[hidden email]

Community Servers/Services (shell account, PEAR channel, Jabber)
[hidden email]

Web Services & Servers (HTTP, SOAP, Feeds, XMLRPC, REST)
[hidden email]


How to un/subscribe:  http://framework.zend.com/wiki/x/GgE

cyberlot

Re: DB2 install

Reply Threaded More More options
Print post
Permalink
In reply to this post by cyberlot
Its a dev box for framework people, so ease of setting up accounts for
users, some sort of phpmyadmin type interface would be nice ;)

Salvador Ledezma wrote:

>
> Hi Gavin/Richard,
>
> I missed the beginning of this thread, but DB2 in general follows
> operating system security for allowing DB2 users to connect to the
> database.  Once a connection to a database is made, access to specific
> db objects can be controlled via the SQL GRANT command.
>
> By default, db objects belong to the userid that created them and it is
> up to him/her to grant access.
>
> Not sure how sophisticated you would like to get with user mgmt, or if
> you have specific questions, but here is a link to a devworks article
> that gives a general overview on security:
> http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0508wasserman/ 
>
>
> What is your goal?  Strictly managing users or giving them free rein to
> create and manage databases?
>
> Thanks,
>
> -Sal.
>
>
> Salvador Ledezma
> IBM Silicon Valley Laboratory
> Phone: 408-463-4312  Tie Line: 8-543-4312
> Email: [hidden email]
>
>
> *Gavin Vess <[hidden email]>*
>
> 11/03/2006 10:50 AM
>
>
> To
> Richard Thomas <[hidden email]>
> cc
> [hidden email], Salvador Ledezma/Silicon Valley/IBM@IBMUS,
> [hidden email]
> Subject
> Re: [fw-server] DB2 install
>
>
>
>
>
>
>
>
> I'm hoping our DB2 expert, Salvador, will volunteer ... :)
>
> Richard Thomas wrote:
>  > Not sure if I mentioned this one, it is installed and running, not
>  > sure how we should handle administration/setup of dbs for users and such.
> --
> Cheers,
> Gavin
>
> Which ZF List?
> =================
> Everything, except the topics below: [hidden email]
>
> Authorization, Authentication, ACL, Access Control, Session Management
> [hidden email]
>
> Tests, Caching, Configuration, Environment, Logging
> [hidden email]
>
> All things related to databases
> [hidden email]
>
> Documentation, Translations, Wiki Manual / Tutorials
> [hidden email]
>
> Internationalization & Localization, Dates, Calendar, Currency, Measure
> [hidden email]
>
> Mail, MIME, PDF, Search, data formats (JSON, ...)
> [hidden email]
>
> MVC, Controller, Router, Views, Zend_Request*
> [hidden email]
>
> Community Servers/Services (shell account, PEAR channel, Jabber)
> [hidden email]
>
> Web Services & Servers (HTTP, SOAP, Feeds, XMLRPC, REST)
> [hidden email]
>
>
> How to un/subscribe:  http://framework.zend.com/wiki/x/GgE
>
>


--
Richard Thomas - CEO
Cyberlot Technologies Group Inc.
507.398.4124 - Voice
Salvador Ledezma

Re: DB2 install

Reply Threaded More More options
Print post
Permalink

Hi Richard,

A "phpmyadmin"-type of interface is "in development", but won't be available for a few months.  :(

In the meantime, the recommended tool for administration is the DB2 Control Center, an app that is part of the DB2 installation.  For more info, please take a look at: http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/t0021922.htm

A server can be remotely administered if the client has the control center installed, or something like "remote desktop" or "vnc" can be used as well.

Thanks,

-Sal.


Salvador Ledezma
IBM Silicon Valley Laboratory
Phone: 408-463-4312  Tie Line: 8-543-4312
Email: [hidden email]



Richard Thomas <[hidden email]>

11/03/2006 04:34 PM

To
Salvador Ledezma/Silicon Valley/IBM@IBMUS
cc
Gavin Vess <[hidden email]>, [hidden email], [hidden email]
Subject
Re: [fw-server] DB2 install





Its a dev box for framework people, so ease of setting up accounts for
users, some sort of phpmyadmin type interface would be nice ;)

Salvador Ledezma wrote:
>
> Hi Gavin/Richard,
>
> I missed the beginning of this thread, but DB2 in general follows
> operating system security for allowing DB2 users to connect to the
> database.  Once a connection to a database is made, access to specific
> db objects can be controlled via the SQL GRANT command.
>
> By default, db objects belong to the userid that created them and it is
> up to him/her to grant access.
>
> Not sure how sophisticated you would like to get with user mgmt, or if
> you have specific questions, but here is a link to a devworks article
> that gives a general overview on security:
> http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0508wasserman/
>
>
> What is your goal?  Strictly managing users or giving them free rein to
> create and manage databases?
>
> Thanks,
>
> -Sal.
>
>
> Salvador Ledezma
> IBM Silicon Valley Laboratory
> Phone: 408-463-4312  Tie Line: 8-543-4312
> Email: [hidden email]
>
>
> *Gavin Vess <[hidden email]>*
>
> 11/03/2006 10:50 AM
>
>                  
> To
>                  Richard Thomas <[hidden email]>
> cc
>                  [hidden email], Salvador Ledezma/Silicon Valley/IBM@IBMUS,
> [hidden email]
> Subject
>                  Re: [fw-server] DB2 install
>
>
>                  
>
>
>
>
>
> I'm hoping our DB2 expert, Salvador, will volunteer ... :)
>
> Richard Thomas wrote:
>  > Not sure if I mentioned this one, it is installed and running, not
>  > sure how we should handle administration/setup of dbs for users and such.
> --
> Cheers,
> Gavin
>
> Which ZF List?
> =================
> Everything, except the topics below: [hidden email]
>
> Authorization, Authentication, ACL, Access Control, Session Management
> [hidden email]
>
> Tests, Caching, Configuration, Environment, Logging
> [hidden email]
>
> All things related to databases
> [hidden email]
>
> Documentation, Translations, Wiki Manual / Tutorials
> [hidden email]
>
> Internationalization & Localization, Dates, Calendar, Currency, Measure
> [hidden email]
>
> Mail, MIME, PDF, Search, data formats (JSON, ...)
> [hidden email]
>
> MVC, Controller, Router, Views, Zend_Request*
> [hidden email]
>
> Community Servers/Services (shell account, PEAR channel, Jabber)
> [hidden email]
>
> Web Services & Servers (HTTP, SOAP, Feeds, XMLRPC, REST)
> [hidden email]
>
>
> How to un/subscribe:  http://framework.zend.com/wiki/x/GgE
>
>


--
Richard Thomas - CEO
Cyberlot Technologies Group Inc.
507.398.4124 - Voice

GavinZend

Re: [fw-db] Re: [fw-server] DB2 install

Reply Threaded More More options
Print post
Permalink
For the moment, perhaps we can setup a set of test accounts, test1,
test2, test3, etc.  For the moment, those using these DB2 accounts can
workaround any sharing problems by just coordinating with each other.

Cheers,
Gavin