INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

IBM mainframe password changing.....

IBM mainframe password changing.....

(OP)
We have a DB2 database on our mainframe and I use Microsoft Access to query the tables comprising the database. Sometimes I use a pass-thru query which uses my own credentials to login. Up until recently we could get around the scheduled password change of every 90 days, but not anymore. Is there a way to set your password to not expire?

RE: IBM mainframe password changing.....

If your security admins have tightened the security you would need to talk with them. Trying to get around security rules is often grounds for termination. . .

The organization believes that changing passwords regularly is more important than your bit of inconvenience.

They would probably not be happpy to know that you have embedded your password where it can be read as text. . .

RE: IBM mainframe password changing.....

(OP)
Otherwise they don't get their information. Mgmt is quick to skirt issues when THEY want something....isnt that right.

RE: IBM mainframe password changing.....


I deal with this every 60 days! It appears that password changes is synchronized with every system and database EXCEPT DB2! I and every one of my users that employ my DB2 application must deal with this.

BTW, it is NOT a particularly smart idea to circumvent with a stored PW. That is a HUGE NO NO!

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: IBM mainframe password changing.....

(OP)
How else would you do a pass thru

RE: IBM mainframe password changing.....



The ODBC Driver dialog [b]Open > Settings > Control Panel > Administrative Tools > Data Sources (ODBC) ....

Find your Driver in one or more of the DSN tabs and CONFIGURE the driver, with the CHANGED PASSWORD.

Otherwise the Password must be entered each time the pass thru is executed.

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: IBM mainframe password changing.....

(OP)
i have it stored in the control panel admin tools data sources.... but in the pass thru query dont you need it in the connect string .... the ODBC connect string.
ODBC;DSN=DB2PROD;UID=xxxxxx;PWD=yyyyyy;

RE: IBM mainframe password changing.....



using ADO objects, my connect string is defined...

CODE

cnn.Open "Provider=MSDASQL;Persist Security Info=False;" & _
                "User ID=;" & _
                "Extended Properties=""DSN=Shadow Direct DB2P 32-bit;" & _
                "UID=;PORT=6800;HOST=mvsb1;SUBSYS=DB2P;CPFX=SHADOW;AT=YES;" & _
                "DP=%;AF=YES;MXBU=40960;AUST=NO;CNTM=120;""" 
I believe I have a parameter set in the ODBC Configure dialog somewhere, to use the networkID, os User ID and UID are as above. NO PASSWORD parameter!!!

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: IBM mainframe password changing.....

(OP)
Interesting thankyou

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close