DB2 install

[cyberlot]

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]

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: fw-general@...

Authorization, Authentication, ACL, Access Control, Session Management
fw-auth@...

Tests, Caching, Configuration, Environment, Logging
fw-core@...

All things related to databases
fw-db@...

Documentation, Translations, Wiki Manual / Tutorials
fw-docs@...

Internationalization & Localization, Dates, Calendar, Currency, Measure
fw-i18n@...

Mail, MIME, PDF, Search, data formats (JSON, ...)
fw-formats@...

MVC, Controller, Router, Views, Zend_Request*
fw-mvc@...

Community Servers/Services (shell account, PEAR channel, Jabber)
fw-server@...

Web Services & Servers (HTTP, SOAP, Feeds, XMLRPC, REST)
fw-web@...


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

[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: [phone]  Tie Line: 8-543-4312
> Email: ledezma@...
>
>
> *Gavin Vess <gavin@...>*
>
> 11/03/2006 10:50 AM
>
>
> To
> Richard Thomas <lists@...>
> cc
> fw-server@..., Salvador Ledezma/Silicon Valley/IBM@IBMUS,
> fw-db@...
> 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: fw-general@...
>
> Authorization, Authentication, ACL, Access Control, Session Management
> fw-auth@...
>
> Tests, Caching, Configuration, Environment, Logging
> fw-core@...
>
> All things related to databases
> fw-db@...
>
> Documentation, Translations, Wiki Manual / Tutorials
> fw-docs@...
>
> Internationalization & Localization, Dates, Calendar, Currency, Measure
> fw-i18n@...
>
> Mail, MIME, PDF, Search, data formats (JSON, ...)
> fw-formats@...
>
> MVC, Controller, Router, Views, Zend_Request*
> fw-mvc@...
>
> Community Servers/Services (shell account, PEAR channel, Jabber)
> fw-server@...
>
> Web Services & Servers (HTTP, SOAP, Feeds, XMLRPC, REST)
> fw-web@...
>
>
> How to un/subscribe:  http://framework.zend.com/wiki/x/GgE
>
>

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

[Salvador Ledezma]

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: [phone]  Tie Line: 8-543-4312
Email: ledezma@...

Richard Thomas <lists@...>

11/03/2006 04:34 PM

To	Salvador Ledezma/Silicon Valley/IBM@IBMUS
cc	Gavin Vess <gavin@...>, fw-db@..., fw-server@...
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: [phone]  Tie Line: 8-543-4312
> Email: ledezma@...
>
>
> *Gavin Vess <gavin@...>*
>
> 11/03/2006 10:50 AM
>
>                  
> To
>                  Richard Thomas <lists@...>
> cc
>                  fw-server@..., Salvador Ledezma/Silicon Valley/IBM@IBMUS,
> fw-db@...
> 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: fw-general@...
>
> Authorization, Authentication, ACL, Access Control, Session Management
> fw-auth@...
>
> Tests, Caching, Configuration, Environment, Logging
> fw-core@...
>
> All things related to databases
> fw-db@...
>
> Documentation, Translations, Wiki Manual / Tutorials
> fw-docs@...
>
> Internationalization & Localization, Dates, Calendar, Currency, Measure
> fw-i18n@...
>
> Mail, MIME, PDF, Search, data formats (JSON, ...)
> fw-formats@...
>
> MVC, Controller, Router, Views, Zend_Request*
> fw-mvc@...
>
> Community Servers/Services (shell account, PEAR channel, Jabber)
> fw-server@...
>
> Web Services & Servers (HTTP, SOAP, Feeds, XMLRPC, REST)
> fw-web@...
>
>
> How to un/subscribe:  http://framework.zend.com/wiki/x/GgE
>
>


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

[GavinZend]

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