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. db2move questions
  2. db2move questions
  3. temporary tablespace without sufficient page for replication
  4. SQL UDF works very strange. Bug or feature?
  5. Same software, different hardware and abominable performance
  6. replication scheduling
  7. Migration path -> Unidata V6 to DB2 V8.2
  8. Any Info to join the "Serrano" Beta for the Next Websphere Information Integrator?
  9. Nickname in two phase commit ???
  10. Nickname in two phase commit ????
  11. -22205 return code from task center
  12. APAR IY66088
  13. Windows authentication on DB2 UDB 8
  14. Test Post - Ignoe
  15. DB2 Views
  16. Isolation question for DB2 beginer
  17. DB2/UDB B-Tree Indexing, Reverse Scans
  18. Call a View over SQL (DB2 UDB V8.1.6)
  19. using nextval in external udf
  20. UNION ALL View
  21. Stripe sets, high watermark and restores
  22. export package
  23. join 2 databases
  24. DB2 & System Dates
  25. DB2 Client on SUSE 9.3?
  26. Triggers - can I have it fire only if certain columns actually change?
  27. Raw Device Wiggle Room?
  28. read only standby db
  29. SQL Abfrage auf DB2 UDB V 8.1.6
  30. Problem with UDF
  31. Migrating Application SErver with DB server
  32. DB2 HADR 8.2.2 for REORG maintenance
  33. Database lost - Help me
  34. Database lost - Help me
  35. Database lost - Help me
  36. locate and select
  37. Confused over data page utilization
  38. Unexpectend end of ZLIB input stream ???
  39. split mirror : high availability
  40. db2move problem
  41. Problem with sqlp_AsyncLogReadAPI, generating error every 2 second
  42. Scope problem? UDB DB2 R8.1.5 Linux
  43. result set is closed
  44. Handling Money Via UDT / UDF (i.e. homegrown "extender")
  45. Oracle Transparent Gateway
  46. How large of a bufferpool can you create?
  47. Message being sent to port 523 (DAS)
  48. PRUNE Logfile Command Question
  49. Days/date redux UDB DB2 8.1.5 Linux
  50. HADR works with Peoplesoft (JDEdwards)
  51. Password Settings
  52. some problems with the replication
  53. Cleaning up after a crash
  54. Problem Upgrading to FP9a Using Alternate Fixpack
  55. update db cfg dbheap
  56. SQL0567N
  57. Fixpack 9a now available
  58. Index / Primary Key
  59. Transaction Log Full and Stored Procedure
  60. DB2 Connect Problem
  61. Redirected restore problem
  62. backup
  63. JCL or CICS from store procedure
  64. Search multiple job sites for you!
  65. Problem with SQLFreeStmt
  66. backup image compatibility between different versions
  67. windows executable error - db2
  68. Db2 select statment
  69. Different NUMBLOCKPAGES across Partitions (DPF)?
  70. problem with db2 authentification
  71. Passing And ARRAY to a Stored Procedure
  72. Problems with Type 4 jdbc driver
  73. Consultant Needed
  74. Best Practices for Copying of Data Between Instances
  75. file versus command line issue
  76. How to extract a list of top running queries on a database on a single day
  77. Poor insert performance
  78. Tempspace only one container is being used - EEE!
  79. how to update sqlj routine source in catalogs ?
  80. Invalid arg exception when connecting to db w/underscore in name
  81. convert duration in seconds to hh:mm:ss
  82. Activate db - command changed in 8.x?
  83. abysmal performance with scalar query
  84. Program querying DAS for isntances/databases
  85. How to pad a sequence value with zeros
  86. Emergency question about SQL0818 gotten on SQLJ proc
  87. converting existing DB2 v8.1.1.72 AIX 5.2 to 64-bit. Need info please.
  88. Database size
  89. Prove HADR
  90. db2 store procedure-- sqlstate=38503
  91. jdbc connection crashing database
  92. Union Problem
  93. Moving database to a larger hard disk partition
  94. DB2 Managed Service Provider
  95. script to restore db from comand line
  96. Change passwd programatically?
  97. Last commited transaction less then backup image timestamp after restore with rollforward?
  98. Moving home directory on DB2 instance?
  99. HIS 2000 connectivity problem
  100. replication
  101. db2 AIV extenders for Linux
  102. problem with a binary (maybe)
  103. installing db2 8.2.2 on RHEL4
  104. How to use cygwin xterm and db2
  105. SQLSTATE: 23505 UDB DB2 8.1.5
  106. Backup Options
  107. DB2 in production environment.
  108. Schema Mapping
  109. Connection to iSeries with Windows credentials requires Local Admin rights
  110. Tools to convert Mysql DDL to DB2
  111. AppDetective and DB2 instances
  112. Federated Insert and local update in on transaction not possible
  113. decimal to char problems
  114. Libeay32.dll conflict
  115. Make DB2 administrative APIs available through SQL
  116. DB2 Everyplace problems
  117. File System Full
  118. RTRIM is not truncating trailing spaces at the end of the line
  119. files under db2dump
  120. Replication Center SQL Replication Subscription sets
  121. User password?
  122. Seek DB2 translation of complicated Oracle join statment
  123. DGTT Changes access plan (extra SORT + RIDSCAN)
  124. Accessing old IBM DB2 V5.2
  125. restore db2 backup with include logs
  126. ODBC Driver
  127. Decomposing XML
  128. ONLINE REORG
  129. DB2 Archive Failure
  130. Workload/Query Generator
  131. Execute multiple statements in a Procedure
  132. Backup Question
  133. db2advis - works with indexes but not MV
  134. Status codes from Various UDB Utilities
  135. Pivot or Invert row data
  136. Automatic table maintenance
  137. Restore catch 22 db2 udb 8.1.5
  138. DB2/UDB and Read Locks
  139. DBexpress with DB2 questions
  140. Max number of Cursors?
  141. SQL30020N Execution failed because of a Distributed Protocol Error
  142. Cannot create sample database
  143. Date format db2 udb
  144. Where do I find out more?
  145. What is the difference between workgroup server and enterprise server edition?
  146. DSNTIJMS job in DB2 for z/OS
  147. Get human-readable error meesages ala db2 ? sql00911
  148. Number to Time Conversion
  149. No error messages from bind
  150. Structured type
  151. SMTP refuse email <instance>@<host>
  152. CONNECT TO hangs, no response
  153. How to detect running under RRSAF or CAF?
  154. Size of "Indexes and Materialized Views"
  155. Seek DB2 translation of Oracle statement with date stuff
  156. performance & behaviour question
  157. Lost active log, can't connect to database..
  158. db2v81 PE inst on gentoo(linux),amd64
  159. HADR primary connection failure tryin to communite to standby
  160. Empty Query Cache
  161. Warehouse Manager Agent problem
  162. use dynamic SQL in external user-defined table function
  163. * Need help on Backup *
  164. Monitoring And Maintenance
  165. Position open to fill - embarking on Data Warehouse project
  166. problem with a restore maybe ...
  167. DSNU255I in a LOAD LOG NO RESUME YES
  168. Corrupted download files for DB2 8.2 PE Linux 2.6
  169. MQSEND on z/OS and DB2
  170. Other memory
  171. Help Product Information - Information Integrator for SyBase to UDB Migration
  172. SQL - Unexpected Token "date/interval"
  173. OFF TOPIC: x86 Server Selection
  174. db2diag.log error
  175. generate row number in result set?
  176. Dates not in the future
  177. Query Execution Time
  178. >255 chars into stored procedure via ado
  179. Latest stable version?
  180. Transferrate / overhead
  181. Restoring from a crashed system.
  182. -101 on alter table statement
  183. URGENT:Exporting and Importing data using IXF format
  184. question about online backups
  185. Problem with updates via MS Access
  186. logfile on db2
  187. Can I customize DB2 catalog with my own tables?
  188. SQL0206N "C" is not valid in the context where it is used. SQLSTATE=42703
  189. Information Integrator - AIX ODBC - any user experiences?
  190. Question on dropping a trigger
  191. Library issue
  192. No Subject
  193. problem with different access plan (slow & fast) for the same SQL-Statement
  194. Code in the database or middle tier (the CLR controversy)
  195. db2pgixt
  196. log_retain_status and logarchmeth1
  197. Problem with federated database
  198. I am a new user help needed
  199. Problem with a query with MAX function
  200. why I can't display a jpg Blob field in web?
  201. SAR file -- can this be imported and edited?
  202. SQL-to-XML error when calling dxxgenx
  203. way to speed-up/tune database creation?
  204. Database market share 2004
  205. db2 backup issue on windows
  206. SQL10007N Message "-1390" could not be retrieved. Reason code: "6".
  207. haven't got a clue on this error.
  208. Unable to restart DB2 Instance
  209. A SOLUTION FOR ASP.NET DEVELOPERS USING DB2
  210. Run-Time Clients
  211. customize CREATE DATABASE
  212. URGENT:Anybody out there with DB2 6.1 SDK for windows
  213. URGENT:Anybody out there with DB2 6.1 SDK for windows??
  214. SQL0270N How to create Java UDF with SQL?
  215. ERROR when using get db cfg command
  216. SQL0950N error
  217. SQL0518N
  218. Unlocking DB2 table/row locks
  219. reorgchk reorg interpretation
  220. SQL0973N QUERY_HEAP_SZ to small
  221. Date format question
  222. Query syntax
  223. Query question
  224. Importing from DEL file where a column value begins with a " ?
  225. Could not build query
  226. Hardware Planing..
  227. How to make a Query with diffrent variables, beeing empty or not?
  228. DB2 8.2 JDBC Application --> CHARACTER and CHAR
  229. increase cpu usage for a db2 process
  230. Importing V8.2 IXF files into V5.2
  231. where to find V7 release ?
  232. Automatic Storage
  233. unable to connect to a db2 server through the control center ... - Help !
  234. db2/UDB replication problems (maybe ...?) - Help needed
  235. Test
  236. Extender server problems
  237. Replication Cold Start
  238. Production Support Analyst Needed
  239. Matching IP Address to subnets.
  240. Net View Ext & BLOBs
  241. Connections
  242. NetApp Filer
  243. Vennela Technologies Offering Beautiful Courses On Oracle
  244. Insert CLOB / BLOB
  245. Loading datetime values from SYBASE into DATE type in DB2
  246. DB2 restores with Veritas NetBackup?
  247. Where can I find what type of field DB2 has
  248. JDBC issues with setBinaryStream an AbstractMethodError and a cast
  249. Calling a DB/2 v8.2 stored procedure from perl
  250. Supra to DB2 migration
  251. cannot connect from Crystal Reports to remote DB2
  252. 8.2.2. Windows "net stop db2-0" with activated databases does not work
  253. looking for not JAVA admin tools for UDB V8
  254. DB2 Stored Procedures called from REXX
  255. Login to AS400 from SQL Data Transformation Services
  256. 8.2 Windows: Health Monitor not always work
  257. CLI0112E Error in assignment
  258. Coding Standard for developing Stored Procedures
  259. SQL0444N Routine "DB2XML.CONTENT"
  260. need header values
  261. Db2 v 8 is buggy
  262. Code page problem: workaround
  263. Where to find FP9 for Linux with kernel 2.6?
  264. Optimization level in db2?
  265. Error: [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=S1010 while using ADO
  266. copy database structure
  267. compact lob data?
  268. PDE 8.2.2 untar problems
  269. Problem connecting from AIX to Windows.
  270. federated databases on 2 instances
  271. Transaction log full
  272. Comparison of Performance of SQL and external Procedures
  273. Doc Fixpack 9 for V8 ?
  274. URGENT! trouble with char conversion from nickname
  275. iSeries DB 2 to UDB2 V8.1
  276. a query at db2
  277. unload data
  278. String data right truncation. SQLSTATE=22001
  279. unable to load DLL 'db2app.dll'
  280. Allocation error when allocating memry to CLOB host variables
  281. ROLLFORWARD QUESTION
  282. relation_data_serv problem
  283. sqldEscalateLocks and performances
  284. Stored Procedure - Handling all error code with a single condition !!
  285. Problems with code page
  286. the USER
  287. I think to have a problema with DB2_SQLROUTINE_COMPILE_COMMAND
  288. Install DB2 in an FSIOP/IxS Card in an iSeries
  289. JAVA udf 8.2.2
  290. SQL Stored Proc - Security issue
  291. creating dsn for mainframe db2
  292. New Registry Variables in 8.2.2 (FP9)
  293. HELP ME problem with *.sqc
  294. Handling Time Stamps
  295. No system temporary table space and a SQL query
  296. Deadlock or Timeout when delete/update rows with BLOB
  297. Restoring Journals on an iSeries Box
  298. method to write to a flat file from Stored procedure
  299. HELP! Variable looses value in loop within trigger
  300. get snapshot for dynamic sql
  301. Strange or normal IDENTITY behavior?
  302. DB2 V8.2.2 Manuals (FP9)
  303. Seek equivalent of Oracle's empty_clob() for CLOB creation
  304. Equivalent of Oracle's DBMS_LOB.GETLENGTH(COLUMN_NAME)
  305. Enabling database for DB2IMAGE
  306. Strange inconsistences when repeating a query more than twice in a row
  307. Strange inconsistences when repeating a query more than twice in a row
  308. Is there a "go to" statement in DB2 Stored Procs.
  309. viewing privileges for stored procedures
  310. Aggregating text
  311. Trigger syntax ? problem
  312. multilanguage problem
  313. connecting to remote 7.1 db2 database
  314. Equivalent of Oracle's to_date('03/04/2005','MM/DD/YYYY')
  315. Comparing dates using date function and arithmetic
  316. how to print a new line character
  317. db2LogRead API Error
  318. Control Center lock
  319. accent insensitive diacritic insensitive data retrieval
  320. custom collating sequence
  321. generated column
  322. Stored procedures in SYSPROC schema
  323. primary =/=> unique?
  324. FP9 / can't find Apar GG04517
  325. FP9 installer breaks Information Center (Windows)
  326. Using LOWER function in DB2
  327. db2app.dll
  328. Creating Dataset from DataAdapter VS.Studio.NET & Db2
  329. db2 concurrency control question
  330. DB2 equivalent of Oracle to_char(created_date,'MM/DD/YYYY')
  331. How to define this kinds of constraint.
  332. Accessing Oracle from DB2 Stored Procedure
  333. Shameles self-promotion
  334. problems with UNION
  335. changing password
  336. unloading data from db2 v6 tables to os390
  337. Queston on DB2 lock
  338. SQL Stored Procedures X Java Stored Procedures in DB2 8.2
  339. Problem with sequence in UDB 8.2
  340. data warehouse
  341. DIA0001E An internal error occurred. Report the following error code : "ZRC=0x8136001C".
  342. Performance: CAF vs RRSAF
  343. SELECTing from multiple databases?
  344. Password invalid, when logging on as db2inst1 with a password
  345. SYSPROC.ENV_GET_INST_INFO() not working...
  346. Need good idea
  347. DB2 UDB v8.2 Fixpack 9 Problem starting Information Center
  348. tablespace move from 32K to 4K page size on same instance
  349. DB2 version info
  350. Error Installing ESE Fixpack 9 for Windows - Help Please
  351. error sqlriResolveOpFunc
  352. Quck question on port numbers for V8.X and HP
  353. Stored Procedures: RESULT SET.
  354. Stored procedures debugging.
  355. DB2 Fixpak 9 now available for LUW
  356. [Fwd: Double lock on iseries db2 ado.net transaction]
  357. Sr. Database Engineer Needed - Preferably DB2 (Silicon Valley)
  358. Help creating trigger
  359. db2 connect statement with current schema
  360. DB21015E - New Error with Fixpack 8?
  361. how to copy a clob column data......
  362. selecting data based on rowid
  363. federated database
  364. Simple question
  365. how to pass value to a stored procedure at runtime....
  366. SQL
  367. Clone a partial DB on Linux running in circular mode
  368. SET INTEGRITY question
  369. Help with an SQL Query
  370. Calling sqleintr or exit causes program (linux) to hang (due to deadlock by pthread)
  371. Cannot grant sysproc function to user
  372. DB2 Data directly into Microsoft Excel
  373. DB2 crash?!?
  374. UDB v 8.1 - SQL0925N SQL COMMIT invalid for application execution
  375. UDB v 8.1 on win2000 - SQL0925N SQL COMMIT invalid for application execution
  376. Connect to remote server using db2 and Perl
  377. Translate this Oracle Trigger ...
  378. Help with Oracle to DB2 trigger translation
  379. Row Locking issue
  380. event monitor -dropped default one
  381. Db2 server problem, Urgent please need suggestions
  382. Data Compression
  383. SEARCH / KNOWN discovery question
  384. Same statement, different application, different runtime
  385. If statement
  386. Passing a resultset from a nested Stored Procedure
  387. Cannot alocate 2,4 GB for Bufferpools, DB v 8.2.1 on AIX 5L
  388. problem running db2cc, DB2 v.8.2 on AIX
  389. Generating rows on the fly
  390. Please Help - DB2 Specialist Consultant Required
  391. sql1042C / sql1036C on create database?
  392. client v7 to connect v8.1 mts error
  393. DB2 Optimizer is not using Summary Table (DB2 V 8.1.7)
  394. Load commit
  395. INSERT INTO ... FROM NEW TABLE
  396. Problem when archiving log files
  397. DB2Advisor error
  398. How to configure windows with ibm db2 odbc driver?
  399. Proyectos de Inversion en IT en la Universidad Tecnologica Nacional
  400. DB2 SNMP Monitoring - Missing the Boat - Big Time
  401. JDBC Driver Defaults
  402. Client Access ODBC DB2 driver problem
  403. LDAP authentication for DB2
  404. Placing a Lock at record level in a table.
  405. Browsing through a table
  406. Federated database problem
  407. Calling stored procedure in a trigger
  408. How to view the status of DB2 Load utility on Windows/Unix
  409. what is the difference between cloudscape and derby?
  410. Problem DB2 connect with JDBC
  411. DB2 V6.1.027 Userexit problem
  412. Querying on table within a variable
  413. Problem with multiple rows insert on MVS OS 390
  414. Data loads: Offline performance with online benefits
  415. simple sortheap question
  416. Stored Procedure problem in DB2 for OS/390 V6
  417. Cyrillic characters from Oracle-nickname
  418. every java sp gets error:sql4301N java interpreter startup or com failed. reason 0
  419. exportXML with multiple records
  420. DBA HELP: Performane Tune SELECT, SUM, & CASE
  421. db2advis giving errors - not able to INSERT into ADVISE_INSTANCE table
  422. DTD to XSD
  423. Connecting to Different Physical Node on Partitioned Database on DB2 8.1.6
  424. Error Executing Assembler Program from a Stored Procedure
  425. hand-rollforward on a standby for windows
  426. update with join of multiple tables
  427. Replace DB2 7.1 CD-ROM
  428. Subquery returning a column value
  429. Testing db2 imp and load
  430. Type-2 index question
  431. Manual Instance removal on XP
  432. select statement -format longer record result set!! HELP PLEASE!!
  433. Error 5005C after Migration from UDB7 to UDB8 (AIX)
  434. Memory used - what is "Other memory"?
  435. db2 CLP and PS output on AIX
  436. Stored Procedures in OS/390 V6
  437. does eXadas really work???
  438. Snaphot_table function gives unexpected result
  439. DB 7.2 Replication And DR
  440. Logging And Performance
  441. SECQTY Maxiumum Value for Z/os version 7.2
  442. access plan with sequence in params
  443. EXECUTE SQL-string from StoredProc
  444. Accessing DB2 UDB on Linux from within a DB2 VM Cobol program
  445. Washington Area IBM-Informix/DB2 User Group meeting - June 7,2005
  446. Myths
  447. View Error : Iseries Navigator
  448. Newbee - Schema concept question
  449. Newbee question - why no create user in DB2 ?
  450. ERWin data modeler, iSeries DB2 reverse engineering error
  451. insert/select question
  452. Java on DB2 for OS/390
  453. Creating Crosstab with drilldown
  454. Help with JDBC Driver
  455. Insert bulk data into table & temporarily disable log
  456. DB2 8.2 Performance drop on Query compared to 7.1
  457. MQ Functions on DB2 for LUW V8.2
  458. Deferring constraints in DB2
  459. Can 8.1 package be bound to 7.2?
  460. standby db on windows
  461. Snapshot_LockWait table function question
  462. DB2CONNECT V6.1 SU LINUX REDHAT
  463. DB2CONNECT V6.1 SU LINUX REDHAT
  464. DB2 for z/OS problem - empty tablespace growing in size
  465. DB2 for z/OS Visual Explain: Fail to load JDBC driver
  466. DB2 Flush Dynamic SQL Cache and E70081 z/OS V7.1
  467. How many tcp ports does DB2 use?
  468. DB2 Flush Dynamic SQL Cache and E70081 z/OS V7.1
  469. check unique
  470. drop table conditionally
  471. Error in sql REPLACE
  472. indexes
  473. Coverting decimal field to db2 date?
  474. A little question on PREFETCH / MDC
  475. Create Function or Create Procedure
  476. Create Function or Create Procedure
  477. Suggestion for DB2 Improvement
  478. What is the best way to change Extent Size
  479. help request
  480. Recursive queries in SQL3 and graph transitive closure
  481. DB2 Load into multiple tables using control centre
  482. DB2 Replication Error - Oracle 10g to DB2 8.2 (8.1.8)
  483. Cursor Script in CLP please...
  484. Query
  485. Using the SMTP that Task center Uses.
  486. Comparative between DB2, Informix and Oracle
  487. Isolation level ignored when DTC is used
  488. access plan when view has rank()
  489. REPEAT --> Simple Question on Statement Size
  490. How to join with a subquery conditional DB2 UDB 8.1.5 Linux
  491. Graphic columns not allowed
  492. post test
  493. Where can I find the source of structured type?
  494. afficher 2 count de de tables
  495. UDB 8.2 FixPak 9 for LUW
  496. Logging And Performance
  497. Use of variables
  498. Revalidating all inoperative packages from SQL (not CLP!)
  499. Schemas in SQL Stored Procs for WSE 8.2 on Linux
  500. Sort Order
  501. Have you ever met worse case than this?
  502. quiesce disconnects but restart doesn't???
  503. where not exists
  504. Sybase to DB2
  505. plz send the ans
  506. Redirected Restores & Set tablespace container
  507. Too Simple Question: Statement Size
  508. Info Integrator configuration options
  509. BLOB Field Size Limit And Logging
  510. W2K to W2K3: Cross Platform Restore Error?
  511. Create function error DB2 UDB v8.1.5 Linux
  512. dynamic SQL in stored procedure. Need Help
  513. db2look
  514. Oops, dropped an rlv that was in use... Need to recover...
  515. DIA9999E with error code 0x4 during create server
  516. ODBC from DB2 connect does not allow outer joins
  517. TCPIP Error
  518. Automated snapshot data
  519. DDL question WRT adding NOT NULL constraints
  520. Insert LOGS
  521. Dat File Database Format??
  522. show explain plan
  523. Trying to prep .SQC files in Visual C++
  524. call of sqls
  525. Linux and DB2
  526. Is the DB2 Command Center = the Control Center?
  527. Recursion not allowed for common table expressions error
  528. Recursion not allowed for common table expressions error
  529. Recursion not allowed for common table expressions error
  530. Recursion not allowed for common table expressions error
  531. unable to load dll db2app.dll . Error using DB2 in ASP.NET application.
  532. Remove database aliases
  533. DIA9999E with error code -32
  534. DB2 Qualified Table Name Problem with ODBC.NET
  535. Grant global select/insert/update/delete to all users
  536. SQL1131N DARI (Stored Procedure) problem
  537. Column order of an Index
  538. UDF functions interdependency.
  539. DB2Connect V.8
  540. Enter Default Values for all columns in all tables except Primary Keys
  541. fixpak install but only on one instance
  542. Who knows the answer?
  543. Tools db process foiling backups
  544. DB2 UDB Enterprise Edition V7.1 License Question
  545. ignorant DB2 dilletante question: what's the syntax for a procedure...
  546. SQL22201N - I am unable to Proceed further
  547. chnage use identity column to sequence
  548. Creating a database and filling data using scripts
  549. db2look in V8.2
  550. Version 7 Compatibility