View Full Version : answers

Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 [19] 20 21
  1. How DB2 UDB v7.2 & v81. talk?
  2. How DB2 UDB v7.2 & v81. talk?
  3. URGENT HELP on NICKNAMES
  4. URGENT HELP on NICKNAMES
  5. function of IDENTITY_VAL_LOCAL problem
  6. how to do row number query
  7. function of IDENTITY_VAL_LOCAL problem
  8. how to do row number query
  9. NULLID.SYSLH203 -805 Solaris 8,1FP3
  10. question about versions
  11. question about versions
  12. NULLID.SYSLH203 -805 Solaris 8,1FP3
  13. row level security
  14. row level security
  15. Simple Query - but answer eludes me
  16. Simple Query - but answer eludes me
  17. Cloudscape/DB2J
  18. Cloudscape/DB2J
  19. Offline Temporary Tablespace
  20. Offline Temporary Tablespace
  21. admin: can this disgusting stuff be deleted?
  22. admin: can this disgusting stuff be deleted?
  23. view with where condition
  24. view with where condition
  25. DB2 Connect ODBC and SQL Server DTS
  26. DB2 Connect ODBC and SQL Server DTS
  27. Delphi Admin-API Inerface Unit
  28. Delphi Admin-API Inerface Unit
  29. Objects dependency
  30. Objects dependency
  31. Need sample DB2 script called by AIX script
  32. Need sample DB2 script called by AIX script
  33. Connect not possible
  34. Connect not possible
  35. Cannot delete table data with db2 connect
  36. List the dependency of a object
  37. Cannot delete table data with db2 connect
  38. List the dependency of a object
  39. IT - Database Administrator - S. California
  40. IT - Database Administrator - S. California
  41. fenced routine communications & import
  42. fenced routine communications & import
  43. MS Access Pass Through Query
  44. MS Access Pass Through Query
  45. Table & Tablespace size
  46. Table & Tablespace size
  47. UDB V8 fp 5 to Datajoiner 2.1.2 fp 13
  48. UDB V8 fp 5 to Datajoiner 2.1.2 fp 13
  49. How do I manually set statistics for a VARGRAPHIC column
  50. How do I manually set statistics for a VARGRAPHIC column
  51. memory question
  52. memory question
  53. how do I configure DB2 Connect for the port?
  54. how do I configure DB2 Connect for the port?
  55. JDBC error codes
  56. JDBC error codes
  57. configuration advisor on buffer pool size
  58. configuration advisor on buffer pool size
  59. Getting an error when running table functions - snapshot_tbs
  60. Getting an error when running table functions - snapshot_tbs
  61. DB2 Client compatibility
  62. DB2 Client compatibility
  63. Creating a sequence alias
  64. Creating a sequence alias
  65. How to for dummies
  66. How to for dummies
  67. How to find a tablespace storage size and containers size via system tables
  68. How to find a tablespace storage size and containers size via system tables
  69. SQL10007N Message "99999" could not be retrieved. Reason code:
  70. SQL10007N Message "99999" could not be retrieved. Reason code:
  71. is it possible to connect to db2/390 without having db2 connect?
  72. is it possible to connect to db2/390 without having db2 connect?
  73. DB2Connect EE to connect to DB2 for z/OS
  74. DB2Connect EE to connect to DB2 for z/OS
  75. Upgrade and License questions
  76. Upgrade and License questions
  77. DB2 daily
  78. DB2 daily
  79. Update Original Installation Media?
  80. Update Original Installation Media?
  81. Transfer Java stored procedures from v7.2 to v8.1 problems
  82. Transfer Java stored procedures from v7.2 to v8.1 problems
  83. Strange access plan
  84. Strange access plan
  85. Update Multiple Rows
  86. Update Multiple Rows
  87. CPU, IO, Application times
  88. CPU, IO, Application times
  89. Control Scripts
  90. Control Scripts
  91. Stored procedures using declared temporary tables: please help!
  92. Stored procedures using declared temporary tables: please help!
  93. DB2 Connect, Dynamic SQL, and chosen Isolation Level
  94. DB2 Connect, Dynamic SQL, and chosen Isolation Level
  95. Restoring from one drive to another
  96. Restoring from one drive to another
  97. failed insert because of duplicate rows and still locks held by application
  98. failed insert because of duplicate rows and still locks held by application
  99. Help with query
  100. Help with query
  101. Routine tasks
  102. Routine tasks
  103. Tools Catalog Location
  104. Tools Catalog Location
  105. Defining External (C) UDF example from Application Development Guide
  106. Defining External (C) UDF example from Application Development Guide
  107. tablespace scan, but not table scan
  108. tablespace scan, but not table scan
  109. Problems creating stored procedure
  110. Problems creating stored procedure
  111. ODBC doesn't support stored procedures? This can't be true
  112. ODBC doesn't support stored procedures? This can't be true
  113. Question about optiload
  114. Question about optiload
  115. disconnect command
  116. disconnect command
  117. disconnect command
  118. disconnect command
  119. disconnect command
  120. disconnect command
  121. Long time before connection
  122. Long time before connection
  123. Is there an easy to copy a table: structure and data?
  124. Is there an easy to copy a table: structure and data?
  125. buffer_pool_services sqlbStartPools Probe:2
  126. buffer_pool_services sqlbStartPools Probe:2
  127. How to resolve foreign key change during import?
  128. How to resolve foreign key change during import?
  129. accessing active log files
  130. accessing active log files
  131. Help with trigger - URGENT!
  132. Help with trigger - URGENT!
  133. Table qualifier in DB2 AS/400
  134. Table qualifier in DB2 AS/400
  135. connecting to as/400 database
  136. connecting to as/400 database
  137. DB2 UDB 8.1 SQLJ precompile: attribute error
  138. DB2 UDB 8.1 SQLJ precompile: attribute error
  139. DB2/UDB on iSeries (AS/400 V5R2) - how to run SQL scripts?
  140. DB2/UDB on iSeries (AS/400 V5R2) - how to run SQL scripts?
  141. sql
  142. sql
  143. Restoring a database to a test system, handling schema differences
  144. Restoring a database to a test system, handling schema differences
  145. about SQL0911 reason code 68
  146. about SQL0911 reason code 68
  147. Invalid packages after dropping Prmary key : URGENT
  148. Invalid packages after dropping Prmary key : URGENT
  149. DB2 UDB 8.1 on AIX, How to View CLOB Sample Contents?
  150. getting encoding of a db2 database by java
  151. db2 (udb) 8.1 install on aix5.2 ml 2
  152. DB2 UDB recovery
  153. CPU utilization
  154. Updated lists: XQuery engines, JDBC and ODBC drivers, OLE DB and .NET providers, DB2 extenders
  155. SQL0359N The range of values for the identity column is exhausted.
  156. SuSE "Partner" Program
  157. Returning NULL for column names
  158. JDBC error
  159. Conflict between DB2 WSE V8.1 and DB2 CONNECT V8.1 ?
  160. SELECTIVITY Clause, ( & when will the optimiser have hints) ?
  161. PHP and DB2
  162. DIA7500E Error encountered in the Generator
  163. Index creation
  164. trigger vs. application code performance
  165. SQLExecute running extremely slow
  166. IBM DB2 Content Manager eClient Version 8.2 Install Problem
  167. Problem with DB2 and Windows 2000
  168. Upgrading DB2 in MSCS environment
  169. DB2 Handle Leak?
  170. NetSearchExtender Question ...
  171. README missing in Fixpak 5
  172. Perfomance hint
  173. DB2 8.1 FP 5 Replication Setup - Source to Target Mapping Issues
  174. DB2MOVE - Strange but true
  175. Scriptability for moving stored procedures
  176. Authorization scopes
  177. sqlj.install_jar issues
  178. Dropping procedure - problem
  179. problems using sqlj and db2-8.1 (SET CURRENT PACKAGESET )
  180. Serious Performance Drop on AIX
  181. Length of source Error while compliling a Java stored procedure in SPB
  182. Store Procedure failure
  183. Ant and DB2
  184. Site for practicing UDB
  185. Sequence in DB2 on OS/390
  186. CPU utilization
  187. Script to delete old files based on creation date
  188. Java Stored Procedures (V7.2)
  189. Error Handling in Java Stored Procedures (V7.2)
  190. SQLCODE -28
  191. why it is exclusive lock
  192. My ConnectionEventListener is not called.
  193. My ConnectionEventListener is not called.
  194. Ordinal record number
  195. Accessing an already existing temporary table
  196. SQL 1042c - unexpected system error occurred with rollforward recovery
  197. db2schex.exe
  198. Executing a text file containing SQL
  199. DB2 for VSE access from 2 guest sharing members
  200. DB2 for VSE access from 2 guest sharing members
  201. Table Locks and Preventing Deadlock
  202. Use ADO shape command with DB2?
  203. what are the db2 users db2fenc1 and dasusr1 for ?
  204. The old raw devices chestnut.
  205. SQL0440
  206. Post installation tasks in db2
  207. copy table & rejected rows
  208. Convert Qualify Rank from Teradata to DB2
  209. Jeremy R (JR)
  210. Installation of IBM DB2 Enterprise server edition on Linux
  211. Record selection takes long time
  212. Does DB2 7.1 take more CPU resources than DB2 5.1 under OS/390?
  213. How to avoid duplcate key insertions in a multi-user DB2 environment?
  214. Lost/compromise db2admin password
  215. Generic Connectiity from ORACLE to DB2
  216. Questions about DB2
  217. soft lock problem
  218. db2 replication vs log shipping
  219. Setting MAXAPPLS DB PARAM
  220. Explain plan on DB2 As/400
  221. Calling UDFs from BEFORE UPDATE trigger
  222. DB2MSCS decluster and cluster
  223. db2ptree
  224. SQL4301N RC4 and DB2ROUTINE_DEBUG
  225. Backup Express
  226. Index on Volatile tables
  227. DB2 configure SMTP server
  228. administrative API
  229. SQLDBDIR lost, recovery-scenarios
  230. Where to put the log files running Linux (SLES 8) ?
  231. [JDBC] PreparedStatement and identity column
  232. restore error
  233. suddenly lost my ODBC drivers for DB2... simple way to recover/re-install???
  234. Memory limits for DB2 V8 on LINUX
  235. zos - exec sql - load
  236. db2sysc
  237. Cursor with Hold
  238. Long: DB2 crash because of logging failure
  239. Connection between DB2 personal and DB2 mainframe
  240. register add-ins
  241. IBM Developerworks: Learn how to write DB2 JDBC tools in Jython
  242. partition load
  243. After Backup I loose connection to TOOLSDB
  244. Language Settings for DB2 UDB 8.1
  245. Marrying SQL, XML, web services, grid computing (2 audio programs)
  246. CREATE USER MAPPING Problem
  247. 32 and 64 bit instances
  248. missing P4211708.msg file
  249. DB2 UDB V8 on Linux
  250. identity column not alterable on 390 < v7
  251. Connection Pool Problem w/ DB2 5 - WAS 5
  252. Replication and structured type
  253. What's your compensation for carrying a pager???
  254. Create Alert for Replication Errors
  255. Poor Performance: High Real Time/CPU Time Ratio
  256. Setting limits on size of result sets
  257. Cardinality of 'where col1 like :hostvar' in static SQL
  258. SQLBindFileToParam and SQLBindFileToCol
  259. Please Help! Logfiles lost, but online-backup could be restored
  260. Connect to AS/400 from .NET
  261. for those who cite URL's and googlits as evidence
  262. db2 jdbc driver eclipse - conection error
  263. How to fix Error 332 ?
  264. Different Datetime delimiters gives me different date format
  265. Full logs
  266. db2java.zip
  267. Tablespace page size
  268. DB2 Increasing the pagesize of an SMS tablespace
  269. Cursor performance, FOR or DECLARED
  270. Strange OutOfMemory errors
  271. Server hangs
  272. is this possible? obtain the min and max of rows with discrete intervals?
  273. Servlet connection to DB2 database that is not cataloged
  274. No more handles error with DBD::DB2 on Linux
  275. I get only USA Date format in CLP! What to do to get local format?
  276. My DB2 V8 SP5 WSE crash on Windows 2003
  277. db2admin Windows Account Losing is Administrator Rights
  278. how to create row lock using db2 app driver
  279. Version 8 contains EEE already?
  280. Exporting data to DEL format
  281. Function(UDF) Problem
  282. Difference between Unix UDB DB2 v8 and z/OS DB2 v7
  283. RAID5 striping
  284. CLI0111E Numeric value out of range. SQLSTATE=22003
  285. Exporting LOB data to multipla files
  286. OS390 - char and varchar
  287. SQL Functions & the Package cache...
  288. 7.2 to 8.1 DB2 migration problems
  289. Set Schema
  290. Prefetching only with >1 container??
  291. Platinum FASTLOAD on OS/390 error...
  292. CLOB length
  293. day of week from DATE function?
  294. One small problem, NOT LOGGED INITIALLY
  295. error found after db2dart
  296. Query No
  297. CPU Util on a Stored Proc
  298. ODBC Memory Leak
  299. Question on SORTHEAP and SHEAPTHRESH and SQL0955
  300. Does DB2 Workgroup Server Edition V8 support Microsoft Cluster?
  301. DB2 UDB equivalents to Informix "Forms" and "Ace"
  302. capture doesn't work properly
  303. DB2 UDB V8 inplace reorg
  304. How to find Log File usage ?
  305. decoded values for InstanceType=X
  306. Setting SQLDA variables
  307. Any good document about DB2 UDB Multi Partition Environment
  308. DB2 Connect Character Conversion Issue
  309. Ques on DB2 Administrative API
  310. Temp space
  311. Owner and Startfiles
  312. Temp space
  313. Short Character Strings using DB2 and Visual Basic
  314. Creating Global Temp Table in UDB DB2 v8
  315. name limits on 390
  316. How to use SQLBindParameter for double or float datatype
  317. db2gov: limiting access to DB2
  318. setting optimizing class on iseries
  319. Force all users to disconnect before backup
  320. What is these messages in the db2diag.log ?
  321. March 15: Rick Cattell, Peter Coffee, Dana Florescu, Jim Gray, Jim Kleewein, Jim Melton discuss XML, services and grid
  322. Suddenly _ZdlPv rellocation error from Base Client Support
  323. Setting queryopt on a per stored proc basis
  324. OneClickRevelation: JDX Provides Instant and Interactive Insight Into Your Data
  325. Setting date format on EXPORT / conversion of date to timestamp
  326. Visual studio 2003
  327. lob, odbc, java and speed
  328. Setting the prefetch size.
  329. Sample script for backups using DB2 v8 on Windows and TSM
  330. Details
  331. Sample script for backups using DB2 v8 on Windows and TSM
  332. recovery on-line backups a question on logs
  333. Db2 Everyplace uni-directional synchronization
  334. Host Variables and Table names = Dynamic SQL ?
  335. Socket Error in DB2
  336. Best Book Explaining Tuning UDB
  337. jdbc problem
  338. LIST ACTIVE DATABASES
  339. Host Variables
  340. "SQL Getting Started" for DB2 8.1.x?
  341. granting db2expln for the public?
  342. Fixpack 5 ADC for Windows changes the decimal separator of decimalcolumns from a dot into a comma
  343. Cannot install Windows Application Development Client Fixpack 5 onWindows XP Professional
  344. DB2 on AS400: Manipulate journaling via JDBC?
  345. Documentation help SQL procedures DB2 v8 linux
  346. How do I know how many times a particular statement was executed UDB V8 on Aix 5
  347. Help : Complex SQL query
  348. interpertting a db2expln
  349. Creating a DB2 7 FP 11 Installation CD
  350. Usage of DB2WWW
  351. Gateway Connections in Control Center DB2 V8
  352. Relational Connect
  353. active logs
  354. How to apply fixpak and patch on DB2 UDB?
  355. caution using restore DB2 database from v7 to v8
  356. DB2 8.1 db2cc DB2JAVIT : RC = 11 Error // SuSE 9.0 Kernel 2.4.25
  357. Nicknames are pointing to what tables????
  358. log files linux
  359. Update without requiring a commit
  360. Scrollable ResultSet
  361. Version 8, FixPak 5 is now available
  362. PC -> Db2 Connectivity Question
  363. ORA8.TO_CHAR function in DB2
  364. private sort VS shared sort
  365. Is nonlinear recursion allowed? Does it leverage index?
  366. EVI in DB2 UDB 8?
  367. create tools catalog failure
  368. DB2 - Unicode Questions
  369. DCLGEN on a PC
  370. Minimum Recovery time on tablespace
  371. Help with DB2 V7.1 Client Installation
  372. transaction logs mirroring
  373. r e: question on embedding literals in load statements
  374. Calling stored procedure from CLP
  375. stress db2 database tool
  376. Restore to new database
  377. Problem registering Stored Procedure
  378. Security in a Web-based application
  379. Increase size of DB2 z/OS catalog
  380. Increase DB2 catalog space on OS/390
  381. Skip scans in DB2
  382. ISeries DB2 UDFs and Stored Procedure
  383. asynchronous open
  384. Get last used date of a view.
  385. Test for numeric value in a varchar field
  386. EMC's Time Finder for DB backup
  387. PEAR DB 1.6.0 has been released
  388. health monitor - partitioned databases
  389. Update more then 600 records - db2 7.2 on Win 2000, programing MS VB6.0
  390. Omegamon for OS/390 help
  391. db2look and dependencies?
  392. db2look and dependencies?
  393. sqldbdir
  394. db2 move not working with administration client
  395. [DB2] No SQL-Delete possible. Need help! Getting sick!
  396. getting started with spatial extender
  397. db2 backup, StorageManager
  398. DB2 UDB v8 on Aix 5.2. Calculating how long to restore?
  399. SQL0804N on db2 connect v8.1
  400. Experience with DB2 II
  401. Memory Sharing between Databases
  402. Problem with DB2 XML Extender and JDBC on AS/400
  403. Error enable database for use with xml extender
  404. LDAP cataloged database
  405. LDAP cataloged database
  406. Query a table?
  407. What's the Difference 8.1, 8.1.2, SBCS, etc ?
  408. dxxadm fatel error --- libicudt20b.so
  409. Database connection
  410. Precision errors when aggregating data
  411. Using a SQL Table function in a view ...
  412. SET Integrity Exception Table - How to use
  413. about recovery
  414. Snapshot monitor, SQL statement question
  415. Oracle statspack Vs DB2 ???
  416. qmail SMTP server rejecting DB2 email notifications
  417. Looking for Experiences Running DB2 for OLTP Database (>300GB)
  418. Oracle Net VS DB2 Connect
  419. "Connection is dead" on ODBC insert of decimal into DB2
  420. DB2Connect - JDBC Problem
  421. Linux db2 memory limit
  422. EXPLAIN - Influencing the Optimizer
  423. big difference for the query time cost
  424. Unloading LOBs on DB2 v7.1 on OS/390
  425. Error CLI0129E and use of CLIPKG
  426. DB2 equivalent to Oracle:Trace or SQL Profiler?
  427. JCL to Unload fields from database
  428. certification/validation resp. stability of IBM DB2 UDB for state-of-the-art linux distributions (eg. suse 9.0 professional)
  429. Regarding Online Backup logs
  430. db2-php on linux
  431. Admin API equivalent to "db2 terminate"
  432. Serious DB2 error
  433. SQL1224N A database agent could not be started to service a request
  434. AIXupgrade with Db2/SAP
  435. Severe Problem using JDBC PreparedStatement with IBM DB2 Universal JDBC Driver as Type 4
  436. store binary data in db2
  437. SQL30020N return code 1245 when accessing db2 VM db via .asp
  438. DB2 DASD Storage (MVS)
  439. 64GB limit for 4k page sized tablespace
  440. Trial & beta version limitations?
  441. Does this newsgroup also cover DB2E?
  442. DB2 physical layout - comments needed
  443. Express edition and Novell
  444. drop tablespace in 390
  445. Upgrade for DB2 7.2 Workgroup edition?
  446. OLEDB and Dates and Timestamps
  447. UDB Logging Strategy ?
  448. SQL7032N Store Procedure is not created
  449. Security implications of using set current sqlid
  450. character-based Windows DB2 interface? Recommendations?
  451. Using single processor license on multiprocessor machine
  452. Restore of tablespace
  453. sms tablespace: decrease Size
  454. How does DB2's estimate size tool calculate avg row size when the table is empty?
  455. "USE" statement in AS/400 DB2 SQL
  456. "USE" statement in AS/400 DB2 SQL
  457. Does changing computer name impact WAS ?
  458. Can't get stock Mandrake 9.2 PHP to connect
  459. Parallel tasks during DB2 for Z/OS Copy
  460. LOB SMS file segment allocation increases exponential means more fragmentation?
  461. DB2 Database Uptime
  462. DBCS enabling in DB2
  463. EXT3 as problemsaver
  464. DB2/UDB 7.2EE , db2 admin user db2xy1 password change timing under AIX
  465. When $INSTHOME/sqllib is created and populated?
  466. UNCATALOG/CATALOG
  467. Simple FORCE APPLICATION question....
  468. Authentication at Instance Vs Authentication at Database
  469. Help with DB2 Client for Linux
  470. Row Number or subset of select.
  471. Maximum number of connections per user
  472. Restore Error - SQL1035N The database is currently in use
  473. Error in db2diag.log V8.1 FP4
  474. Too many items in IN clause?
  475. Identity OR sequence which is better
  476. Database backup in V8
  477. UDB 7.2, LDAP and ODBC Data Sources on Client
  478. page was victimized
  479. Cannot run scripts from Script Center
  480. Missing Summary tables after Restore
  481. Error using autoloader config file in V8
  482. Issues with LEFT JOIN through ODBC iclient Access
  483. DB2 Command Question
  484. Intra-parallelism Parameters
  485. Passing a java array in to a DB2 stored procedure
  486. DB2 FP4, BackupCompression
  487. DB2/UDB 8.1 (64bit) restore to DB2/UDB 7.2EE (64 bit) under AIX
  488. UDB Query
  489. Getting Offset error
  490. db2mtrk
  491. Error running db2 utilities on ZOS
  492. referred more than once in access plan means?
  493. Index on CHAR(N) FOR BIT DATA?
  494. db2 db2wa.war deployment on websphere.
  495. Better index access = worse performance??
  496. unable to get result data using php
  497. FP backout
  498. views and db2look
  499. DB2 capabilities
  500. CHANGE SERVER NAME INTO ODBC
  501. How to check Application Client installed or not in Solaris?
  502. Can not uninstall DB2 V8.1 FP4 under Windows 2003 Server.
  503. Windows query tool for DB2/400
  504. Unable to allocate new pages in table space
  505. DB2 Stored Procedure in REXX
  506. Updating columns w/ same value - will DB2 optimize for me?
  507. Upgrade DB2 v7 -> v8 and new server h/w. Best approach?
  508. UDB 8.1.4 & VB6/ADO
  509. Equivalent of VARRAYs in DB2
  510. SQL5035N The database requires migration to the current release.
  511. Where can i find Natural for DB2 programmer guide?
  512. Problem with db2mscs
  513. Does anyone use database modeling software?
  514. Unable to See"Sample Contents" of a Table
  515. Pseudo Check Constraint
  516. yipeee!
  517. RI violation. Has somebody ever seen this?
  518. Migrating from MsSQL to DB2/400
  519. RAID5 and tablespaces
  520. importing data from customer workstation
  521. Health Monitor
  522. How to set default schema name?
  523. Intermittent Beep
  524. Problem with locks
  525. Failure while installing Event Database. TEC 3.9
  526. Exporting large tables with a lob column
  527. Union in Views: No Branch Elimination because predicate with NonCor-Subselect ?
  528. Need help with error: The specified driver could not be loaded!
  529. Which tablespce is used when running ALTER TABLE & CREATE INDEX
  530. v8.1 fp2 application server for DB2. Where is it?
  531. How to list tables in order (parent & child relationship)
  532. DB2 Archive Log from Tape to DASD
  533. Create server error ...
  534. Did you know... that IBM's DB2 websites are now "googled"?
  535. checksum question
  536. DB2 suddenly become unable to NIS authenticate?
  537. how UDB reuse the Secondary Log Files
  538. Using GROUP BY and MAX() to ignore NULL ?
  539. Migrating from Solaris to Linux
  540. Recovery after Crash
  541. COLLATE USING IDENTITY
  542. DIA7523E, Error in Generator?
  543. SQL1092N "" does not have the authority to perform the requested command.
  544. Communication error SQL30081N ?
  545. Import vs Insert into with select
  546. Why no unsigned integers in DB2?
  547. FP4a 32 bit Aix compatibility question
  548. transaction log
  549. Clearification of 32 and / or 64 DB2/UDB 8.X backup restore under AIX 4.3 and AIX5.2
  550. How to determine field length in an unicode database