Re: [IBMiOSS] IBM i python ibm_db_dbi example usage

On Thu, Jul 7, 2016 at 5:29 PM, Aaron Bartell <aaronbartell@xxxxxxxxx> wrote:

I don't know what my database is, and I'm not sure if I know what my

password is.

Select the 'i' icon on your Spaces home page and you will see your user and
three separate databases (schemas, libraries).

We have to be a little careful about terminology here. In an IBM
midrange context, "database" is not the same thing as "schema", though
it is pretty safe to use "schema" and "library" interchangeably.

A database at a typical IBM i shop contains many libraries, though I
suppose there is nothing preventing you from having a database which
contains just one library.

Are you saying that each of those three environments is its own
*database*, and that the names shown are the database names, as would
appear when entering the DSPRDBDIRE command at a native CL prompt?

Litmis Spaces operates off of passwordlessness (new word? :-) What I mean
is we definitely have passwords for IBM i profiles, but they are randomly
generated and not stored. Instead we opted to go with ssh keys for all
authentication into the machine.

That's a perfectly reasonable arrangement. It's probably what I would
opt for if I were setting up a similar service. But it creates the
issue of how to retrieve a password so that it can be used as a
parameter to the ibm_db.connect() method.

How do the other Spaces folks connect to the database?

John Y.