IBM Books

Image, Audio, Video Extender °ü¸® ¹× ÇÁ·Î±×·¡¹Ö

¿¹½Ã

´ÙÀ½ÀÇ ¿¹½Ã¿¡¼­, µ¥ÀÌÅͺ£À̽º´Â ±âº» Å×ÀÌºí °ø°£À» »ç¿ë ÁßÀÎ À̹ÌÁö µ¥ÀÌÅ͸¦ º¸À¯Çϱâ À§ÇØ »ç¿ë °¡´ÉÈ­µË´Ï´Ù.

API »ç¿ë: ´ÙÀ½ ±×¸²ÀÇ ÄÚµå´Â ¸ÕÀú ±âÁ¸ÀÇ µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áÇϰí À̸¦ »ç¿ëÇÒ ¼ö ÀÖ°Ô ÇÕ´Ï´Ù. ÀÌ ¿¹½Ã´Â DB2 ÄÝ ·¹º§ ÀÎÅÍÆäÀ̽º¸¦ »ç¿ëÇÏ¿© ÀÛ¼ºµË´Ï´Ù. ¿©±â¿¡´Â ÀϺΠ¼³Á¤ ¹× ¿À·ù Á¡°Ë Äڵ尡 Æ÷ÇԵ˴ϴÙ. ¿ÏÀüÇÑ »ùÇà ÇÁ·Î±×·¥Àº SAMPLES ¼­ºêµð·ºÅ丮ÀÇ ENABLE.C ÆÄÀÏ¿¡ ÀÖ½À´Ï´Ù.

±×¸² 10. µ¥ÀÌÅͺ£À̽ºÀÇ »ç¿ëÀ» °¡´ÉÇÏ°Ô ÇÏ´Â »ùÇà ÄÚµå

/*---- Set-up -------------------------------------------------*/
#include <stdio.h>
#include <stlib.h>
#include <string.h>
#include "dmbimage.h"       /* image extender function prototypes (DBi) */
#include "utility.h"        /* utility functions */
 
#define MMDB_ERROR_MSG_TEXT_LEN         1000
#define SERVER_IS_DB2390 (strcmp(dbms,"DB2")==0 || strcmp(dmbs,"DSN06010")==0)
 
int
main(int argc, char *argv[])
{
        SQLHENV henv = SQL_NULL_HENV;
        SQLHDBC hdbc = SQL_NULL_HDBC;
        SQLHSTMT hstmt = SQL_NULL_HSTMT;
        SQLCHAR uid[18+1];
        SQLCHAR pwd[30+1];
        SQLCHAR dbname[SQL_MAX_DSN_LENGTH+1];
        SQLCHAR buffer[500];
        SQL SMALLINT dbms_sz = 0;
        char    dbms[20];
 
        SQLRETURN rc = SQL_SUCCESS;
        SQLINTEGER sqlcode = 0;
        char errorMsgText[MMDB_ERROR_MSG_TEXT_LEN+1];
        char *program = "enable;
        char *step;
 
/*---- Prompt for database name, userid, and password ----*/
        if (argc > 5) ||  (argc >=2 && strcmp(argv[1],"?")== 0))
          {
            printf("Syntax for enable - enabling a DB2 UDB database: \n"
                   "   enable database_name userid password\n");
            exit(0);
          }
 
        if (argc == 4) {
          strcpy((char *)dbname, argv[1]);
          strcpy((char *)uid   , argv[2]);
          strcpy((char *)pwd   , argv[3]);
          }
        else {
          printf("Enter database name:\n");
          gets((char *) dbName);
          printf("Enter userid:\n");
          gets((char *) uid);
          printf("Enter password:\n");
          gets((char *) pwd);
          }
/*----- connect to the database -----------------------------------------------*/
         rc = cliInitialize(&henv, &hdbc, dbname, uid, pwd);
         cliCheckError(henv, hdbc, SQL_NULL_HSTMT, rc);
         if (rc < 0) goto SERROR;
 
/*----- find out if application is connected to DB2/UDB or DB2/390?------------*/
         rc = SQLGetInfo(hdbc, SQL_DBMS_NAME, (SQLPOINTER) &dbms,
                         sizeof(dbms), &dbms_sz);
         cliCheckError(henv, hdbc, SQL_NULL_HSTMT, rc);
         if (rc < 0) goto SERROR;
 
/****** enable server for image extender ****************************************/
         if (!SERVER_IS_DB2390)
           {
            printf("%s: Enabling database......\n", program);
           }
         printf("%s: This may take a few minutes, please wait......\n", program);
 
         if (!SERVER_IS_DB2390)
           {
            step="DBiEnableDatabase with NULL tablespace"
            rc=DBiEnableDatabase(NULL);
           }
         if (rc < 0) {
            printf ("%s: %s failed!\n", program, step);
            printMsg(rc);
            DBiGetError(&sqlcode, errorMsgText);
            if (sqlcode)
              printf("sqlcode=%i, ",sqlcode);
         }else if (rc > 0) {
            printf("%s: %s, warning detected.\n", program, step);
            printMsg(rc);
            DBiGetError(&sqlcode, errorMsgText);
            printf("warning MsgText=%s\n", errorMsgText);
         } else
            printf("%s: %s OK\n", program, step);
/****** end of enable server *************************************************/
 

db2ext ¸í·ÉÇà »ç¿ë: ÀÌ ¿¹½Ã¿¡¼­, µ¥ÀÌÅͺ£À̽º´Â ÀÌ¹Ì ¿¬°áµÇ¾î ÀÖ½À´Ï´Ù.

enable database for db2image


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]