View Full Version : db2 answers


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 [15] 16 17 18 19 20 21 22

  1. Problem with Rebuild Index after loading data with DSN1COPY
  2. Handling Special character in openquery
  3. Problems with national characters
  4. SQL PL online manual/guide?
  5. Last Chance for VDC Embedded Database Survey - Takes Less Than 5 minutes...
  6. Last Chance for VDC Embedded Database Survey - Takes Less Than 5 minutes...
  7. DB2 UDB Security
  8. access pseries DB2 from iseries using COBOL and RPG
  9. Apply Program Not Moving Data
  10. db2_awe and more than 4GB memory on Windows
  11. NAS for DB2 active logs
  12. MDC Rollout
  13. Shameless self-promotion
  14. Oracle DBA Inherited DB2 System
  15. Trigger Failure Cancels calling transaction
  16. Performance of union all views
  17. Why does the execution plan hav a nested loop join when an UDF is used?
  18. SQL Procedure Question
  19. Embedded Database Research
  20. Where are the downloadable versions of the V8 manuals?
  21. Sybase to UDB Migration - Code Freeze
  22. Update Fails with SQL0407N
  23. sql replication script
  24. problem while index creation
  25. DB2 replication - Apply program not replicating
  26. Error in nested SQL Procedure
  27. SQL Statement length exceeded
  28. compact and compress?
  29. SET CURRENT LOCK TIMEOUT
  30. materialze query?
  31. Putting Information Center on hard drive
  32. 64-bit platform support for XML Extender
  33. Can I store binaries outside /sqllib/function?
  34. clob question.
  35. Get the DB2 version number through SQL (onMVS)
  36. How I can get statistics by indexes using?
  37. Packagename of a routine
  38. Change Server Name on a DB2 Server
  39. drop table/recover space
  40. Can I replicate data between a pair of databases in the same instance?
  41. Stored Procedures (db2dari.exe) sucking up memory
  42. Does DB2 WSUE supports 64 bit computing ?
  43. DIA3819C A file sharing violation has occurred, filename was ""
  44. UDB V8 FP9a "log data" monitor elements
  45. Cannot connect to db2 using jdbc
  46. Statement sequence in SQL Stored Procedure
  47. retrieving clobs over wan
  48. UDB V8 (Fixpak8) - "Database files closed" monitor element
  49. Why are the "same" queries optimised differently ?
  50. DBA2052E
  51. Db2 help needed
  52. DB2 V8 - user account TROUBLE
  53. DB2 port
  54. using jdbc to connect to db2
  55. Difference between a 'file' and a 'table'
  56. load utility does not work from control center
  57. Char in US Code page vs Char in UTF-8
  58. problem with unloading data from DB2 ver7
  59. problem with unloading data from DB2 ver7
  60. DB2 and PHP
  61. No future for DB2
  62. Vargraphic not available in GUI
  63. Prevent Infinite Looping in Q Replication
  64. Help! Call sql procedure - SQL1109N The specified DLL "SYSIBM.SQLPROCEDURECOLS
  65. show comments for columns ...
  66. solution on source code page "1114" to the target code page "UNKNOWN".
  67. Merge stmt
  68. Design Advisor does not recommend indexes !!
  69. UDb V8.FP6 - Finding NEXTVAL for IDENTITY COLUMN (not SEQUENCE)
  70. Reorg of very large tables
  71. UDB V8.2 (FP1) - DGTT WITH REPLACE vs. delete * from DGTT
  72. HADR / Q replication comparison
  73. Trying to get scrollable result set from SQL stored procedure
  74. commands to copy archived logs in disk to tsm
  75. DB2/390 v8 - union all subquery in select list returns wrong results
  76. Inner Joins and UDFs
  77. how to archive logs to disk and then use tsm to back them up to tape
  78. Table function GET_DBM_CONFIG missing in Fixpak 9
  79. How to Stop a Database
  80. DB2 AS400 convert character to date format
  81. DB2 AS400 convert character to date format
  82. unable to install SQL Express 2005 CTP
  83. overflows : interpretation
  84. DB2 Event Monitor puts "?" for all the values
  85. Help to compile C UDFs using gcc on AIX (bldrtn)
  86. Table size estimation
  87. Copying my DB2 database connections
  88. Need FixPack 7a urgently. Plz. Help!
  89. DB2 v8 --- Creating the DB2CERT database...
  90. DB2 v8
  91. DB2 replication setup step by step
  92. Help with "SQL30081N A communication error has been detected"
  93. DB2 and cygwin ...
  94. resetting monitoring switches
  95. Cursors defined as "WITH HOLD" are closed after commit.
  96. MQT/Staging Table/Syntax
  97. Division by Zero or changed order of applying predicates in SQL
  98. q replication/sql replication
  99. Pick until enough
  100. very strange ... SQL0910
  101. Modification time
  102. SQLSTATE 42997
  103. DB2 Replication - synchtime
  104. How do I increase the size of the output message parameter of a debugger
  105. SQL0270 RC 73
  106. HADR Questions
  107. DB2 solaris installation without open windows?
  108. DB2 Warehouse Site Agent!!
  109. privileges on packages - db2 8.2.2
  110. Journal - Task History - Database backup success is expired
  111. [Restore DB] backup from linux & resotore to windows
  112. Can we create an alias for a sequence in db2
  113. error : DIA3207E L'appel TCP/IP "gethostbyname"
  114. Will the new RECOVER Command run in parallel on a partitioned database ?
  115. DB2 migration v5 to v8.1
  116. Change a table's tablespace
  117. DB2 V8.2 FOR LINUX - REXX STORED PROCEDURE
  118. db2advis - Disk Limit Constraint
  119. TPC-H Query Results - 1GB DB
  120. Problem running control center.
  121. UDB 8.2 poerformance problem
  122. How to DELETE with COMMIT COUNT
  123. DB2 Before Insert Trigger not acting like before?
  124. SQL Problem - Date / Txn Sequences
  125. Bogus data type incompatible error SQLSTATE=22001?
  126. Select column user via clp without getting token user
  127. Can CLP output be timestamped?
  128. Problems with Java SPs on Win2003 server
  129. SQL0289 when Alter table space
  130. db2spmrsy
  131. Question about VARCHAR Vs. CHAR fields
  132. DB2 8.1 32-bit Linux migration to 8.2 64-bit on AIX
  133. Delete vs. Merge
  134. DB2 Connect V8, Schema functions, and CLI driver
  135. Materialized Query Syntax--I can't get the samples to work
  136. Problems with connection pool for DB2400
  137. Question on Package Cache Overflows
  138. db2move questions
  139. db2move questions
  140. temporary tablespace without sufficient page for replication
  141. SQL UDF works very strange. Bug or feature?
  142. Same software, different hardware and abominable performance
  143. replication scheduling
  144. Migration path -> Unidata V6 to DB2 V8.2
  145. Any Info to join the "Serrano" Beta for the Next Websphere Information Integrator?
  146. Nickname in two phase commit ???
  147. Nickname in two phase commit ????
  148. -22205 return code from task center
  149. APAR IY66088
  150. Windows authentication on DB2 UDB 8
  151. Test Post - Ignoe
  152. DB2 Views
  153. Isolation question for DB2 beginer
  154. DB2/UDB B-Tree Indexing, Reverse Scans
  155. Call a View over SQL (DB2 UDB V8.1.6)
  156. using nextval in external udf
  157. UNION ALL View
  158. Stripe sets, high watermark and restores
  159. export package
  160. join 2 databases
  161. DB2 & System Dates
  162. DB2 Client on SUSE 9.3?
  163. Triggers - can I have it fire only if certain columns actually change?
  164. Raw Device Wiggle Room?
  165. read only standby db
  166. SQL Abfrage auf DB2 UDB V 8.1.6
  167. Problem with UDF
  168. Migrating Application SErver with DB server
  169. DB2 HADR 8.2.2 for REORG maintenance
  170. Database lost - Help me
  171. Database lost - Help me
  172. locate and select
  173. Database lost - Help me
  174. Confused over data page utilization
  175. Unexpectend end of ZLIB input stream ???
  176. split mirror : high availability
  177. db2move problem
  178. Problem with sqlp_AsyncLogReadAPI, generating error every 2 second
  179. Scope problem? UDB DB2 R8.1.5 Linux
  180. result set is closed
  181. Handling Money Via UDT / UDF (i.e. homegrown "extender")
  182. Oracle Transparent Gateway
  183. How large of a bufferpool can you create?
  184. Message being sent to port 523 (DAS)
  185. PRUNE Logfile Command Question
  186. Days/date redux UDB DB2 8.1.5 Linux
  187. HADR works with Peoplesoft (JDEdwards)
  188. Password Settings
  189. some problems with the replication
  190. Cleaning up after a crash
  191. Problem Upgrading to FP9a Using Alternate Fixpack
  192. update db cfg dbheap
  193. SQL0567N
  194. Fixpack 9a now available
  195. Index / Primary Key
  196. Transaction Log Full and Stored Procedure
  197. Redirected restore problem
  198. DB2 Connect Problem
  199. backup
  200. JCL or CICS from store procedure
  201. Search multiple job sites for you!
  202. Problem with SQLFreeStmt
  203. backup image compatibility between different versions
  204. windows executable error - db2
  205. Db2 select statment
  206. Different NUMBLOCKPAGES across Partitions (DPF)?
  207. problem with db2 authentification
  208. Passing And ARRAY to a Stored Procedure
  209. Problems with Type 4 jdbc driver
  210. Consultant Needed
  211. Best Practices for Copying of Data Between Instances
  212. file versus command line issue
  213. How to extract a list of top running queries on a database on a single day
  214. Poor insert performance
  215. Tempspace only one container is being used - EEE!
  216. how to update sqlj routine source in catalogs ?
  217. Invalid arg exception when connecting to db w/underscore in name
  218. convert duration in seconds to hh:mm:ss
  219. Activate db - command changed in 8.x?
  220. abysmal performance with scalar query
  221. Program querying DAS for isntances/databases
  222. How to pad a sequence value with zeros
  223. Emergency question about SQL0818 gotten on SQLJ proc
  224. converting existing DB2 v8.1.1.72 AIX 5.2 to 64-bit. Need info please.
  225. Database size
  226. Prove HADR
  227. db2 store procedure-- sqlstate=38503
  228. jdbc connection crashing database
  229. Union Problem
  230. Moving database to a larger hard disk partition
  231. DB2 Managed Service Provider
  232. script to restore db from comand line
  233. Change passwd programatically?
  234. Last commited transaction less then backup image timestamp after restore with rollforward?
  235. Moving home directory on DB2 instance?
  236. HIS 2000 connectivity problem
  237. replication
  238. db2 AIV extenders for Linux
  239. problem with a binary (maybe)
  240. installing db2 8.2.2 on RHEL4
  241. How to use cygwin xterm and db2
  242. SQLSTATE: 23505 UDB DB2 8.1.5
  243. Backup Options
  244. DB2 in production environment.
  245. Schema Mapping
  246. Connection to iSeries with Windows credentials requires Local Admin rights
  247. Tools to convert Mysql DDL to DB2
  248. AppDetective and DB2 instances
  249. Federated Insert and local update in on transaction not possible
  250. decimal to char problems
  251. Libeay32.dll conflict
  252. Make DB2 administrative APIs available through SQL
  253. DB2 Everyplace problems
  254. File System Full
  255. RTRIM is not truncating trailing spaces at the end of the line
  256. files under db2dump
  257. Replication Center SQL Replication Subscription sets
  258. User password?
  259. Seek DB2 translation of complicated Oracle join statment
  260. DGTT Changes access plan (extra SORT + RIDSCAN)
  261. Accessing old IBM DB2 V5.2
  262. restore db2 backup with include logs
  263. ODBC Driver
  264. Decomposing XML
  265. ONLINE REORG
  266. DB2 Archive Failure
  267. Workload/Query Generator
  268. Execute multiple statements in a Procedure
  269. Backup Question
  270. db2advis - works with indexes but not MV
  271. Status codes from Various UDB Utilities
  272. Automatic table maintenance
  273. Pivot or Invert row data
  274. Restore catch 22 db2 udb 8.1.5
  275. DB2/UDB and Read Locks
  276. DBexpress with DB2 questions
  277. Max number of Cursors?
  278. SQL30020N Execution failed because of a Distributed Protocol Error
  279. Cannot create sample database
  280. Date format db2 udb
  281. Where do I find out more?
  282. What is the difference between workgroup server and enterprise server edition?
  283. DSNTIJMS job in DB2 for z/OS
  284. Get human-readable error meesages ala db2 ? sql00911
  285. Number to Time Conversion
  286. No error messages from bind
  287. SMTP refuse email <instance>@<host>
  288. Structured type
  289. CONNECT TO hangs, no response
  290. How to detect running under RRSAF or CAF?
  291. Size of "Indexes and Materialized Views"
  292. Seek DB2 translation of Oracle statement with date stuff
  293. performance & behaviour question
  294. Lost active log, can't connect to database..
  295. db2v81 PE inst on gentoo(linux),amd64
  296. HADR primary connection failure tryin to communite to standby
  297. Empty Query Cache
  298. Warehouse Manager Agent problem
  299. * Need help on Backup *
  300. use dynamic SQL in external user-defined table function
  301. Monitoring And Maintenance
  302. Position open to fill - embarking on Data Warehouse project
  303. problem with a restore maybe ...
  304. DSNU255I in a LOAD LOG NO RESUME YES
  305. Corrupted download files for DB2 8.2 PE Linux 2.6
  306. MQSEND on z/OS and DB2
  307. Other memory
  308. Help Product Information - Information Integrator for SyBase to UDB Migration
  309. SQL - Unexpected Token "date/interval"
  310. OFF TOPIC: x86 Server Selection
  311. db2diag.log error
  312. generate row number in result set?
  313. Dates not in the future
  314. Query Execution Time
  315. >255 chars into stored procedure via ado
  316. Latest stable version?
  317. Transferrate / overhead
  318. -101 on alter table statement
  319. Restoring from a crashed system.
  320. URGENT:Exporting and Importing data using IXF format
  321. question about online backups
  322. Problem with updates via MS Access
  323. logfile on db2
  324. Can I customize DB2 catalog with my own tables?
  325. SQL0206N "C" is not valid in the context where it is used. SQLSTATE=42703
  326. Information Integrator - AIX ODBC - any user experiences?
  327. Question on dropping a trigger
  328. Library issue
  329. No Subject
  330. problem with different access plan (slow & fast) for the same SQL-Statement
  331. Code in the database or middle tier (the CLR controversy)
  332. db2pgixt
  333. log_retain_status and logarchmeth1
  334. Problem with federated database
  335. I am a new user help needed
  336. Problem with a query with MAX function
  337. why I can't display a jpg Blob field in web?
  338. SAR file -- can this be imported and edited?
  339. SQL-to-XML error when calling dxxgenx
  340. way to speed-up/tune database creation?
  341. Database market share 2004
  342. db2 backup issue on windows
  343. SQL10007N Message "-1390" could not be retrieved. Reason code: "6".
  344. haven't got a clue on this error.
  345. Unable to restart DB2 Instance
  346. A SOLUTION FOR ASP.NET DEVELOPERS USING DB2
  347. Run-Time Clients
  348. customize CREATE DATABASE
  349. URGENT:Anybody out there with DB2 6.1 SDK for windows
  350. URGENT:Anybody out there with DB2 6.1 SDK for windows??
  351. SQL0270N How to create Java UDF with SQL?
  352. ERROR when using get db cfg command
  353. SQL0950N error
  354. SQL0518N
  355. Unlocking DB2 table/row locks
  356. reorgchk reorg interpretation
  357. SQL0973N QUERY_HEAP_SZ to small
  358. Date format question
  359. Query syntax
  360. Query question
  361. Importing from DEL file where a column value begins with a " ?
  362. Could not build query
  363. Hardware Planing..
  364. How to make a Query with diffrent variables, beeing empty or not?
  365. DB2 8.2 JDBC Application --> CHARACTER and CHAR
  366. increase cpu usage for a db2 process
  367. Importing V8.2 IXF files into V5.2
  368. where to find V7 release ?
  369. Automatic Storage
  370. unable to connect to a db2 server through the control center ... - Help !
  371. db2/UDB replication problems (maybe ...?) - Help needed
  372. Test
  373. Extender server problems
  374. Replication Cold Start
  375. Production Support Analyst Needed
  376. Matching IP Address to subnets.
  377. Net View Ext & BLOBs
  378. Connections
  379. NetApp Filer
  380. Vennela Technologies Offering Beautiful Courses On Oracle
  381. Insert CLOB / BLOB
  382. Loading datetime values from SYBASE into DATE type in DB2
  383. DB2 restores with Veritas NetBackup?
  384. Where can I find what type of field DB2 has
  385. JDBC issues with setBinaryStream an AbstractMethodError and a cast
  386. Calling a DB/2 v8.2 stored procedure from perl
  387. Supra to DB2 migration
  388. cannot connect from Crystal Reports to remote DB2
  389. 8.2.2. Windows "net stop db2-0" with activated databases does not work
  390. looking for not JAVA admin tools for UDB V8
  391. DB2 Stored Procedures called from REXX
  392. Login to AS400 from SQL Data Transformation Services
  393. 8.2 Windows: Health Monitor not always work
  394. CLI0112E Error in assignment
  395. Coding Standard for developing Stored Procedures
  396. SQL0444N Routine "DB2XML.CONTENT"
  397. need header values
  398. Db2 v 8 is buggy
  399. Code page problem: workaround
  400. Where to find FP9 for Linux with kernel 2.6?
  401. Optimization level in db2?
  402. Error: [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=S1010 while using ADO
  403. copy database structure
  404. compact lob data?
  405. Problem connecting from AIX to Windows.
  406. PDE 8.2.2 untar problems
  407. federated databases on 2 instances
  408. Transaction log full
  409. Comparison of Performance of SQL and external Procedures
  410. Doc Fixpack 9 for V8 ?
  411. URGENT! trouble with char conversion from nickname
  412. iSeries DB 2 to UDB2 V8.1
  413. a query at db2
  414. unload data
  415. String data right truncation. SQLSTATE=22001
  416. unable to load DLL 'db2app.dll'
  417. Allocation error when allocating memry to CLOB host variables
  418. ROLLFORWARD QUESTION
  419. relation_data_serv problem
  420. sqldEscalateLocks and performances
  421. Stored Procedure - Handling all error code with a single condition !!
  422. Problems with code page
  423. the USER
  424. I think to have a problema with DB2_SQLROUTINE_COMPILE_COMMAND
  425. Install DB2 in an FSIOP/IxS Card in an iSeries
  426. JAVA udf 8.2.2
  427. SQL Stored Proc - Security issue
  428. creating dsn for mainframe db2
  429. New Registry Variables in 8.2.2 (FP9)
  430. HELP ME problem with *.sqc
  431. Handling Time Stamps
  432. No system temporary table space and a SQL query
  433. Deadlock or Timeout when delete/update rows with BLOB
  434. Restoring Journals on an iSeries Box
  435. method to write to a flat file from Stored procedure
  436. HELP! Variable looses value in loop within trigger
  437. get snapshot for dynamic sql
  438. Strange or normal IDENTITY behavior?
  439. DB2 V8.2.2 Manuals (FP9)
  440. Seek equivalent of Oracle's empty_clob() for CLOB creation
  441. Equivalent of Oracle's DBMS_LOB.GETLENGTH(COLUMN_NAME)
  442. Enabling database for DB2IMAGE
  443. Strange inconsistences when repeating a query more than twice in a row
  444. Strange inconsistences when repeating a query more than twice in a row
  445. Is there a "go to" statement in DB2 Stored Procs.
  446. viewing privileges for stored procedures
  447. Aggregating text
  448. Trigger syntax ? problem
  449. multilanguage problem
  450. connecting to remote 7.1 db2 database
  451. Equivalent of Oracle's to_date('03/04/2005','MM/DD/YYYY')
  452. Comparing dates using date function and arithmetic
  453. db2LogRead API Error
  454. how to print a new line character
  455. Control Center lock
  456. accent insensitive diacritic insensitive data retrieval
  457. custom collating sequence
  458. generated column
  459. Stored procedures in SYSPROC schema
  460. primary =/=> unique?
  461. FP9 / can't find Apar GG04517
  462. FP9 installer breaks Information Center (Windows)
  463. Using LOWER function in DB2
  464. db2app.dll
  465. Creating Dataset from DataAdapter VS.Studio.NET & Db2
  466. db2 concurrency control question
  467. DB2 equivalent of Oracle to_char(created_date,'MM/DD/YYYY')
  468. How to define this kinds of constraint.
  469. Accessing Oracle from DB2 Stored Procedure
  470. Shameles self-promotion
  471. problems with UNION
  472. changing password
  473. unloading data from db2 v6 tables to os390
  474. Queston on DB2 lock
  475. SQL Stored Procedures X Java Stored Procedures in DB2 8.2
  476. Problem with sequence in UDB 8.2
  477. data warehouse
  478. DIA0001E An internal error occurred. Report the following error code : "ZRC=0x8136001C".
  479. SELECTing from multiple databases?
  480. Performance: CAF vs RRSAF
  481. Password invalid, when logging on as db2inst1 with a password
  482. SYSPROC.ENV_GET_INST_INFO() not working...
  483. Need good idea
  484. DB2 UDB v8.2 Fixpack 9 Problem starting Information Center
  485. tablespace move from 32K to 4K page size on same instance
  486. DB2 version info
  487. Error Installing ESE Fixpack 9 for Windows - Help Please
  488. error sqlriResolveOpFunc
  489. Quck question on port numbers for V8.X and HP
  490. Stored Procedures: RESULT SET.
  491. Stored procedures debugging.
  492. DB2 Fixpak 9 now available for LUW
  493. [Fwd: Double lock on iseries db2 ado.net transaction]
  494. Sr. Database Engineer Needed - Preferably DB2 (Silicon Valley)
  495. Help creating trigger
  496. db2 connect statement with current schema
  497. DB21015E - New Error with Fixpack 8?
  498. how to copy a clob column data......
  499. selecting data based on rowid
  500. federated database
  501. Simple question
  502. how to pass value to a stored procedure at runtime....
  503. SQL
  504. Clone a partial DB on Linux running in circular mode
  505. SET INTEGRITY question
  506. Help with an SQL Query
  507. Calling sqleintr or exit causes program (linux) to hang (due to deadlock by pthread)
  508. Cannot grant sysproc function to user
  509. DB2 Data directly into Microsoft Excel
  510. DB2 crash?!?
  511. UDB v 8.1 - SQL0925N SQL COMMIT invalid for application execution
  512. UDB v 8.1 on win2000 - SQL0925N SQL COMMIT invalid for application execution
  513. Connect to remote server using db2 and Perl
  514. Translate this Oracle Trigger ...
  515. Help with Oracle to DB2 trigger translation
  516. Row Locking issue
  517. event monitor -dropped default one
  518. Db2 server problem, Urgent please need suggestions
  519. Data Compression
  520. SEARCH / KNOWN discovery question
  521. Same statement, different application, different runtime
  522. If statement
  523. Passing a resultset from a nested Stored Procedure
  524. Cannot alocate 2,4 GB for Bufferpools, DB v 8.2.1 on AIX 5L
  525. problem running db2cc, DB2 v.8.2 on AIX
  526. Generating rows on the fly
  527. Please Help - DB2 Specialist Consultant Required
  528. sql1042C / sql1036C on create database?
  529. client v7 to connect v8.1 mts error
  530. DB2 Optimizer is not using Summary Table (DB2 V 8.1.7)
  531. Load commit
  532. INSERT INTO ... FROM NEW TABLE
  533. Problem when archiving log files
  534. DB2Advisor error
  535. How to configure windows with ibm db2 odbc driver?
  536. Proyectos de Inversion en IT en la Universidad Tecnologica Nacional
  537. DB2 SNMP Monitoring - Missing the Boat - Big Time
  538. JDBC Driver Defaults
  539. Client Access ODBC DB2 driver problem
  540. LDAP authentication for DB2
  541. Placing a Lock at record level in a table.
  542. Browsing through a table
  543. Federated database problem
  544. Calling stored procedure in a trigger
  545. How to view the status of DB2 Load utility on Windows/Unix
  546. what is the difference between cloudscape and derby?
  547. Problem DB2 connect with JDBC
  548. DB2 V6.1.027 Userexit problem
  549. Querying on table within a variable
  550. Problem with multiple rows insert on MVS OS 390