def run_test_082(self): try: conn = ibm_db.connect(config.database, config.user, "z") print("??? No way.") except: err = ibm_db.conn_error() print(err)
def run_test_080(self): try: if sys.platform == 'zos': conn = ibm_db.connect("x", getpass.getuser(), config.password) else: conn = ibm_db.connect("x", config.user, config.password) print("??? No way.") except: print(ibm_db.conn_error())
def retrieve_and_store(self): global global_fifo_q while True: if not global_fifo_q.empty(): #Check for active connection data_from_q = global_fifo_q.get() #Format datatime db2_datetime = data_from_q[1].strftime('%Y-%m-%d-%H.%M.%S.%f') #print (db2_datetime) #print(data_from_q) try: stmt = ibm_db.prepare( self.dbconn, "insert into mrj3017.python_test1 (col1, col2, col3) values (?,?,?)" ) ibm_db.execute(stmt, ( data_from_q[0], db2_datetime, data_from_q[2], )) except: print("Transaction couldn't be completed:") print(ibm_db.stmt_errormsg()) print(ibm_db.stmt_error()) if (ibm_db.conn_error()): print("conn_error, will retry after 5 seconds:") print(ibm_db.conn_error()) while True: time.sleep(5) try: self.dbconn = ibm_db.connect( self.target_db, self.db_user, self.db_pass) if (self.dbconn): print("Connection reconnected to :" + self.target_db) break except: print("NO connection to :" + self.target_db)
def run_test_071(self): conn = ibm_db.connect(config.database, config.user, config.password) if conn: rc = ibm_db.close(conn) if (rc == True): print("ibm_db.close succeeded") else: print("ibm_db.close FAILED\n") else: print("%s" % ibm_db.conn_errormsg()) print(",sqlstate=%s" % ibm_db.conn_error()) print("%s" % ibm_db.conn_errormsg()) print("%s" % ibm_db.conn_errormsg()) print("%s" % ibm_db.conn_errormsg()) print("%s" % ibm_db.conn_errormsg())
def conectaDB2(): try: conn = ibm_db.pconnect( "DATABASE=" + database + "; HOSTNAME=" + hostname + "; PORT=" + port + "; PROTOCOL=" + protocol + "; UID=" + userid + "; PWD=" + password + ";", '', '') except: print('Connection fault with DATABASE!\nError Code: {0}'.format( ibm_db.conn_error())) sys.exit() info = ibm_db.client_info(conn) print( 'CONNECTED! DATA_SOURCE_NAME: {0} CONN_CODEPAGE: {3} DRIVER_NAME: {1} DRIVER_ODBC_VER: {2} ODBC_VER: {4}' .format(info.DATA_SOURCE_NAME, info.DRIVER_NAME, info.DRIVER_ODBC_VER, info.CONN_CODEPAGE, info.ODBC_VER)) return conn
def run_test_081(self): try: conn = ibm_db.connect(config.database, "y", config.password) print("??? No way.") except: print(ibm_db.conn_error())
def run_sql(db_name): global global_fifo_q str = open('C:/Users/sxk11/PycharmProjects/Safari_1/test.txt', 'r').read() #print (db_name) try: conn = ibm_db.connect(db_name, 'tu01945', str) except: print("NO connection to :" + db_name) #print(ibm_db.stmt_errormsg()) #print(ibm_db.stmt_error()) if (ibm_db.conn_error()): print("conn_error:") print(ibm_db.conn_error()) while True: time.sleep(5) try: conn = ibm_db.connect(db_name, 'tu01945', str) if (conn): print("Connection reconnected to :" + db_name) break except: print("NO connection to :" + db_name) #Send Notification #Retry else: print("The connection to " + db_name + " was successful!") #print (conn) sql = 'select snapshot_timestamp, db_name, catalog_partition from sysibmadm.snapdb' #time.sleep(30) while True: try: stmt = ibm_db.exec_immediate(conn, sql) #stmt = ibm_db.prepare(conn, sql) #ibm_db.execute(stmt) except: print("Transaction couldn't be completed:") print(ibm_db.stmt_errormsg()) print(ibm_db.stmt_error()) if (ibm_db.conn_error()): print("conn_error:") print(ibm_db.conn_error()) while True: time.sleep(5) try: conn = ibm_db.connect(db_name, 'tu01945', str) if (conn): print("Connection reconnected to :" + db_name) break except: print("NO connection to :" + db_name) else: tuple = ibm_db.fetch_tuple(stmt) while tuple != False: #print("The time is : ", tuple[0]) #print("The catalog name is : ", tuple[1]) #print("The catalog partition is : ", tuple[2]) #Store Data in queue data = (tuple[1], tuple[0], tuple[2]) global_fifo_q.put(data) #Get next tuple = ibm_db.fetch_tuple(stmt) time.sleep(10)
else: schema2 = schema1 conn2 = get_connection(dbname2, hostname2, port2, userid2, password2) if args.output_file: fout = open(args.output_file, 'w') else: fout = sys.stdout print_legend(args.hostname1, hostname2) # Compare DNs/ModifyTimestamp from first and second LDAP servers compare_all_entry_modify_timestamps(args.hostname1, conn1, schema1, hostname2, conn2, schema2, fout) endtime = datetime.utcnow() logger.info("End of Script: {}".format(endtime)) print("Script ran for: {}".format(endtime - starttime)) except Exception as e: conn_error = ibm_db.conn_error() stmt_error = ibm_db.stmt_error() if conn_error != '': print("Error Code: {} Msg: {}".format(conn_error, ibm_db.conn_errormsg())) if conn1: print("Connection issue with server#2 most probably.") else: print("Connection issue with server#1 most probably.") elif stmt_error != '': print("Error Code: {} Msg: {}".format(stmt_error, ibm_db.stmt_errormsg())) raise e finally: if fout and fout is not sys.stdout: fout.close() if conn1: ibm_db.close(conn1)
def run_test_080(self): try: conn = ibm_db.connect("x", config.user, config.password) print "??? No way." except: print ibm_db.conn_error()
connString = "ATTACH=FALSE" # Attach To A Database; Not A Server connString += ";DATABASE=" + dbName # Required To Connect To A Database connString += ";PROTOCOL=TCPIP" connString += ";UID=" + userID connString += ";PWD=" + passWord # Attempt To Establish A Connection To The Database Specified try: dbConnection = ibm_db.connect(connString, '', '') except Exception: pass # If A Db2 Database Connection Could Not Be Established, Display An Error Message And Exit if dbConnection is None: print("\nERROR: Unable to connect to the \'" + dbName + "\' database.") errorCode = ibm_db.conn_error() print("\nSQLSTATE: "+ errorCode + "\n") exit(-1) # Otherwise, Complete The Status Message else: print("Done!\n") # Add Additional Db2 Database-Related Processing Here ... # Attempt To Close The Db2 Database Connection That Was Just Opened if not dbConnection is None: print("Disconnecting from the \'" + dbName + "\' database ... ", end="") try: