SAP DB:ODBC Bedienungsanleitung Seite 1

1

For nearly all aspects concerning the MaxDB ODBC driver the most important information is whether Content Server is running on Windows or UNIX/Linux.

11

The usage of the SAP MaxDB database as storage host for the Content Server was initially developed for the use on Windows. The request for a document

13

14

In the administration transaction CSADMIN the repository setting tab shows the name of the database server, the name of the Content Server database, t

If you are facing problems in the Content Server environment it makes sense to register only one ODBC driver which should be used by the Content Serve

After typing the command odbcreg –t <driver_name> the shown pop up windows appears. The needed information for the ODBC connect test is: 1)se

18

After disabling the ODBC trace the IIS web server should be restarted again to make sure that the Content Server and the web server will notice the st

2

The “show all” command of the odbc_cons tool shows the tracing configuration and the current trace options if the ODBC trace is turned on. The first s

21

For Microsoft Windows systems, extend all of the tracing commands with system user authorization -u "NT AUTHORITY\SYSTEM" as shown in exam

23

The ODBC trace starts with the version of the used ODBC driver and operating system. In the ODBC trace it is also shown the ODBC driver name with whi

25

The usage of SAP MaxDB database as storage host for the Content Server was additionally developed for UNIX/Linux operating systems. The request for a

It is important to keep in mind that on UNIX/Linux the ODBC driver is part of the Content Server installation as a statically linked shared library.

The correct way to activate the ODBC trace is to change the configuration file using the transaction CSADMIN. By calling the administration transactio

The repository setting shows the name of the database server, the name of the Content Server database, the name of the used ODBC driver on the databas

3

The excerpt from the ODBC trace S3:MASS STATEMENT : FETCH "SQL_CURSOR_0013" EXECUTE: CMD : PARSEID: INPUT : 00003408 00000D01 2A002

SQLERRD(INDEX_3) : 1 START : DATE : 2013-09-04 TIME : 0014:42:42 END : DATE : 2013-09-04 TIME : 0014:42:42 S3:CLOSE "S

The excerpt from the ODBC trace S3:SELECT USEDPERM, UNUSED, USEDLOG, LOGSIZE FROM SERVERDBSTATISTICS EXECUTE: CMD : PARSEID: INPUT : 00003408 00

32

The content server is usually operated as a black box. Very often a very simple problem causes effects and error messages on different levels. With t

34

Problems on content server often have to be handled with interdisciplinary skills. It is not unusual that there is a see-saw between the MaxDB compone

You see an excerpt from the created ODBC trace which helped the developer to identify the cause. Even if the created trace is shown in plain text it i

Even if there is not an error in ODBC driver 7.8 which could be fixed the recommended solution was to switch back to 7.6 ODBC as it is less exact and

38

Knowledge Provider is the central service in SAP Basis for administrating and storing any kind of documents.  KPro provides different services, for

39

40

41

42

43

44

45

46

47

48

The CMS functions are also used by the Content Server Engine. The MaxDB software is delivered with every Content Server installation as of SAP Conten

The Content Server sends the URL query firstly to the WebServer. It is IIS (Internet Information Services) web server on Windows operation system or A

7

The Content Server configuration file name is ContentServer.INI on Windows and cs.conf on Linux/UNIX. The content of the file is independent of the op

On Windows the ODBC driver used by the Content Server should be registered on OS side under the same name as defined in the configuration file. If dif