Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Informix Новый топик    Ответить
 ontape -s -L 0 выдает shmat: [1635584]: operating system error  [new]
MaximFomenko
Member

Откуда: London, UK
Сообщений: 594
Добрый день.

Инсталирую Informix 7.31 TC4 на Windows 8 x64 (не знаю возможно ли это, но пытаюсь).

Поставил сам информикс, СДК, переконфигурировал ONCONFIG, выполнил oninit -iy.

Все прошло нормально. Затем начал цеплять chunk'и:

C:\Informix>onspaces -c -d ol_cooper -p D:\IFMXDATA\ol_cooper\ol_cooper_dat.000
-o 0 -s 2048000


получилось успешно.

Дальше запускаю "ontape -s -L 0" и выдает следующее:

Please mount tape 1 on D:\IFMXBKUP\ifmxbkup.bak and press Return to continue ...

01:01:31  shmat: [1635584]: operating system error

C:\Informix>


смотрю в лог сервера:

01:01:31  Checkpoint Completed:  duration was 0 seconds.
01:01:31  Level 0 Archive started on rootdbs, ol_cooper
01:02:14  Archive on rootdbs, ol_cooper ABORTED.
01:02:14  Aborted by client.


ONCONFIG настроен так:

+
#**************************************************************************
#
#			   INFORMIX SOFTWARE, INC.
#
#  Title:	onconfig.std
#  Description: Informix Dynamic Server Configuration Parameters
#
#**************************************************************************

# Root Dbspace Configuration

ROOTNAME	rootdbs		# Root dbspace name
ROOTPATH	D:\IFMXDATA\ol_cooper\rootdbs_dat.000	# Path for device containing root dbspace
ROOTOFFSET	0		# Offset of root dbspace into device (Kbytes)
ROOTSIZE	1000720		# 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		rootdbs 	# Location (dbspace) of physical log
PHYSFILE	2000		# Physical log file size (Kbytes)

# Logical Log Configuration

LOGFILES	20		# Number of logical log files
LOGSIZE		1000		# Logical log size (Kbytes)
LOG_BACKUP_MODE MANUAL          # Logical log backup mode (MANUAL, CONT)

# Diagnostics 

MSGPATH	C:\Informix\ol_cooper.log	# System message log file path
CONSOLE	C:\Informix\conol_cooper.log	# System console message path
ALARMPROGRAM                    # Alarm program path

# 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		D:\IFMXBKUP\ifmxbkup.bak	# Tape device path	
TAPEBLK		32		# Tape block size (Kbytes)
TAPESIZE	10240		# Maximum amount of data to put on tape (Kbytes)

# Log Archive Tape Device

LTAPEDEV	D:\IFMXBKUP\ifmxbklg.bak	# Log tape device path
LTAPEBLK	32		# Log tape block size (Kbytes)
LTAPESIZE	10240		# 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
stance
DBSERVERNAME	ol_cooper		# Name of default Dynamic Server
DBSERVERALIASES			# List of alternate dbservernames
NETTYPE		onsoctcp,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)

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		32000		# Maximum number of locks
BUFFERS		40000#2000		# 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)
LOGSMAX		20		# Maximum number of logical log files
CLEANERS        1               # Number of buffer cleaner processes
SHMBASE         0xC000000L	# Shared memory base address
SHMVIRTSIZE	307200#8192	        # initial virtual shared memory segment size
SHMADD          8192            # Size of new shared memory segments (Kbytes)
SHMTOTAL        0               # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL       300             # 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	300		# Transaction timeout (in sec)
STACKSIZE	32		# 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
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRAUTO   	0 		# DR automatic switchover
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_cooper.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
RA_THRESHOLD	  	        # 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

# 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		\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
 Server)
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
DS_MAX_QUERIES  32     # Maximum number of decision support queries 
DS_TOTAL_MEMORY 4096   # Decision support memory (Kbytes) 
DS_MAX_SCANS 1048576   # Maximum number of decision support scans	
DATASKIP	       # 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

ONDBSPACEDOWN   2      # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
LBU_PRESERVE    1      # 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

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

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



Пожалуйста, подскажите в чем ошибка? 3-й день долбаюсь безрезультатно...
23 фев 13, 03:06    [13969826]     Ответить | Цитировать Сообщить модератору
 Re: ontape -s -L 0 выдает shmat: [1635584]: operating system error  [new]
DrGonzo
Member

Откуда: ex-IBM
Сообщений: 191
MaximFomenko,

Был такой старый АПАР для 11.10 IC56004 ONTAPE CANNOT CONNECT IF SHARED MEMORY SIZE IS BIG ON WINDOWS

Вероятно, проблема существует и в 7.31.. Можно наверное попробовать уменьшить SHMVIRTSIZE и BUFFERS. Или же может быть, что какая-то библиотека на Win8 уже исползует адрес, по которому пытается прицепиться ontape. Если так, то можно поиграться с переменной окружения IFX_XFER_SHMBASE, авось поможет.

А вообще даже 11.70 еще кажется официально не поддерживается на Win 8. ;)
24 фев 13, 05:01    [13972255]     Ответить | Цитировать Сообщить модератору
 Re: ontape -s -L 0 выдает shmat: [1635584]: operating system error  [new]
bk0010
Member

Откуда:
Сообщений: 5001
Рекомеедую рассмотреть возможность развернуть ваш сервер на виртуалке под win2000 или NT4: у вас очень старая версия.
24 фев 13, 21:47    [13973668]     Ответить | Цитировать Сообщить модератору
 Re: ontape -s -L 0 выдает shmat: [1635584]: operating system error  [new]
MaximFomenko
Member

Откуда: London, UK
Сообщений: 594
bk0010,

Спасибо. Тем и закончилось, что поставил виртуалку и развернул все на ней.
27 фев 13, 23:32    [13991487]     Ответить | Цитировать Сообщить модератору
Все форумы / Informix Ответить