International Informix Users Group

	Informix News

9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read 22 Mar 12 - developerWorks - Optimizing Informix database access... Read 14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read 1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read 1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read 26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read 24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read 6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read 2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read 1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read 13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read 11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read 9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read 8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read 1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read 8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read 31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read 27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read 16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read 21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read 14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read 11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read 9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read 2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read 27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read 25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read 12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read 20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read 20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read 20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read 24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read 23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read 21 May 10 - CNET - IBM to help people monitor energy use... Read 20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read 19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read 19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read 17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read 17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read 10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read Previous news items

End of Support Dates

IDS 11.10 - 30 Sep 2012 Subscribe to notifications

Home Member Area About IIUG Help

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IIUG Español

Problema con dbaccess

Posted By: Teresa Jimenez Nieto
Date: Thursday, 8 January 2004, at 4:55 p.m.

> Les mando este mail para ver si me pueden ayudar. Tengo una duda y no se
> por donde atacarlo.
>=20
> Me bajaron un respaldo de la base de datos (robot) de nomina de producci=
=F3n
> a desarrollo. Pero en desarrollo la base de datos tiene otras rutas de
> chuncks y tiene otro nombre. Realice los cambios necesarios con unas
> heramientas que tenemos.
>=20
> Mi informaci=F3n cuando bajaron el respaldo fue (actividad que yo no hago=
):
>=20
> Variables de ambiente
> ONCONFIG=3Donconfig.ddb
> INFORMIXSERVER=3Dpdb_shm
>=20
> onconfig.ddb
> ROOTPATH /dev/infmx/uxs09/cdbroot1
> LTAPEDEV /users/informix/logs/InfLog #Log tape device path (que
> va al robot)
> SERVERNUM 1
> DBSERVERNAME psf_shm # Name of default database server
> DBSERVERALIASES psf_tcp # List of alternate dbservernames
>=20
> Sqlhosts:
> psf_shm onipcshm uxd01 psfshm =20
> psf_tcp onsoctcp uxd01 psftcp =20
>=20
> En cuanto me avisaron que el respaldo habia terminado la di de baja y la
> di de alta para checar que no tuviermos problemas y cheque el online y no
> me dio errores. No entre al dbaccess.
>=20
> Realice los cambios que necesita en rutas y variables ya que en desarrollo
> puede haber hasta 3 copias de la misma base. Los cambios fueron:
>=20
> Variables de ambiente
> ONCONFIG=3Donconfig.ddb
> INFORMIXSERVER=3Dddb_shm
>=20
> onconfig.ddb
> ROOTPATH /dev/infmx/Dxs09/cdbroot1 =20
> LTAPEDEV /dev/null # Log tape device path
> SERVERNUM 4 # Unique id corresponding to a OnLine
> instance
> DBSERVERNAME ddb_shm # Name of default database server
> DBSERVERALIASES ddb_tcp # List of alternate dbservernames=20
>=20
> Sqlhosts:
> ddb_shm onipcshm uxd01 ddbshm =20
> ddb_tcp onsoctcp uxd01 ddbtcp =20
>=20
> Levante la base y en el online me marco lo siguiente:
>=20
> 11:49:48 Informix Dynamic Server Stopped.
> 11:51:06 Segment locked: addr=3D0xd1537000, size=3D170958848
>=20
> Thu Jan 8 11:51:06 2004
>=20
> 11:51:06 Event alarms enabled. ALARMPROG =3D '/usr/informix/etc/no_log.=
sh'
> 11:51:14 DR: DRAUTO is 0 (Off)
> 11:51:14 Requested shared memory segment size rounded from 588KB to 592KB
> 11:51:14 Informix Dynamic Server Version 7.31.UC2 Software Serial
> Number AAC#
> J407811
> 11:51:14 Informix Dynamic Server Initialized -- Shared Memory
> Initialized.
> 11:51:14 Physical Recovery Started. =
> 11:51:14 Physical Recovery Complete: 0 Pages Restored.
>=20
> 11:51:14 Logical Recovery Started.
> 11:51:16 Logical Recovery Complete.
>=20
> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks =
> =20
> 11:51:17 Onconfig parameter ROOTPATH modified from
> /dev/infmx/uxs09/cdbroot1 to
> /dev/infmx/Dxs09/cdbroot1.
>=20
> 11:51:17 Onconfig parameter LTAPEDEV modified from
> /users/informix/logs/InfLog
> to /dev/null.
>=20
> 11:51:17 Onconfig parameter DBSERVERNAME modified from psf_shm to
> ddb_shm.
> 11:51:17 Onconfig parameter SERVERNUM modified from 1 to 4. =20
> 11:51:17 Dataskip is now OFF for all dbspaces
> 11:51:18 On-Line Mode
> 11:51:18 Affinitied VP 1 to phys proc 1
> 11:51:18 Affinitied VP 4 to phys proc 3
> 11:51:18 Affinitied VP 3 to phys proc 2
> 11:51:18 Affinitied VP 5 to phys proc 4
> 11:51:18 Affinitied VP 6 to phys proc 5
> 11:51:18 Checkpoint Completed: duration was 0 seconds.
>=20
>=20
> uxd01:mmjimen-informix $onstat -d
> Informix Dynamic Server Version 7.31.UC2 -- On-Line -- Up 00:16:57 --
> 166952=20
> bytes
>=20
> Dbspaces
> address number flags fchunk nchunks flags owner name
> 89354158 1 1 1 1 N informix dbsroot01
> 89355f58 2 1 2 1 N informix dbsphy01
> 8988b278 3 1 3 1 N informix dbslog01
> 8988b338 4 1 4 1 N informix dbslog02
> 8988b3f8 5 2001 5 1 N T informix dbstmp01
> 8988b4b8 6 2001 6 1 N T informix dbstmp02
> 8988b578 7 2001 7 1 N T informix dbstmp03
> 8988b638 8 1 8 2 N informix empid00
> 8988b6f8 9 1 9 3 N informix empid01
> 8988b7b8 10 1 10 3 N informix empid02
> 8988b878 11 1 11 3 N informix empid03
> 8988b938 12 1 12 3 N informix empid04
> 8988b9f8 13 1 13 3 N informix empid05
> 8988bab8 14 1 14 2 N informix empid06
> 8988bb78 15 1 15 3 N informix empid07
> 8988bc38 16 1 16 3 N informix empid08
> 8988bcf8 17 1 17 3 N informix empid09
> 8988bdb8 18 1 18 3 N informix grpid00
> 8988be78 19 1 19 2 N informix grpid01
> 8988bf38 20 1 20 1 N informix grpid02
> 8988c018 21 1 21 2 N informix grpid03
> 8988c0d8 22 1 22 1 N informix grpid04
> 8988c198 23 1 23 1 N informix grpid05
> 8988c258 24 1 24 1 N informix grpid06
> 8988c318 25 1 25 2 N informix grpid07
> 8988c3d8 26 1 26 2 N informix grpid08
> 8988c498 27 1 27 2 N informix grpid09
> 8988c558 28 1 28 2 N informix grpid10
> 8988c618 29 1 29 2 N informix grpid11
> 8988c6d8 30 1 30 2 N informix grpid12
> 8988c798 31 1 31 2 N informix grpid13
> 8988c858 32 1 32 2 N informix grpid14
> 8988c918 33 1 33 2 N informix grpid15
> 8988c9d8 34 1 34 2 N informix grpid16
> 8988ca98 35 1 35 2 N informix grpid17
> 8988cb58 36 1 36 2 N informix grpid18
> 8988cc18 37 1 37 5 N informix dbsidx00
> 8988ccd8 38 1 38 6 N informix dbsidx01
> 8988cd98 39 1 39 6 N informix dbsidx02
> 8988ce58 40 1 40 6 N informix dbsidx03
> 8988cf18 41 1 41 6 N informix dbsidx04
> 8988cfd8 42 1 42 12 N informix dbsidx05
> 8988d098 43 1 43 11 N informix dbsidx06
> 8988d158 44 1 44 6 N informix dbsidx07
> 8988d218 45 1 45 9 N informix dbspsp01
> 8988d2d8 46 1 46 7 N informix dbspsp02
> 8988d398 47 1 50 9 N informix dbsidx08
> 47 active, 2047 maximum
>=20
> Chunks
> address chk/dbs offset size free bpages flags pathname
> 89354218 1 1 0 26624 8045 PO-
> /dev/infmx/Dxs09/cdbr
> oot1
> 89354cf8 2 2 0 53248 21195 PO-
> /dev/infmx/Dxs09/cdbp
> hy01
> 89354dd8 3 3 0 524288 12235 PO-
> /dev/infmx/Dxs09/cdbl
> og01
> 89354eb8 4 4 0 524288 12235 PO-
> /dev/infmx/Dxs09/cdbl
> og02
> 89354f98 5 5 0 524288 524235 PO-
> /dev/infmx/Dxs09/cdbt
> mp01
> 89355078 6 6 0 524288 524235 PO-
> /dev/infmx/Dxs09/cdbt
> mp02
> 89355158 7 7 0 524288 524235 PO-
> /dev/infmx/Dxs09/cdbt
> mp03
> 89355238 8 8 0 1048575 52983 PO-
> /dev/infmx/Dxs09/empi
> d00
> 89355318 9 9 0 1048575 61944 PO-
> /dev/infmx/Dxs09/empi
> d01
> 893553f8 10 10 0 1048575 59121 PO-
> /dev/infmx/Dxs09/empi
> d02
> 893554d8 11 11 0 1048575 55427 PO-
> /dev/infmx/Dxs09/empi
> d03
> 893555b8 12 12 0 1048575 64861 PO-
> /dev/infmx/Dxs09/empi
> d04
> 89355698 13 13 0 1048575 59816 PO-
> /dev/infmx/Dxs09/empi
> d05
> 89355778 14 14 0 1048575 63015 PO-
> /dev/infmx/Dxs09/empi
> d06
> 89355858 15 15 0 1048575 59163 PO-
> /dev/infmx/Dxs09/empi
> d07
> 89355938 16 16 0 1048575 59718 PO-
> /dev/infmx/Dxs09/empi
> d08
> 89355a18 17 17 0 1048575 61793 PO-
> /dev/infmx/Dxs09/empi
> d09
> 89355af8 18 18 0 1048575 65 PO-
> /dev/infmx/Dxs09/grpi
> d00 =20
> 89355bd8 19 19 0 1048575 225 PO-
> /dev/infmx/Dxs09/grpi
> d01
> 89355cb8 20 20 0 1048575 107900 PO-
> /dev/infmx/Dxs09/grpi
> d02
> 89355d98 21 21 0 1048575 135 PO-
> /dev/infmx/Dxs09/grpi
> d03
> 89355e78 22 22 0 1048575 261328 PO-
> /dev/infmx/Dxs09/grpi
> d04
> 8937d630 23 23 0 1048575 443966 PO-
> /dev/infmx/Dxs09/grpi
> d05
> 8937d710 24 24 0 1048575 334841 PO-
> /dev/infmx/Dxs09/grpi
> d06
> 8937d7f0 25 25 0 1048575 245 PO-
> /dev/infmx/Dxs09/grpi
> d07
> 8937d8d0 26 26 0 1048575 351 PO-
> /dev/infmx/Dxs09/grpi
> d08
> 8937d9b0 27 27 0 1048575 103 PO-
> /dev/infmx/Dxs09/grpi
> d09
> 8937da90 28 28 0 1048575 485 PO-
> /dev/infmx/Dxs09/grpi
> d10
> 8937db70 29 29 0 1048575 392 PO-
> /dev/infmx/Dxs09/grpi
> d11
> 8937dc50 30 30 0 1048575 189 PO-
> /dev/infmx/Dxs09/grpi
> d12 =20
> 8937dd30 31 31 0 1048575 234 PO-
> /dev/infmx/Dxs09/grpi
> d13
> 8937de10 32 32 0 1048575 337 PO-
> /dev/infmx/Dxs09/grpi
> d14
> 8937def0 33 33 0 1048575 247 PO-
> /dev/infmx/Dxs09/grpi
> d15
> 89388830 34 34 0 1048575 58580 PO-
> /dev/infmx/Dxs09/grpi
> d16
> 89388910 35 35 0 1048575 163 PO-
> /dev/infmx/Dxs09/grpi
> d17
> 893889f0 36 36 0 1048575 1460 PO-
> /dev/infmx/Dxs09/grpi
> d18
> 89388ad0 37 37 0 1048575 107431 PO-
> /dev/infmx/Dxs09/cdbi
> dx00
> 89388bb0 38 38 0 1048575 8 PO-
> /dev/infmx/Dxs09/cdbi
> dx01
> 89388c90 39 39 0 1048575 873 PO-
> /dev/infmx/Dxs09/cdbi
> dx02
> 89388d70 40 40 0 1048575 26 PO-
> /dev/infmx/Dxs09/cdbi
> dx03
> 89388e50 41 41 0 1048575 7938 PO-
> /dev/infmx/Dxs09/cdbi
> Dx04
> 89388f30 42 42 0 1048575 11 PO-
> /dev/infmx/Dxs09/cdbi
> dx05
> 89389010 43 43 0 1048575 821 PO-
> /dev/infmx/Dxs09/cdbi
> dx06
> 893890f0 44 44 0 1048575 2 PO-
> /dev/infmx/Dxs09/cdbi
> dx07
> 893891d0 45 45 0 1048575 8910 PO-
> /dev/infmx/Dxs09/cdbp
> sp01
> 893892b0 46 46 0 1048575 62447 PO-
> /dev/infmx/Dxs09/cdbp
> sp02
> 89389390 47 45 0 1048575 76148 PO-
> /dev/infmx/Dxs09/cdbp
> sp03
> 89389470 48 46 0 1048575 378985 PO-
> /dev/infmx/Dxs09/cdbp
> sp05
> 89389550 49 42 0 524287 18 PO-
> /dev/infmx/Dxs09/cdbi
> dx05.1
> 89389630 50 47 0 1048575 4015 PO-
> /dev/infmx/Dxs09/cdbi
> dx08
> 89389710 51 40 0 524288 1043 PO-
> /dev/infmx/Dxs09/cdbi
> dx03.1
> 893897f0 52 41 0 524288 28210 PO-
> /dev/infmx/Dxs09/cdbi
> dx04.1
> 893898d0 53 43 0 524288 1219 PO-
> /dev/infmx/Dxs09/cdbi
> 893898d0 53 43 0 524288 1219 PO-
> /dev/infmx/Dxs09/cdbi
> dx06.1 =20
> 893899b0 54 38 0 524288 16 PO-
> /dev/infmx/Dxs09/cdbi
> dx01.1
> 89389a90 55 44 0 524288 40 PO-
> /dev/infmx/Dxs09/cdbi
> dx07.1
> 89389b70 56 39 0 524287 326 PO-
> /dev/infmx/Dxs09/cdbi
> dx02.1
> 89389c50 57 42 0 524287 57 PO-
> /dev/infmx/Dxs09/cdbi
> dx05.2
> 89389d30 58 45 0 524287 105065 PO-
> /dev/infmx/Dxs09/cdbp
> sp01.1
> 89389e10 59 37 0 524287 63659 PO-
> /dev/infmx/Dxs09/cdbi
> dx00.1
> 89389ef0 60 43 0 1048575 1988 PO-
> /dev/infmx/Dxs09/cdbi
> dx06.2
> 8987e018 61 47 0 524287 7900 PO-
> /dev/infmx/Dxs09/cdbi
> dx08.1
> 8987e0f8 62 46 0 524287 159957 PO-
> /dev/infmx/Dxs09/cdbp
> sp2.2
> 8987e1d8 63 42 0 524287 8 PO-
> /dev/infmx/Dxs09/cdbi
> dx05.3
> 8987e2b8 64 40 0 524287 992 PO-
> /dev/infmx/Dxs09/cdbi
> dx03.2
> 8987e398 65 41 0 524287 45836 PO-
> /dev/infmx/Dxs09/cdbi
> dx04.2
> 8987e478 66 44 0 1048575 56 PO-
> /dev/infmx/Dxs09/cdbi
> dx07.2
> 8987e558 67 38 0 1048575 13 PO-
> /dev/infmx/Dxs09/cdbi
> dx01.2
> 8987e638 68 45 0 999420 411875 PO-
> /dev/infmx/Dxs09/cdbp
> sp01.2
> 8987e718 69 47 0 262143 36 PO-
> /dev/infmx/Dxs09/cdbi
> dx08.2
> 8987e7f8 70 41 0 1048575 216531 PO-
> /dev/infmx/Dxs09/cdbi
> dx04.3
> 8987e8d8 71 46 0 1048575 128034 PO-
> /dev/infmx/Dxs09/cdbp
> sp02.3
> 8987e9b8 72 47 0 1048575 156 PO-
> /dev/infmx/Dxs09/cdbi
> dx08.3
> 8987ea98 73 37 0 1048575 22829 PO-
> /dev/infmx/Dxs09/cdbi
> dx00.2
> 8987eb78 74 42 0 1048575 4 PO-
> /dev/infmx/Dxs09/cdbi
> dx05.4
> 8987ec58 75 39 0 1048575 41180 PO-
> /dev/infmx/Dxs09/cdbi
> dx02.2
> 8987ed38 76 43 0 1048575 1217 PO-
> /dev/infmx/Dxs09/cdbi
> dx06.3 =20
> 8987ee18 77 40 0 1048575 198672 PO-
> /dev/infmx/Dxs09/cdbi
> dx03.3
> 8987eef8 78 46 0 1048575 380188 PO-
> /dev/infmx/Dxs09/cdbp
> sp02.4
> 8987efd8 79 42 0 1048575 8 PO-
> /dev/infmx/Dxs09/cdbi
> dx05.5
> 8987f0b8 80 47 0 1048575 156 PO-
> /dev/infmx/Dxs09/cdbi
> dx08.4
> 8987f198 81 43 0 1048575 2053 PO-
> /dev/infmx/Dxs09/cdbi
> dx06.4
> 8987f278 82 18 0 1048575 67 PO-
> /dev/infmx/Dxs09/grpi
> d00.1
> 8987f358 83 37 0 1048575 9321 PO-
> /dev/infmx/Dxs09/cdbi
> dx00.3
> 8987f438 84 38 0 1048575 1 PO-
> /dev/infmx/Dxs09/cdbi
> dx01.3
> 8987f518 85 39 0 1048575 48277 PO-
> /dev/infmx/Dxs09/cdbi
> dx02.3
> 8987f5f8 86 44 0 1048575 436 PO-
> /dev/infmx/Dxs09/cdbi
> dx07.3
> 8987f6d8 87 46 0 1048575 393776 PO-
> /dev/infmx/Dxs09/cdbp
> sp02.5
> 8987f7b8 88 45 0 1048575 344855 PO-
> /dev/infmx/Dxs09/cdbp
> sp01.3
> 8987f898 89 29 0 1048575 140639 PO-
> /dev/infmx/Dxs09/grpi
> d11.1
> 8987f978 90 43 0 1048575 2473 PO-
> /dev/infmx/Dxs09/cdbi
> dx06.5
> 8987fa58 91 8 0 1048575 540913 PO-
> /dev/infmx/Dxs09/empi
> d00.2
> 8987fb38 92 14 0 1048575 554158 PO-
> /dev/infmx/Dxs09/empi
> d06.2
> 8987fc18 93 42 0 511999 4 PO-
> /dev/infmx/Dxs09/cdbi
> dx05.6
> 8987fcf8 94 9 0 511999 99416 PO-
> /dev/infmx/Dxs09/empi
> d01.2
> 8987fdd8 95 10 0 511999 102113 PO-
> /dev/infmx/Dxs09/empi
> d02.2
> 8987feb8 96 11 0 511999 89440 PO-
> /dev/infmx/Dxs09/empi
> d03.2
> 89884018 97 12 0 511999 81578 PO-
> /dev/infmx/Dxs09/empi
> d04.2
> 898840f8 98 13 0 511999 106695 PO-
> /dev/infmx/Dxs09/empi
> d05.2
> 898841d8 99 15 0 511999 85763 PO-
> /dev/infmx/Dxs09/empi
> d07.2 =20
> 898842b8 100 16 0 511999 86472 PO-
> /dev/infmx/Dxs09/empi
> d08.2
> 89884398 101 17 0 511999 84967 PO-
> /dev/infmx/Dxs09/empi
> d09.2
> 89884478 102 40 0 1048575 246435 PO-
> /dev/infmx/Dxs09/cdbi
> dx03.4
> 89884558 103 47 0 1048575 156 PO-
> /dev/infmx/Dxs09/cdbi
> dx08.5
> 89884638 104 45 0 1048575 567526 PO-
> /dev/infmx/Dxs09/cdbp
> sp01.4
> 89884718 105 46 0 1048575 994044 PO-
> /dev/infmx/Dxs09/cdbp
> sp02.6
> 898847f8 106 28 0 1048575 388543 PO-
> /dev/infmx/Dxs09/grpi
> d10.2
> 898848d8 107 42 0 1048575 16 PO-
> /dev/infmx/Dxs09/cdbi
> dx05.7
> 898849b8 108 43 0 1048575 1473 PO-
> /dev/infmx/Dxs09/cdbi
> dx06.6
> 89884a98 109 26 0 1048575 621989 PO-
> /dev/infmx/Dxs09/grpi
> d08.1
> 89884b78 110 31 0 1048575 276652 PO-
> /dev/infmx/Dxs09/grpi
> d13.1
> 89884c58 111 41 0 1048575 676820 PO-
> /dev/infmx/Dxs09/cdbi
> dx04.4
> 89884d38 112 32 0 1048575 512369 PO-
> /dev/infmx/Dxs09/grpi
> d14.1
> 89884e18 113 38 0 1048575 1832 PO-
> /dev/infmx/Dxs09/cdbi
> dx01.4
> 89884ef8 114 39 0 1048575 26595 PO-
> /dev/infmx/Dxs09/cdbi
> dx02.4
> 89884fd8 115 27 0 1048575 730254 PO-
> /dev/infmx/Dxs09/grpi
> d09.1
> 898850b8 116 47 0 1048575 4068 PO-
> /dev/infmx/Dxs09/cdbi
> dx08.6
> 89885198 117 30 0 1048575 607442 PO-
> /dev/infmx/Dxs09/grpi
> d12.1
> 89885278 118 43 0 1048575 3900 PO-
> /dev/infmx/Dxs09/cdbi
> dx06.7
> 89885358 119 42 0 1048575 340 PO-
> /dev/infmx/Dxs09/cdbi
> dx05.8
> 89885438 120 35 0 1048575 632482 PO-
> /dev/infmx/Dxs09/grpi
> d17.1
> 89885518 121 45 0 1048575 505792 PO-
> /dev/infmx/Dxs09/cdbp
> sp01.5
> 898855f8 122 40 0 1048575 2498 PO-
> /dev/infmx/Dxs09/cdbi
> dx03.5 =20
> 898856d8 123 37 0 1048575 477140 PO-
> /dev/infmx/Dxs09/cdbi
> dx00.4
> 898857b8 124 33 0 1048575 735985 PO-
> /dev/infmx/Dxs09/grpi
> d15.1
> 89885898 125 44 0 1048575 283292 PO-
> /dev/infmx/Dxs09/cdbi
> dx07.4
> 89885978 126 43 0 1048575 5685 PO-
> /dev/infmx/Dxs09/cdbi
> dx06.8
> 89885a58 127 18 0 1048575 379821 PO-
> /dev/infmx/Dxs09/grpi
> d00.2
> 89885b38 128 47 0 1048575 156 PO-
> /dev/infmx/Dxs09/cdbi
> dx08.7
> 89885c18 129 41 0 1048575 951992 PO-
> /dev/infmx/Dxs09/cdbi
> dx04.5
> 89885cf8 130 19 0 524287 350421 PO-
> /dev/infmx/Dxs09/grpi
> d01.1
> 89885dd8 131 42 0 524287 268 PO-
> /dev/infmx/Dxs09/cdbi
> dx05.9
> 89885eb8 132 45 0 1048575 481614 PO-
> /dev/infmx/Dxs09/cdbp
> sp01.6
> 8988a018 133 21 0 1048575 908753 PO-
> /dev/infmx/Dxs09/grpi
> d03.1
> 8988a0f8 134 42 0 1048575 276588 PO-
> /dev/infmx/Dxs09/cdbi
> dx05.10
> 8988a1d8 135 38 0 1048575 766482 PO-
> /dev/infmx/Dxs09/cdbi
> dx01.5
> 8988a2b8 136 43 0 1048575 141148 PO-
> /dev/infmx/Dxs09/cdbi
> dx06.9
> 8988a398 137 25 0 1048575 937602 PO-
> /dev/infmx/Dxs09/grpi
> d07.1
> 8988a478 138 39 0 1048575 603004 PO-
> /dev/infmx/Dxs09/cdbi
> dx02.5
> 8988a558 139 47 0 1048575 657372 PO-
> /dev/infmx/Dxs09/cdbi
> dx08.8
> 8988a638 140 13 0 1048575 964770 PO-
> /dev/infmx/Dxs09/empi
> d05.3
> 8988a718 141 16 0 1048575 986664 PO-
> /dev/infmx/Dxs09/empi
> d08.3
> 8988a7f8 142 17 0 1048575 986664 PO-
> /dev/infmx/Dxs09/empi
> d09.3
> 8988a8d8 143 11 0 1048575 986664 PO-
> /dev/infmx/Dxs09/empi
> d03.3
> 8988a9b8 144 12 0 1048575 986664 PO-
> /dev/infmx/Dxs09/empi
> d04.3
> 8988aa98 145 15 0 1048575 986664 PO-
> /dev/infmx/Dxs09/empi
> d03.3
> 8988a9b8 144 12 0 1048575 986664 PO-
> /dev/infmx/Dxs09/empi
> d04.3
> 8988aa98 145 15 0 1048575 986664 PO-
> /dev/infmx/Dxs09/empi
> d07.3 =20
> 8988ab78 146 10 0 1048575 974494 PO-
> /dev/infmx/Dxs09/empi
> d02.3
> 8988ac58 147 36 0 1048575 1041794 PO-
> /dev/infmx/Dxs09/grpi
> d18.2
> 8988ad38 148 9 0 1048575 974494 PO-
> /dev/infmx/Dxs09/empi
> d01.3
> 8988ae18 149 45 0 1048575 1048572 PO-
> /dev/infmx/Dxs09/cdbp
> sp01.7
> 8988aef8 150 43 0 1048575 1048572 PO-
> /dev/infmx/Dxs09/cdbi
> dx06.10
> 8988afd8 151 42 0 1048575 1048572 PO-
> /dev/infmx/Dxs09/cdbi
> dx05.11
> 8988b0b8 152 34 0 1048575 1048572 PO-
> /dev/infmx/Dxs09/grpi
> d16.1
> 8988b198 153 44 0 1048575 1048572 PO-
> /dev/infmx/Dxs09/cdbi
> dx07.5
> 153 active, 2047 maximum
>=20
> Como pueden ver levanto la base perfectamente. Corro cualquier comando de
> onstat - y todos se ejecutan correctamente.
>=20
> El problema es entrar a dbaccess:
>=20
> 25588: The appl process cannot connect to Dynamic server ddb_shm. =20
> Interrupted system call =20
>=20
> Me marca este error y como ven tengo definido en el sqlhost el dato.=20
>=20
> Pero si hago:
>=20
> export INFORMIXSERVER=3Dddb_tcp=20
>=20
> SELECT DATABASE >> =20
> Select a database with the Arrow Keys, or enter a name, then press Return.
> =20
> ------------------------------------------------ Press CTRL-W for Help
> --------
> =20
> ddbnom01@ddb_tcp =20
> =20
> onpload@ddb_tcp =20
> =20
> sysmaster@ddb_tcp
> =20
> sysutils@ddb_tcp =20
> =20
> Ya entre. Me pueden decir como puedo cambiar el @ddb_tcp por @ddb_shm.
>=20
> =BFMe podr=EDa decir si me falto una variable o como le puedo hacer?
>=20
> Muchismas gracias. =20
>=20
>=20
>=20
> Ma. Teresa Jim=E9nez Nieto
> Ingenier=EDa Unix
> Servicios Administrativos Wal*mart
> Nextengo #78 , Col. Santa Cruz Acayucan
> Delegaci=F3n Azcapotzalco,M=E9xico D.F.
> Tel: 53-28-8420 =F3 53-28-3500 ext 3720
> mmjimen@wal-mart.com
>=20

**********************************************************************
This email and any files transmitted with it are confidential
and intended solely for the individual or entity to=20
whom they are addressed. If you have received this email
in error destroy it immediately.
**********************************************************************
Wal-Mart Stores, Inc. Confidential
**********************************************************************

Messages In This Thread

Problema con dbaccess
Teresa Jimenez Nieto -- Thursday, 8 January 2004, at 4:55 p.m.
- Re: Problema con dbaccess
  Jorge Garcia -- Friday, 9 January 2004, at 10:31 a.m.

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IIUG Español is maintained by Administrator with WebBBS 5.12.