configuracion otro servidor error dbimport + error drop database

hola:

Tengo la siguiente configuracion en un servidor de prueba (de otra facultad), y cuando quiero importar una base (el dbexport esta correcto), empieza a importar y cuando llegas a 1890 kb, se sale del dbimport, y ademas no me deja dropear la base (me dice que no tengo permisos). alguna solucion?. muchisimas gracias!!!

#**************************************************************************

INFORMIX SOFTWARE, INC.

Title: onconfig.std

Description: Informix Dynamic Server Configuration Parameters

#**************************************************************************

Root Dbspace Configuration

ROOTNAME rootdbs # Root dbspace name
ROOTPATH C:\IFMXDATA\ol_guarani\rootdbs_dat.000
# Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 30720 # Size of root dbspace (Kbytes)

Disk Mirroring Configuration Parameters

MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)

Physical Log Configuration

PHYSDBS physicallogs # Location (dbspace) of physical log
PHYSFILE 800000 # Physical log file size (Kbytes)

Logical Log Configuration

#LOGFILES 9 # Number of logical log files
##########################

agregado pablo LOGFILES#

##########################
LOGFILES 30 # Number of logical log files
#LOGSIZE 200000 # Logical log size (Kbytes)
#########################

agregado pablo LOGSIZE#

#########################
LOGSIZE 15000 # Logical log size (Kbytes)
LOG_BACKUP_MODE MANUAL # Logical log backup mode (MANUAL, CONT)

Diagnostics

MSGPATH C:\informix\ol_guarani.log # System message log file path
CONSOLE C:\informix\conol_guarani.log # System console message path
ALARMPROGRAM C:\informix\etc\log_full.bat # Alarm program path
TBLSPACE_STATS 1 # Maintain tblspace statistics

System Diagnostic Script.

SYSALARMPROGRAM - Full path of the system diagnostic script (e.g.

c:\informix\etc\evidence.bat.) Set this parameter

if you want a different Diagnostic Script than

{INFORMIXDIR}\etc\evidence.bat, which is default.

System Archive Tape Device

#TAPEDEV nul # Tape device path
##########################

agregado pablo TAPEDEV#

##########################
TAPEDEV C:\IFMXBKUP\backup.bak # Tape device path

APEBLK 16 # Tape block size (Kbytes)
#TAPESIZE 10240 # Maximum amount of data to put on
tape (Kbytes)
##########################

agregado pablo TAPESIZE#

##########################
TAPESIZE 2147483647 # Maximum amount of data to put on tape (Kbytes)

Log Archive Tape Device

#LTAPEDEV nul # Log tape device path
LTAPEDEV C:\IFMXBKUP\Logical.bak # Log tape device path
LTAPEBLK 16 # Log tape block size (Kbytes)
#LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes)
##########################

agregado pablo LTAPESIZE#

##########################
LTAPESIZE 2147483647 # Max amount of data to put on log tape (Kbytes)

Optical

STAGEBLOB # Informix Dynamic Server/Optical staging area
OPTICAL_LIB_PATH # Location of Optical Subsystem driver DLL

System Configuration

SERVERNUM 0 # Unique id corresponding to a server instance
DBSERVERNAME ol_guarani # Name of default Dynamic Server
DBSERVERALIASES # List of alternate dbservernames
NETTYPE soctcp,1,NET # Override sqlhosts nettype parameters
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
#RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
##########################

agregado pablo RESIDENT#

##########################
RESIDENT 1 # Forced residency flag (Yes = 1, No = 0)
MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor
NUMCPUVPS 1 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one

NOAGE 0 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors

Shared Memory Parameters

#LOCKS 2000 # Maximum number of locks
#######################

agregado pablo LOCKS#

#######################
LOCKS 10000 # Maximum number of locks
BUFFERS 200 # Maximum number of shared buffers
NUMAIOVPS 1 # Number of IO vps
PHYSBUFF 32 # Physical log buffer size (Kbytes)
#LOGBUFF 32 # Logical log buffer size (Kbytes)
#########################

agregado pablo LOGBUFF#

#########################
LOGBUFF 64 # Logical log buffer size (Kbytes)

LOGSMAX 200 # Maximum number of logical log files
CLEANERS 1 # Number of buffer cleaner processes
SHMBASE 0xc000000 # Shared memory base address
SHMVIRTSIZE 8192 # initial virtual shared memory segment size
#SHMADD 8192 # Size of new shared memory segments (Kbytes)
#######################

agregado pablo SHMAD#

#######################
SHMADD 32768 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
#CKPTINTVL 300 # Check point interval (in sec)
###########################

agregado pablo CKPTINTVL#

###########################

CKPTINTVL 120 # Check point interval (in sec)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
LTXHWM 50 # Long transaction high water mark percentage
LTXEHWM 60 # Long transaction high water mark (exclusive)
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 64 # Stack size (Kbytes)

System Page Size

BUFFSIZE - Dynamic Server no longer supports this configuration parameter.

To determine the page size used by Dynamic Server on your platform

see the last line of output from the command, ‘onstat -b’.

Recovery Variables

OFF_RECVRY_THREADS:

Number of parallel worker threads during fast recovery or an offline restore.

ON_RECVRY_THREADS:

Number of parallel worker threads during an online restore.

OFF_RECVRY_THREADS 10 # Default number of offline worker threads
ON_RECVRY_THREADS 1 # Default number of online worker threads

Data Replication Variables

DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
DRTIMEOUT 30 # DR network timeout (in sec)
DRLOSTFOUND \tmp # DR lost+found file path

CDR Variables

CDR_LOGBUFFERS 2048 # size of log reading buffer pool (Kbytes)
CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR queue (Kbytes)
CDR_LOGDELTA 30 # % of log space allowed in queue memory
CDR_NUMCONNECT 16 # Expected connections per server
CDR_NIFRETRY 300 # Connection retry (seconds)
CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9 max)

Backup/Restore variables

BAR_ACT_LOG C:\informix\bar_ol_guarani.log #Path of log file for onbar.exe
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 15
BAR_BSALIB_PATH C:\ISM\2.20\bin\libbsa.dll # Location of ISM XBSA DLL

RESTARTABLE_RESTORE off #To support restartable restore…values on/off

Informix Storage Manager variables

ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs

Read Ahead Variables

#RA_PAGES # Number of pages to attempt to read ahead
##########################

agregado pablo RA_PAGES#

##########################
RA_PAGES 10 # Number of pages to attempt to read ahead
#RA_THRESHOLD # Number of pages left before next group
##########################

agregado pablo RA_PAGES#

##########################
RA_THRESHOLD 5 # Number of pages left before next group

DBSPACETEMP:

Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces

that the Dynamic Server SQL Engine will use to create temp tables etc.

If specified it must be a colon separated list of dbspaces that exist

when the Dynamic Server system is brought online. If not specified, or if

all dbspaces specified are invalid, various ad hoc queries will create

temporary files in /tmp instead.

#DBSPACETEMP # Default temp dbspaces
#############################

agregado pablo DBSPACETEMP#

#############################
DBSPACETEMP C:\IFMXDATA\ol_guarani\tempdbs_dat.000 # Default temp dbspaces

DUMP*:

The following parameters control the type of diagnostics information which

is preserved when an unanticipated error condition (assertion failure) occurs

during Dynamic Server operations.

For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.

DUMPDIR C:\tmp # Preserve diagnostics in this directory
DUMPSHMEM 1 # Dump a copy of shared memory
DUMPGCORE 0 # Dump a core image using ‘gcore’
DUMPCORE 0 # Dump a core image (Warning:this aborts Dynamic
DUMPCNT 1 # Number of shared memory or gcore dumps for
# a single user’s session

FILLFACTOR 90 # Fill factor for building indexes

method for Dynamic Server to use when determining current time

USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow)

Parallel Database Queries (pdq)

#MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
#################################

agregado pablo MAX_PDQPRIORITY#

#################################
MAX_PDQPRIORITY 50 # Maximum allowed pdqpriority
#DS_MAX_QUERIES 32 # Maximum number of decision support queries
################################

agregado pablo DS_MAX_QUERIES#

################################
DS_MAX_QUERIES 10 # Maximum number of decision support queries

DS_TOTAL_MEMORY 4096 # Decision support memory (Kbytes)

#DS_MAX_SCANS 1048576 # Maximum number of decision support scans
##############################

agregado pablo DS_MAX_SCANS#

##############################
DS_MAX_SCANS 20 # Maximum number of decision support scans

DATASKIP off # List of dbspaces to skip

OPTCOMPIND

0 => Nested loop joins will be preferred (where

possible) over sortmerge joins and hash joins.

1 => If the transaction isolation mode is not

“repeatable read”, optimizer behaves as in (2)

below. Otherwise it behaves as in (0) above.

2 => Use costs regardless of the transaction isolation

mode. Nested loop joins are not necessarily

preferred. Optimizer bases its decision purely

on costs.

#OPTCOMPIND 2 # To hint the optimizer
##############################

agregado pablo OPTCOMPIND#

##############################
OPTCOMPIND 1 # To hint the optimizer

DIRECTIVES 1 # Optimizer DIRECTIVES ON (1/Default) or OFF (0)

ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
LBU_PRESERVE 0 # Preserve last log for log backup
OPCACHEMAX 0 # Maximum optical cache size (Kbytes)

HETERO_COMMIT (Gateway participation in distributed transactions)

1 => Heterogeneous Commit is enabled

0 (or any other value) => Heterogeneous Commit is disabled

HETERO_COMMIT 0

SBSPACENAME sbspace # Default sbspace

BLOCKTIMEOUT 3600 # Default timeout for system block

Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS

OPT_GOAL -1

ALLOW_NEWLINE 0 # embedded newlines(Yes = 1, No = 0 or anything but 1)
SYSSBSPACENAME sbspace # Default System sbspace

The following are default settings for enabling Java in the database.

#VPCLASS jvp,num=1 # Number of JVPs to start with
JVPJAVAHOME # JDK installation root directory
JVPHOME C:\informix\extend\krakatoa # Krakatoa installation directory
JVPPROPFILE C:\informix\extend\krakatoa.jvpprops_ol_guarani
# JVP property file
JDKVERSION 1.2 # JDK version supported by this server
JVMTHREAD native # Java VM thread type (green or native)

The path to the JRE libraries relative to JVPJAVAHOME

JVPJAVALIB \jre\bin\

The JRE libraries to use for the Java VM

JVPJAVAVM hpi;jvm;java;net;math;zip;jpeg

Classpath to use upon Java VM start-up (use _g version for debugging)

JVPCLASSPATH C:\informix\extend\krakatoa\krakatoa.jar;C:\informix\extend\krakatoa\jdbc.jar

JVPLOGFILE C:\informix\extend\krakatoa/jvp.log # JVP log file.

Hola Pablo

No dice porque sale del dbimport?

La solución para estos casos suele ser separar el archivo sql de la base en uno con la importación de tablas y otro con procedures, triggers, etc.

Dejas la importación de datos con el mismo nombre e intentas importarla.
Luego corres desde el sql editor el otro archivo.

Emilio

hola emilio:

No dice nada se corta , no dice si se queda sin espacio u otro problema.

gracias!!!

La conf está bastante fea…
Adjuntar la salida del

onstat -d

A primera vista tiene el tamaño del rootdbs muy pequeño:

ROOTSIZE        30720           # Size of root dbspace (Kbytes)

Muy poca memoria compartida, está para que levante lo que viene por defecto, y el tamaño del segmento que agrega si necesita mas es mas grande que el inicial. Debería ser al revés:

SHMVIRTSIZE     8192            # initial virtual shared memory segment size
#SHMADD          8192            # Size of new shared memory segments (Kbytes)
#######################
# agregado pablo SHMAD#
#######################
SHMADD          32768 

La directiva del dbspace temporal debe ser el nombre de un dbspace del tipo temporal, no el nombre de un archivo:

DBSPACETEMP        C:\IFMXDATA\ol_guarani\tempdbs_dat.000             # Default temp dbspaces

Fijate de cambiar esto y despues se podrá seguir afinando la conf.
Saludos

Concuerdo con Damián. Y donde Damián dice “debe ser el nombre de un dbspace del tipo temporal” se debe entender que es el nombre logico del dbspace, no el nombre real del archivo físico asignado.

Por otra parte, habría que agregarle un chunk al rootdbspace o regenerar el motor con un tamaño de rootdbspace más grande.

Saludos

Gustavo

hola:

adjunto lo que me dio ontape -d, y modique el onconfig con lo que me dijeronn (muchas gracias)y con lo que vi en la comunidad.
Con esta configuracion pude importar la base, primero las tablas, procedimientos y luego triggers. Pero todavia no puedo eliminar las otras base que estan corruptas, adjunto imagen.
onconfig:
#**************************************************************************

INFORMIX SOFTWARE, INC.

Title: onconfig.std

Description: Informix Dynamic Server Configuration Parameters

#**************************************************************************

Root Dbspace Configuration

ROOTNAME rootdbs # Root dbspace name
ROOTPATH C:\IFMXDATA\ol_guarani\rootdbs_dat.000
# Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 30720 # Size of root dbspace (Kbytes)

Disk Mirroring Configuration Parameters

MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)

Physical Log Configuration

PHYSDBS physicallogs # Location (dbspace) of physical log
PHYSFILE 800000 # Physical log file size (Kbytes)

Logical Log Configuration

#LOGFILES 9 # Number of logical log files
##########################

agregado pablo LOGFILES#

##########################
LOGFILES 60 # Number of logical log files
#LOGSIZE 200000 # Logical log size (Kbytes)
#########################

agregado pablo LOGSIZE#

#########################
LOGSIZE 15000 # Logical log size (Kbytes)
LOG_BACKUP_MODE MANUAL # Logical log backup mode (MANUAL, CONT)

Diagnostics

MSGPATH C:\informix\ol_guarani.log # System message log file path
CONSOLE C:\informix\conol_guarani.log # System console message path
ALARMPROGRAM C:\informix\etc\log_full.bat # Alarm program path
TBLSPACE_STATS 1 # Maintain tblspace statistics

System Diagnostic Script.

SYSALARMPROGRAM - Full path of the system diagnostic script (e.g.

c:\informix\etc\evidence.bat.) Set this parameter

if you want a different Diagnostic Script than

{INFORMIXDIR}\etc\evidence.bat, which is default.

System Archive Tape Device

#TAPEDEV nul # Tape device path
##########################

agregado pablo TAPEDEV#

##########################
TAPEDEV C:\IFMXBKUP\backup.bak # Tape device path

#TAPESIZE 10240 # Maximum amount of data to put on
##########################

agregado pablo TAPESIZE#

##########################
TAPESIZE 2147483647 # Maximum amount of data to put on tape (Kbytes)

Log Archive Tape Device

#LTAPEDEV nul # Log tape device path
LTAPEDEV C:\IFMXBKUP\Logical.bak # Log tape device path
LTAPEBLK 16 # Log tape block size (Kbytes)
#LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes)
##########################

agregado pablo LTAPESIZE#

##########################
LTAPESIZE 2147483647 # Max amount of data to put on log tape (Kbytes)

Optical

STAGEBLOB # Informix Dynamic Server/Optical staging area
OPTICAL_LIB_PATH # Location of Optical Subsystem driver DLL

System Configuration

SERVERNUM 0 # Unique id corresponding to a server instance
DBSERVERNAME ol_guarani # Name of default Dynamic Server
DBSERVERALIASES # List of alternate dbservernames
NETTYPE soctcp,1,NET # Override sqlhosts nettype parameters
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
#RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
##########################

agregado pablo RESIDENT#

##########################
RESIDENT 1 # Forced residency flag (Yes = 1, No = 0)
MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor
NUMCPUVPS 1 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one

NOAGE 0 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors

Shared Memory Parameters

#LOCKS 2000 # Maximum number of locks
#######################

agregado pablo LOCKS#

#######################
LOCKS 20000 # Maximum number of locks
#BUFFERS 200 # Maximum number of shared buffers
#########################

agregado pablo BUFFERS#

#########################
BUFFERS 30000 # Maximum number of shared buffers
NUMAIOVPS 1 # Number of IO vps
PHYSBUFF 32 # Physical log buffer size (Kbytes)
#LOGBUFF 32 # Logical log buffer size (Kbytes)
#########################

agregado pablo LOGBUFF#

#########################
LOGBUFF 64 # Logical log buffer size (Kbytes)

LOGSMAX 200 # Maximum number of logical log files
CLEANERS 1 # Number of buffer cleaner processes
SHMBASE 0xc000000 # Shared memory base address
SHMVIRTSIZE 625000 # initial virtual shared memory segment size
#SHMADD 8192 # Size of new shared memory segments (Kbytes)
#######################

agregado pablo SHMAD#

#######################
SHMADD 625000 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
#CKPTINTVL 300 # Check point interval (in sec)
###########################

agregado pablo CKPTINTVL#

###########################

CKPTINTVL 120 # Check point interval (in sec)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
LTXHWM 50 # Long transaction high water mark percentage
LTXEHWM 60 # Long transaction high water mark (exclusive)
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 64 # Stack size (Kbytes)

System Page Size

BUFFSIZE - Dynamic Server no longer supports this configuration parameter.

To determine the page size used by Dynamic Server on your platform

see the last line of output from the command, ‘onstat -b’.

Recovery Variables

OFF_RECVRY_THREADS:

Number of parallel worker threads during fast recovery or an offline restore.

ON_RECVRY_THREADS:

Number of parallel worker threads during an online restore.

OFF_RECVRY_THREADS 10 # Default number of offline worker threads
ON_RECVRY_THREADS 1 # Default number of online worker threads

Data Replication Variables

DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
DRTIMEOUT 30 # DR network timeout (in sec)
DRLOSTFOUND \tmp # DR lost+found file path

CDR Variables

CDR_LOGBUFFERS 2048 # size of log reading buffer pool (Kbytes)
CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR queue (Kbytes)
CDR_LOGDELTA 30 # % of log space allowed in queue memory
CDR_NUMCONNECT 16 # Expected connections per server
CDR_NIFRETRY 300 # Connection retry (seconds)
CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9 max)

Backup/Restore variables

BAR_ACT_LOG C:\informix\bar_ol_guarani.log #Path of log file for onbar.exe
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 15
BAR_BSALIB_PATH C:\ISM\2.20\bin\libbsa.dll # Location of ISM XBSA DLL

RESTARTABLE_RESTORE off #To support restartable restore…values on/off

Informix Storage Manager variables

ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs

Read Ahead Variables

#RA_PAGES # Number of pages to attempt to read ahead
##########################

agregado pablo RA_PAGES#

##########################
RA_PAGES 10 # Number of pages to attempt to read ahead
#RA_THRESHOLD # Number of pages left before next group
##########################

agregado pablo RA_PAGES#

##########################
RA_THRESHOLD 5 # Number of pages left before next group

DBSPACETEMP:

Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces

that the Dynamic Server SQL Engine will use to create temp tables etc.

If specified it must be a colon separated list of dbspaces that exist

when the Dynamic Server system is brought online. If not specified, or if

all dbspaces specified are invalid, various ad hoc queries will create

temporary files in /tmp instead.

#DBSPACETEMP # Default temp dbspaces
#############################

agregado pablo DBSPACETEMP#

#############################
DBSPACETEMP tempdbs # Default temp dbspaces

DUMP*:

The following parameters control the type of diagnostics information which

is preserved when an unanticipated error condition (assertion failure) occurs

during Dynamic Server operations.

For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.

DUMPDIR C:\tmp # Preserve diagnostics in this directory
DUMPSHMEM 1 # Dump a copy of shared memory
DUMPGCORE 0 # Dump a core image using ‘gcore’
DUMPCORE 0 # Dump a core image (Warning:this aborts Dynamic
DUMPCNT 1 # Number of shared memory or gcore dumps for
# a single user’s session

FILLFACTOR 90 # Fill factor for building indexes

method for Dynamic Server to use when determining current time

USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow)

Parallel Database Queries (pdq)

#MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
#################################

agregado pablo MAX_PDQPRIORITY#

#################################
MAX_PDQPRIORITY 50 # Maximum allowed pdqpriority
#DS_MAX_QUERIES 32 # Maximum number of decision support queries
################################

agregado pablo DS_MAX_QUERIES#

################################
DS_MAX_QUERIES 10 # Maximum number of decision support queries

DS_TOTAL_MEMORY 4096 # Decision support memory (Kbytes)

#DS_MAX_SCANS 1048576 # Maximum number of decision support scans
##############################

agregado pablo DS_MAX_SCANS#

##############################
DS_MAX_SCANS 20 # Maximum number of decision support scans

DATASKIP off # List of dbspaces to skip

OPTCOMPIND

0 => Nested loop joins will be preferred (where

possible) over sortmerge joins and hash joins.

1 => If the transaction isolation mode is not

“repeatable read”, optimizer behaves as in (2)

below. Otherwise it behaves as in (0) above.

2 => Use costs regardless of the transaction isolation

mode. Nested loop joins are not necessarily

preferred. Optimizer bases its decision purely

on costs.

#OPTCOMPIND 2 # To hint the optimizer
##############################

agregado pablo OPTCOMPIND#

##############################
OPTCOMPIND 1 # To hint the optimizer

DIRECTIVES 1 # Optimizer DIRECTIVES ON (1/Default) or OFF (0)

ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
LBU_PRESERVE 0 # Preserve last log for log backup
OPCACHEMAX 0 # Maximum optical cache size (Kbytes)

HETERO_COMMIT (Gateway participation in distributed transactions)

1 => Heterogeneous Commit is enabled

0 (or any other value) => Heterogeneous Commit is disabled

HETERO_COMMIT 0

SBSPACENAME sbspace # Default sbspace

BLOCKTIMEOUT 3600 # Default timeout for system block

Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS

OPT_GOAL -1

ALLOW_NEWLINE 0 # embedded newlines(Yes = 1, No = 0 or anything but 1)
SYSSBSPACENAME sbspace # Default System sbspace

The following are default settings for enabling Java in the database.

#VPCLASS jvp,num=1 # Number of JVPs to start with
JVPJAVAHOME # JDK installation root directory
JVPHOME C:\informix\extend\krakatoa # Krakatoa installation directory
JVPPROPFILE C:\informix\extend\krakatoa.jvpprops_ol_guarani
# JVP property file
JDKVERSION 1.2 # JDK version supported by this server
JVMTHREAD native # Java VM thread type (green or native)

The path to the JRE libraries relative to JVPJAVAHOME

JVPJAVALIB \jre\bin\

The JRE libraries to use for the Java VM

JVPJAVAVM hpi;jvm;java;net;math;zip;jpeg

Classpath to use upon Java VM start-up (use _g version for debugging)

JVPCLASSPATH C:\informix\extend\krakatoa\krakatoa.jar;C:\informix\extend\krakatoa\jdbc.jar

TAPEBLK 16 # Tape block size (Kbytes)
JVPLOGFILE C:\informix\extend\krakatoa/jvp.log # JVP log file.


a los logical logs los agregastes con onparam?

probá de dropear las bases con el dbaccess.

Emilio

Hola emilio:

Si lo hice con onparam, probe pero no me dejo.

muchas gracias!!!

No pudiste borrar la base porque no tenes permisos para hacerlo. Debes tener permisos de DBA sobre esa base.
Te conectas con el usuario informix para borrar la base? Tiene permisos sobre esa base?

hola alejandro:

Me conecto con el usuario dba, y antes si pude eliminar la base. puedo eliminar otras bases que hay.

muchas gracias!!!