Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Password for SAMPLE database after creating it?

595 views
Skip to first unread message

Rhino

unread,
Feb 12, 2016, 5:53:42 PM2/12/16
to
If I use the db2sampl command to create the SAMPLE database in DB2
10.5.5 in a Windows 10 environment, the tables seem to be owned by my
Windows ID. What password does DB2 assign to that ID when it does so?

I'd like to access that those tables via Data Studio but can't figure
out what password to give it when creating the connection to my Windows ID.

(I may be having a Stupid Day and will probably kick myself when I get
the answer.)

--
Rhino

Gregor Kovač

unread,
Feb 13, 2016, 6:14:40 AM2/13/16
to
DB2 uses user authentication from OS. So type in the username/password of the user that created the database.

Larry

unread,
Feb 13, 2016, 5:14:43 PM2/13/16
to
If you use an existing windows id, it would be the same password as it
had before. If you created a new one, I could swear that it prompts you
to enter a password but I haven't installed on Windows in a while.

--
Larry E.

--- news://freenews.netfront.net/ - complaints: ne...@netfront.net ---

Rhino

unread,
Feb 14, 2016, 12:01:56 PM2/14/16
to
On 2/12/2016 5:53 PM, Rhino wrote:
Thanks very much, Gregor and Larry!

I figured that DB2 would use Windows authentication but I got confused
because Windows truncated my user ID - which is my email address - after
the 5th letter, for some reason.

I use my whole email address to sign in to Windows and I use a PIN for
my Windows, not a password. However, there *is* still a password on the
email address so I used that and finally DB2 let me sign in with the
first 5 characters of my email address as the ID and my complete password.

--
Rhino
0 new messages