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)
Esempio n. 2
0
 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)
Esempio n. 3
0
 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())
Esempio n. 4
0
 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())
Esempio n. 6
0
    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())
Esempio n. 7
0
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())
Esempio n. 9
0
 def run_test_081(self):
     try:
         conn = ibm_db.connect(config.database, "y", config.password)
         print("??? No way.")
     except:
         print(ibm_db.conn_error())
Esempio n. 10
0
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)
Esempio n. 11
0
        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)
Esempio n. 12
0
 def run_test_080(self):
   try:
     conn = ibm_db.connect("x", config.user, config.password)
     print "??? No way."
   except:
     print ibm_db.conn_error()
 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: